C# 导出Excel
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
namespace test2
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application m_objExcel = null;
Microsoft.Office.Interop.Excel._Workbook m_objBook = null;
Microsoft.Office.Interop.Excel.Sheets m_objSheets = null;
Microsoft.Office.Interop.Excel._Worksheet m_objSheet = null;
Microsoft.Office.Interop.Excel.Range m_objRange = null;
object m_objOpt = System.Reflection.Missing.Value;
try
{
m_objExcel = new Microsoft.Office.Interop.Excel.Application();
//m_objBook = m_objExcel.Workbooks.Open("e:\\Book2.xls", m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objBook = m_objExcel.Workbooks.Add(System.Reflection.Missing.Value);
m_objSheets = (Microsoft.Office.Interop.Excel.Sheets)m_objBook.Worksheets;
m_objSheet = (Microsoft.Office.Interop.Excel._Worksheet)(m_objSheets.get_Item(1));
string[] info = new string[5] { "Cure", "26", "dahuzizyd.cnblogs.com", "汉", "按时 ?放奥斯丁奥斯丁非是否奥斯丁非" };
//m_objRange = m_objSheet.get_Range("B1", m_objOpt);
//m_objRange.Value = info[0];
//m_objRange = m_objSheet.get_Range("E1", m_objOpt);
//m_objRange.Value = info[1];
//m_objRange = m_objSheet.get_Range("B2", m_objOpt);
//m_objRange.Value = info[2];
//m_objRange = m_objSheet.get_Range("E2", m_objOpt);
//m_objRange.Value = info[3];
//m_objRange = m_objSheet.get_Range("A3", m_objOpt);
//m_objRange.Value = info[4];
m_objExcel.Cells[1, 1] = "1,1";
m_objExcel.Cells[1, 2] = "1,2";
m_objExcel.DisplayAlerts = true;
m_objBook.SaveAs("e:\\Book2.xlsx", m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
m_objOpt, m_objOpt, m_objOpt, m_objOpt);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
m_objBook.Close(m_objOpt, m_objOpt, m_objOpt);
m_objExcel.Workbooks.Close();
m_objExcel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(m_objExcel);
m_objBook = null;
m_objExcel = null;
GC.Collect();
}
}
}
}
posted on 2012-04-12 15:55 NewProgramer 阅读(158) 评论(0) 收藏 举报
浙公网安备 33010602011771号