Opening HTML with Aspose -- Ignores empty table cells

Hi,

I am using Aspose to open/convert HTML files into Excel XLSX files. Our HTML files are reports that typically consist of a table of data.

The problem I am having is that Aspose fails to handle an empty table cell if it doesn’t have a fully formed closing tag. For instance, this will look fine in the resulting Excel file:

1 2 4

But this will not – the third table cell is ignored entirely, and the data for the 4th column is incorrectly put in the 3rd column. This causes big inaccuracy problems with the data in Excel.

1 2 4

I understand that I could simply modify my HTML to always have a full closing tag, but I don’t have much control over the generation of the HTML file. And, anyways, the html is valid and not complicated. Aspose Cells should have no problem handling a tag formatted in this way. bugsample.zip (6.8 KB)

Attached is a very simple HTML file and resulting XLSX that Aspose Cells generates when opening it.

Can you please modify Aspose Cells so it recognizes an empty tag like “” ??

Thanks.

Reposting text so HTML code looks right:

I am using Aspose to open/convert HTML files into Excel XLSX files. Our HTML files are reports that typically consist of a table of data.

The problem I am having is that Aspose fails to handle an empty table cell if it doesn’t have a fully formed closing tag. For instance, this will look fine in the resulting Excel file:

  <tr>
    <td>1</td>
    <td>2</td>
    <td></td>
    <td>4</td>
  </tr>

But this will not – the third table cell is ignored entirely, and the data for the 4th column is incorrectly put in the 3rd column. This causes big inaccuracy problems with the data in Excel.

  <tr>
    <td>1</td>
    <td>2</td>
    <td />
    <td>4</td>
  </tr>

I understand that I could simply modify my HTML to always have a full closing tag, but I don’t have much control over the generation of the HTML file. And, anyways, the html is valid and not complicated. Aspose Cells should have no problem handling a tag formatted in this way.

Attached is a very simple HTML file and resulting XLSX that Aspose Cells generates when opening it.

Can you please modify Aspose Cells so it recognizes an empty tag such as the below:
<td />

bugsample.zip (6.8 KB)

Thanks.

@mikebruner,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46353 - Recognise empty tags while converting Html to Excel file

1 Like

@mikebruner,

Please try our latest version/fix: Aspose.Cells for .NET v18.9.4 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells18.9.4 For .Net2_AuthenticodeSigned.Zip (4.6 MB)

I did a quick test and it looks good, thank you.

@mikebruner,

Good to know that your issue is sorted out by the hew fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

The issues you have found earlier (filed as CELLSNET-46353) have been fixed in Aspose.Cells for .NET v18.10. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi