Aspose.Cells 导出 excel

Aspose.Cells.Workbook book = new Aspose.Cells.Workbook();
Aspose.Cells.Worksheet sheet = book.Worksheets["Sheet1"];
sheet.FreezePanes(1, 1, 1, 0);

Aspose.Cells.Style style = book.Styles[book.Styles.Add()];
style.Pattern = Aspose.Cells.BackgroundType.Solid;


style.Borders.SetStyle(Aspose.Cells.CellBorderType.Thin);
style.Borders.SetColor(System.Drawing.Color.LightSteelBlue);
style.IsTextWrapped = true;
style.Font.Size = 10;


Aspose.Cells.StyleFlag flag = new Aspose.Cells.StyleFlag();
flag.All = true;

sheet.Cells.ApplyStyle(style, flag);

style.VerticalAlignment = Aspose.Cells.TextAlignmentType.Center;
style.Font.IsBold = true;
flag.All = true;

sheet.Cells.Rows[0].ApplyStyle(style, flag);

sheet.Cells.ImportDataTable(dt, true, 0, 0, dt.Rows.Count, dt.Columns.Count, false, "yyyy-MM-dd", false);

book.Save(DateTime.Now.ToString("yyyyMMddhhmmss") + ".xlsx", Aspose.Cells.FileFormatType.Excel2007Xlsx, Aspose.Cells.SaveType.OpenInExcel, Response);

posted on 2013-10-16 16:22  lanyue52011  阅读(1265)  评论(0编辑  收藏  举报

导航