Asp.net & Aspose.cells 导出

  protected void btnExport_Click(object sender, EventArgs e)
    {
        DataTable tbBooks = (DataTable)Session["Books"];
        if (tbBooks == null)
        {
            return;
        }13         try
        {
            Workbook newWorkBook = NewExcel();
            Aspose.Cells.Worksheet newSheet = newWorkBook.Worksheets[0];
            Cells newCells = newSheet.Cells;

            if (tbBooks != null)
            {
                for (int i = 0; i < tbBooks.Rows.Count; i++)
                {25                     for (int j = 0; j < tbBooks.Columns.Count; j++)
                    {28                         newCells[i+1, j].PutValue(tbBooks.Rows[i][j].ToString());
                    }
                }
            }
            newWorkBook.Save("result.xlsx", Aspose.Cells.FileFormatType.Excel97To2003, Aspose.Cells.SaveType.OpenInExcel, Response);
        }
        catch (Exception ex)
        {
            MessageBox.Show(this, "导出产品信息库出错，详细错误为：" + ex.Message);
        }
    }

    public Workbook NewExcel()
    {
        DataTable table = (DataTable)Session["Books"];
        Workbook newWorkBook = new Workbook();
        Aspose.Cells.Worksheet sheet = newWorkBook.Worksheets[0];
        Cells cells = sheet.Cells;

        Aspose.Cells.Style style = newWorkBook.Styles[newWorkBook.Styles.Add()];//新增样式
        style.HorizontalAlignment = TextAlignmentType.Center;
        style.Font.Size = 14;
        style.Font.Color = System.Drawing.Color.Red;
        cells.SetRowHeight(0, 20);

        for (int i = 0; i < table.Columns.Count; i++)
        {
            cells[0, i].PutValue(table.Columns[i].ColumnName);
            cells[0, i].SetStyle(style);
            cells.SetColumnWidthPixel(i, 150);
        }
        return newWorkBook;
    }