HTML wrong when some rows are hidden

Workbook wb = new Workbook("C:/分组4.xlsx");
HtmlSaveOptions options = new HtmlSaveOptions();
options.setExportActiveWorksheetOnly(true);
wb.save("C:/分组4.html", options);

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue by executing your sample code with your sample excel file using the latest version:
Aspose.Cells for Java v8.7.1.4 and found that HTML is wrong when some rows are hidden.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSJAVA-41794 - HTML is wrong when some rows are hidden

I have also attached the output html generated with the following code for a reference.

Java
String filePath = “D:\Downloads\s.xlsx”;

Workbook wb = new Workbook(filePath);

HtmlSaveOptions options = new HtmlSaveOptions();
options.setExportActiveWorksheetOnly(true);
wb.save(filePath + “.out.html”, options);

@xhaixia,

We are pleased to inform you that your issue has been resolved. The fix will be included in our upcoming release (Aspose.Cells v23.3) that we plan to release in the first half of March 2023. You will be notified when the next version is released.

The issues you have found earlier (filed as CELLSJAVA-41794) have been fixed in Aspose.Cells for Java 23.3.