Excel to html missing rows

Aspose.Cells Product Family
,
1

Hi,

When converting an xlsx file to html, I noticed that Aspose doesn’t include the empty rows whereas Excel does. The xlsx file has text “A” in cell A1 as well as “Date” formatting in column C and “General” formatting in cells C1 to C100. Excel includes all 100 rows in the html and Aspose includes only the first row. Would you be able to tell me if there is a reason why Aspose behaves differently?

I have included the code and testing files that can reproduce the issue

Code:
var wb = new Workbook("./Test.xlsx");
wb.Save("./TestAspose.html");

Files:
TestMissingRows.zip (9.5 KB)

Thanks,
N

2

@ServerSide527,
We have observed the difference and logged it in our database for further investigation. You will be notified here once any update is ready for sharing.

This issue is logged as:
CELLSNET-47985 - Less number of rows rendered to HTML as compared to MS Excel

3

@ServerSide527,

This is to notify you that the issue has been resolved. After running QA and incorporating other enhancements and fixes, we will provide a fixed version soon.

4

@ServerSide527,
Please try our latest version/fix: Aspose.Cells for .NET v21.4.1 (attached)
Aspose.Cells21.4.1 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.4.1 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.4.1 For .NetStandard20.Zip (5.5 MB)

Your issue should be fixed in it.
Let us know your feedback.

5

Hi @John.He

Thank you for providing the latest version/fix. The reported issue seems to be fixed and the missing rows are no longer an issue.

However, I noticed a difference between the old and new versions where additional and tags were added in the HTML. The worksheet was also updated and after wb.Save(…) there were additional Columns.

I have included the code and testing file to reproduce the difference below.

Code:
var wb = new Workbook("./Test.xlsx");
Console.WriteLine(wb.Worksheets[0].Cells.Columns.Count); // prints 11
wb.Save("./TestAspose.html");
Console.WriteLine(wb.Worksheets[0].Cells.Columns.Count); // prints 15

Files:
TestAsposeNewVersion.zip (24.0 KB)

Screenshots:
TestAsposeNewVersion.PNG (17.0 KB)
TestAsposeOldVersion.PNG (20.5 KB)
TestAsposeNewVersion2.PNG (6.7 KB)
TestAsposeOldVersion2.PNG (6.6 KB)

Thanks,
N

6

@ServerSide527,
We have observed the reported issue of increased number of columns with the latest hot fix and logged it in our database for further analysis.

7

@ServerSide527,
For managing issues accurately, we have created a new ticket “CELLSNET-47997” to trace additional columns are created after saving file to html.

8

@ServerSide527,
Please try our latest fix v21.4.2:

Aspose.Cells21.4.2 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.4.2 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.4.2 For .NetStandard20.Zip (5.5 MB)

Your issue should be fixed in it.

Let us know your feedback.

9

The issues you have found earlier (filed as CELLSNET-47985,CELLSNET-47997) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao