I am trying to import a CSV file into an existing excel file. I do it like following
Worksheet exportWorksheet = templateWorkSheets.get(B_Reporttype.TEMPLATE_WORKSHEET);
exportWorksheet.getCells().importCSV(report.getDynamicReportDataFilePath().toString(), loadOptions, 0, 0);
When my CSV becomes larger (in my case 350 MB), I get an out of memory exception.
- What is the recommended way to import large text files to excel
- Is there a way to check whether we have enough memory to support the CSV file