xlsdataset.java_数据导出到Excel（DataSet）

[asp]代码库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();

}

}