How to keep empty row when convert excel to html

Aspose.Cells Product Family
1

Hi,
I am using aspose-20.12. I want to convert excel to html and not remove empty row. I had searched the document, but not found some useful information. could you give me some advice? thanks.
excel-normal2.zip (24.1 KB)

 Workbook workbook = new Workbook("excel-normal2.xlsx");
 Worksheet worksheet = workbook.getWorksheets().get(0);
 Cells cells = worksheet.getCells();
 for (int i = 0; i < cells.getRows().getCount(); i++) {
     cells.get(i, 0);
 }
 System.out.println(cells.getRows().getCount()); // result is 3, but the html file only have one row
 workbook.save("normal2.html");
2

@xuerui
By using sample files and code for testing on the latest version v24.5, we can obtain the correct results. Please refer to the attachment. result.zip (6.2 KB)

3

Is there any other way than upgrading the version?

4

@xuerui
Sorry, there are no other alternative solution. if you keep using an older version (Aspose.Cells for Java v20.12), it won’t help you much. We couldn’t use the old version to evaluate the issue, nor could the old version include fixes or enhancements. All enhancements and fixes are based only on the latest API set.

In short, try to upgrade to the latest version and use it. Please let us know if you still find any issues. We will check it soon.

5

@xuerui
After further research, as an alternative, you can set a blank character on the last line to achieve the goal of outputting a blank line at the end. Please refer to the following code.

The sample code as follows:

 Workbook workbook = new Workbook(filePath + "excel-normal2.xlsx");
 Worksheet worksheet = workbook.getWorksheets().get(0);
 Cells cells = worksheet.getCells();
 for (int i = 0; i < cells.getRows().getCount(); i++) {
     cells.get(i, 0);
     
 }
 //add this line
 cells.get(2, 0).putValue(" ");
 System.out.println(cells.getRows().getCount()); // result is 3, but the html file only have one row
 workbook.save(filePath + "normal2.html");

Hope helps a bit.