《msdn导出excel教程.docxVIP

// Excel object references. private Excel.Application m_objExcel = null; private Excel.Workbooks m_objBooks = null; private Excel._Workbook m_objBook = null; private Excel.Sheets m_objSheets = null; private Excel._Worksheet m_objSheet = null; private Excel.Range m_objRange = null; private Excel.Font m_objFont = null; private Excel.QueryTables m_objQryTables = null; private Excel._QueryTable m_objQryTable = null; // Frequenty-used variable for optional arguments. private object m_objOpt = System.Reflection.Missing.Value; // Paths used by the sample code for accessing and storing data. private object m_strSampleFolder = C:\\ExcelData\\; private string m_strNorthwind = C:\\Program Files\\Microsoft Office\\Office10\\Samples\\Northwind.mdb; private void Form1_Load(object sender, System.EventArgs e) { comboBox1.DropDownStyle = ComboBoxStyle.DropDownList; comboBox1.Items.AddRange(new object[]{ Use Automation to Transfer Data Cell by Cell , Use Automation to Transfer an Array of Data to a Range on a Worksheet , Use Automation to Transfer an ADO Recordset to a Worksheet Range , Use Automation to Create a QueryTable on a Worksheet, Use the Clipboard, Create a Delimited Text File that Excel Can Parse into Rows and Columns, Transfer Data to a Worksheet Using ADO.NET }); comboBox1.SelectedIndex = 0; button1.Text = Go!; } private void button1_Click(object sender, System.EventArgs e) { switch (comboBox1.SelectedIndex)