小白总结,大神勿喷。
Excel文件样式需要自己微调
Aspose 类库可以不购买(生成的文件最后一个Sheet有水印)
private void downLoadExcel(string ExcelName, DataTable DT)
{
License license = new License();
license.SetLicense("Aspose.Cells.lic");
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Cells.ImportDataTable(DT, true, "A1");
Aspose.Cells.Style s = workbook.CreateStyle();
s.ForegroundColor = System.Drawing.Color.Gray;
s.Pattern = Aspose.Cells.BackgroundType.Solid;
Aspose.Cells.Range r = worksheet.Cells.CreateRange(0, 0, 1, DT.Columns.Count);
r.SetStyle(s);
Cells cells = worksheet.Cells;
cells.StandardHeight = 18;
cells.StandardWidth = 15;
workbook.Save(Response, HttpUtility.UrlEncode(ExcelName, System.Text.Encoding.UTF8) + ".xls", ContentDisposition.Attachment, new XlsSaveOptions(SaveFormat.Excel97To2003));
}