using System; using System.Collections.Generic; using System.Text; using System.Reflection; using Microsoft.Office.Interop.Excel; using Microsoft.Office.Core; using System.Windows.Forms; namespace ExportExcelFile { ////// /// public class Class1 { private Microsoft.Office.Interop.Excel.Application m_app; private Microsoft.Office.Interop.Excel.Workbook m_wb; private Microsoft.Office.Interop.Excel.Worksheet m_ws; //private Microsoft.Office.Interop.Excel.Range m_rang; ////// /// private void test() { Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); if (xlApp == null) { Console.WriteLine("EXCEL could not be started. Check that your office installation and project references are correct."); return; } else Console.WriteLine("EXCEL started. Success"); xlApp.Visible = true; Console.ReadLine(); Workbook wb = xlApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); Worksheet ws = (Worksheet)wb.Worksheets[1]; if (ws == null) { Console.WriteLine("Worksheet could not be created. Check that your office installation and project references are correct."); } else Console.WriteLine("Worksheet be started. Success"); Console.ReadLine(); // Select the Excel cells, in the range c1 to c7 in the worksheet. Range aRange = ws.get_Range("C1", "C7"); if (aRange == null) { Console.WriteLine("Could not get a range. Check to be sure you have the correct versions of the office DLLs."); } else Console.WriteLine("Have get a range Success."); Console.ReadLine(); // Fill the cells in the C1 to C7 range of the worksheet with the number 6. Object[] args = new Object[1]; args[0] = 6; aRange.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, aRange, args); // Change the cells in the C1 to C7 range of the worksheet to the number 8. aRange.Value2 = 8; } ///public void CreateSheet(object[] strHeads, object[][] strRows) { try { m_app = new Microsoft.Office.Interop.Excel.Application(); if (m_app == null) { MessageBox.Show("无法打开Excel程序"); return; } m_app.Visible = true; m_wb = m_app.Workbooks.Add(Missing.Value); m_ws = (Microsoft.Office.Interop.Excel.Worksheet)m_wb.ActiveSheet; m_ws.Visible = XlSheetVisibility.xlSheetVisible; for (int i = 1; i <= strHeads.Length; ++i) { m_ws.Cells[1, i] = strHeads[i - 1]; } for (int j = 2; j <= strRows.Length + 1; ++j) { for (int i = 1; i <= strRows[j - 2].Length; ++i) { m_ws.Cells[j, i] = strRows[j - 2][i - 1]; } } } catch (Exception ex) { MessageBox.Show(ex.Source + ":" + ex.Message); } } public void CreateSheetEx(ListView listView1) { try { m_app = new Microsoft.Office.Interop.Excel.Application(); if (m_app == null) { MessageBox.Show("无法打开Excel程序"); return; } m_app.Visible = true; m_wb = m_app.Workbooks.Add(Missing.Value); m_ws = (Microsoft.Office.Interop.Excel.Worksheet)m_wb.ActiveSheet; m_ws.Visible = XlSheetVisibility.xlSheetVisible; for (int i = 1; i <= listView1.Columns.Count; ++i) { m_ws.Cells[1, i] = listView1.Columns[i - 1].Text; } for (int j = 2; j <= listView1.Items.Count + 1; ++j) { for (int i = 1; i <= listView1.Items[j-2].SubItems.Count; ++i) { m_ws.Cells[j, i] = listView1.Items[j-2].SubItems[i-1].Text; } } } catch (Exception ex) { MessageBox.Show(ex.Source + ":" + ex.Message); } } } }
C#导出数据到Excel类
最新推荐文章于 2024-04-26 15:44:16 发布