Excel.Application excel=new Microsoft.Office.Interop.Excel.Application();
Excel.Workbook excelBook = excel.Workbooks.Add(Type.Missing);
Excel.Worksheet excelSheet = (Excel.Worksheet)excelBook.ActiveSheet;
excel.Visible = true;
try
{
DataTable dt = GetTable();
DataTableToExcel(dt, excelSheet);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(excel);
excel = null;
GC.Collect();
}
}
public void DataTableToExcel(DataTable dt, Excel.Worksheet excelSheet)
{
int rowCount = dt.Rows.Count;
int colCount = dt.Columns.Count;
object[,] dataArray = new object[rowCount+1, colCount];
for (int k = 0; k < colCount; k++)
{
dataArray[0, k] = dt.Columns[k].ColumnName;
}
for (int i = 0; i < rowCount; i++)
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载