giammin

Aspose.Cells create excel from a list of object

May 9th, 2013
223
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.51 KB | None | 0 0
  1. public static void CreateXls(IList<ExportItem> exportItems, string file)
  2. {
  3.     var workbook = new Workbook();
  4.     Worksheet worksheet = workbook.Worksheets[0];
  5.     Cells cells = worksheet.Cells;
  6.     cells.ImportCustomObjects(new Collection<ExportItem>(exportItems),
  7.         new[] { "ExportCode", "Topic", "Title", "Name", "LastName", "Email", "NewFileName", "NewLicenseAgreement" },
  8.         true, 0, 0, exportItems.Count, true, "dd/MM/yyyy HH:mm", false);
  9.     worksheet.AutoFitColumns();
  10.     workbook.Save(file, SaveFormat.Excel97To2003);
  11. }
Advertisement
Add Comment
Please, Sign In to add comment