Hi,
I’m trying to export an XLS file to CSV format, but the empty rows from the XLS are represented as empty lines in CSV, when they should have been a list of commas.
This is a sample code:
Workbook book = new Workbook(new FileInputStream("C:\\temp\\test.xls"), new LoadOptions(LoadFormat.EXCEL_97_TO_2003));
BufferedOutputStream writer = new BufferedOutputStream(new FileOutputStream("C:\\temp\\saved_from_aspose.csv", true), 2048);
for (int i = 0; i < book.getWorksheets().getCount(); i++) {
book.getWorksheets().setActiveSheetIndex(i);
book.save(writer, SaveFormat.CSV);
}
writer.close();
We are using Aspose.Cells for Java, version 7.1.0.
The export works as expected on version 2.4.3.
Please advise.
Thank you!