会python真的可以为所欲为0(回)
398天前
这里还有人吗1(回)
583天前这里还有人吗0(回)
583天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
807天前到处都是羊，不想上班0(回)
887天前
鸽子
0(回)
892天前static class ExportingCellByCellMethod |
{ |
public static void ExportToExcel ( DataSet dataSet, string outputPath ) |
{ |
// Create the Excel Application object |
ApplicationClass excelApp = new ApplicationClass(); |
// Create a new Excel Workbook |
Workbook excelWorkbook = excelApp.Workbooks.Add ( Type.Missing ); |
int sheetIndex = 0; |
// Copy each DataTable as a new Sheet |
foreach ( System.Data.DataTable dt in dataSet.Tables ) |
{ |
// Create a new Sheet |
Worksheet excelSheet = ( Worksheet ) excelWorkbook.Sheets.Add ( |
excelWorkbook.Sheets.get_Item ( ++sheetIndex ), |
Type.Missing, 1, XlSheetType.xlWorksheet ); |
excelSheet.Name = dt.TableName; |
// Copy the column names (cell-by-cell) |
for ( int col = 0; col < dt.Columns.Count; col++ ) |
{ |
excelSheet.Cells[1, col + 1] = dt.Columns[col].ColumnName; |
} |
( ( Range ) excelSheet.Rows[1, Type.Missing] ).Font.Bold = true; |
// Copy the values (cell-by-cell) |
for ( int col = 0; col < dt.Columns.Count; col++ ) |
{ |
for ( int row = 0; row < dt.Rows.Count; row++ ) |
{ |
excelSheet.Cells[row + 2, col + 1] = dt.Rows[row].ItemArray[col]; |
} |
} |
} |
// Save and Close the Workbook |
excelWorkbook.SaveAs ( outputPath, XlFileFormat.xlWorkbookNormal, Type.Missing, |
Type.Missing, Type.Missing, Type.Missing, XlSaveAsAccessMode.xlExclusive, |
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing ); |
excelWorkbook.Close ( true, Type.Missing, Type.Missing ); |
excelWorkbook = null; |
// Release the Application object |
excelApp.Quit(); |
excelApp = null; |
// Collect the unreferenced objects |
GC.Collect(); |
GC.WaitForPendingFinalizers(); |
} |
} |
by: 发表于：2017-11-14 10:32:17 顶(0) | 踩(0) 回复
？？
回复评论