Convert xml to excel

Aspose.Cells Product Family
1

Hi,

I used the converter from the link below and found that there are fields that exist in xml, but are missing in xls:

I converted the same xml with another converter and the resulting xls file was complete.

Is your converter version unfinished?
Thank you!

2

@adn2023,
Would you like to provide your sample XML file? We will check it soon.

3

TEST.zip (24.3 KB)

I have attached an archive containing the xml file, the xlsx file generated on your site and the xlsx generated on another site. As you can see, in your xlsx the columns from AX to CR are missing, which are found in the other generated xlsx.

4

@adn2023,
Through testing, we were able to reproduce the issue and discovered the situation of data loss.
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-53551
5

@adn2023
If you do not need nested structure, please map the xml to Excel as the following:

 XmlLoadOptions options = new XmlLoadOptions();
            options.IsXmlMap = true;
            Workbook lc_WorkBook = new Aspose.Cells.Workbook(dir + "test.xml", options);
6

A nested structure is preferable. But the most important thing is that the information is complete. Is there a possibility that the converter here can convert to excel without data loss?

7

@adn2023,
The underlying layer of the converter also calls the Aspose.Cells library for conversion, so there may also be data loss. We have already created a ticket and will study and repair it soon. Once there are updates, we will notify you in time.

8

@adn2023
Please check 23.6.2.zip (15.1 KB)
which generated by 23.6.2 with the following codes:

 XmlLoadOptions options = new XmlLoadOptions();
            options.IgnoreRootAttributes = true;
            Workbook lc_WorkBook = new Aspose.Cells.Workbook(dir + "test.xml", options);
            lc_WorkBook.Save(dir + "dest.xlsx");

Is it your excepted file?

9

The file you attached is ok.
Thank you!

10

@adn2023
Thanks for your confirmation.
We will include this fix into the next version 23.7 which will be released in the next month.

11

Can’t the correction be made earlier than July?
Thank you.

12

@adn2023
We have to deliver their fixes according to the terms mentioned in Free Support Policies.

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

13

The issues you have found earlier (filed as CELLSNET-53551) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi