Presently I use Aspose Cells to generate some Excel based reports via email. I looked at smart tags and they weren’t suitable, as I generate various results with LINQ queries and the columns vary each time.
I use the following method:
// Place data and format header.
sheet.Cells.ImportDataTable(inputData, true, dataStartRow - 1, dataStartCol, inputData.Rows.Count,
inputData.Columns.Count, false, “dd/mm/yyyy”);
However, this requires a DataTable object - and particularly for large datasets, converting to a datatable can take many minutes. Is there a method where I can use an anonymous collection without needing to make a DataTable first?