Excel 97应用技巧
odbc 读写 Exce
[转载]
public void DowonExcel(string path, string[] title, List<List<string>> list)
{
object value = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.Application Excel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbooks workbooks = (Microsoft.Office.Interop.Excel.Workbooks)Excel.Workbooks;
Microsoft.Office.Interop.Excel.Workbook workbook = (Microsoft.Office.Interop.Excel.Workbook)workbooks.Add(value);
Microsoft.Office.Interop.Excel.Sheets sheets = (Microsoft.Office.Interop.Excel.Sheets)workbook.Worksheets;
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];
for (int i = 0; i <title.Length; i )
{
worksheet.Cells[1, i 1] = title[i];
}
int row = 2;
foreach (List<string> details in list)
{
for (int k = 1; k <details.Count 1; k )
{
worksheet.Cells[row, k] = details[k - 1];
}
row ;
}
worksheet.Columns.AutoFit();
System.Windows.Forms.Application.DoEvents();
workbook.Saved = true;
workbook.SaveCopyAs(path);
}
[转载]原文链接: http://renhuaniang.bokee.com/viewdiary.28699904.html
