I am facing out of memory issue while dumping data from datatable to excel.
It has 1 Million data and i tried the below code:
Dim workbook As New Aspose.Cells.Workbook(FileFormatType.Xlsx)
workbook.Settings.MemorySetting = MemorySetting.MemoryPreference
Dim workSheet As Aspose.Cells.Worksheet = workbook.Worksheets(0)
workSheet.Name = fileName
workSheet.Cells.ImportDataTable(dtInput, True, “A1”)
I am using trial version of Aspose.Cells 8.0 and wanted to buy license for this.