Asp.net 导出Excel 处理科学计算法

 

public static void doExport(DataSet ds, string strExcelFileName) {

    Excel.Application excel = new Excel.Application();

    int rowIndex = 1;
    int colIndex = 0;

    excel.Application.Workbooks.Add(true);

    System.Data.DataTable table = ds.Tables[0];
    foreach(DataColumn col in table.Columns) {
        colIndex++;
        excel.Cells[1, colIndex] = col.ColumnName;
    }

    foreach(DataRow row in table.Rows) {
        rowIndex++;
        colIndex = 0;
        Excel.Range range;
        foreach(DataColumn col in table.Columns) {
            colIndex++;
            string type = col.DataType.ToString();
            range = (Excel.Range) excel.Cells[rowIndex, colIndex];

            switch (type) {
            case "System.String":
                range.NumberFormatLocal = "@";
                break;
            case "System.DateTime":
                range.NumberFormatLocal = "yyyy-mm-dd";
                range.ColumnWidth = 10;
                break;
            }
            excel.Cells[rowIndex, colIndex] = row[col.ColumnName].ToString();

        }
    }
    excel.Visible = false;
    excel.ActiveWorkbook.SaveAs

    (strExcelFileName, Excel.XlFileFormat.xlExcel9795, null, null, false, false, Excel.XlSaveAsAcce

    ssMode.xlNoChange, null, null, null, null);

    excel.Quit();
    excel = null;

    GC.Collect();
}