用.NET 操作Excel编程;

引用：D:\Program Files\Microsoft Office\Office\EXCEL9.OLB  1. 创建一个新Excel的Application:  Application exc = new Application();  if (exc == null) {  Console.WriteLine("ERROR: EXCEL couldn't be started");  return 0;  }  2. 让这个工程可见:  exc.set_Visible(0, true);  3. 获取WorkBooks集合:  Workbooks workbooks = exc.Workbooks;  4. 加入新的WorkBook:  _Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet, 0);  5. 获取WorkSheets集合:  _Worksheet worksheet = (_Worksheet) sheets.get_Item(1);  if (worksheet == null) {  Console.WriteLine ("ERROR in worksheet == null");  }  6. 给单元格设置变量：  Range range1 = worksheet.get_Range("C1", Missing.Value);  if (range1 == null) {  Console.WriteLine ("ERROR: range == null");  }  const int nCells = 1;  Object[] args1 = new Object[1];  args1[0] = nCells;  range1.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, range1, args1);  例程:  using System;  using System.Reflection;  using System.Runtime.InteropServices;  using Excel;  class Excel {  public static int Main() {  Application exc = new Application();  if (exc == null) {  Console.WriteLine("ERROR: EXCEL couldn't be started!");  return 0;  }  exc.set_Visible(0, true);  Workbooks workbooks = exc.Workbooks;  _Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet, 0);  Sheets sheets = workbook.Worksheets;  _Worksheet worksheet = (_Worksheet) sheets.get_Item(1);  if (worksheet == null) {  Console.WriteLine ("ERROR: worksheet == null");  }  Range range1 = worksheet.get_Range("C1", Missing.Value);  if (range1 == null) {  Console.WriteLine ("ERROR: range == null");  }  const int nCells = 1;  Object[] args1 = new Object[1];  args1[0] = nCells;  range1.GetType().InvokeMember("Value", BindingFlags.SetProperty, null,range1, args1);  return 100;  }  }  现在我们来看看如何使用数组，他有些类似于设置单元格。仅仅需要的改变只是args2[0] = array2;  const int nCell = 5;  Range range2 = worksheet.get_Range("A1", "E1");  int[] array2 = new int [nCell];  for (int i=0; i < array2.GetLength(0); i++) {  array2[i] = i+1;  }  Object[] args2 = new Object[1];  args2[0] = array2;  range2.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, range2, args2);