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)    收藏  举报

导航