ImportXML function Table data taking from wrong record


#1

Hi

Our company is evaluating the Aspose.Cell product. One of the requirement is that we need to xml mapping for the table, and bring the data from the XML file.

I have attached the sample excel file and the xml file.

You can see the N2 column data should empty, it is getting 7500. and the N4 Column also getting 7500. It should be blank.

I am testing with 19.9 version.

Here is the C# code.

Workbook wb = null;
try
{
wb = new Workbook(@“C:\LTCTEST.xlsx”);

            var ws = wb.Worksheets[0];

            wb.ImportXml(@"C:\Input.xml", ws.Name, 0, 0);

            wb.Save(@"C:\output.xlsx");
        }
        catch
        {

        }

Sample.zip (11.1 KB)

I will appreciate for the help. Let me know if you have any questions.

Regards,
Ramesh


#2

@rameshpatra,
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-46943 - ImportXML function Table data taking from wrong record

#3

Thank you for the quick response. I will watch for the new version. I have few more issues on the ImportXML for table data. I will send you the sample xml and xlsx also.

Regards,
Ramesh


#4

@rameshpatra,
You are welcome and please feel free to share the details of other issues along with supporting data and runnable sample code. If possible, please create new threads as it helps in maintaining the relevant detail and data for future reference.


#5

@rameshpatra,

Please try our latest version/fix (.NET and Java): Aspose.Cells v19.9.3 (attached)
(Please choose/download the appropriate fix for your underlying platform/language)

Your issue should be fixed in it.

Let us know your feedback.
[.NET]
Aspose.Cells19.9.3 For .Net2_AuthenticodeSigned.Zip (4.9 MB)
Aspose.Cells19.9.3 For .Net4.0.Zip (4.9 MB)
Aspose.Cells19.9.3 For .NetStandard20.Zip (4.1 MB)

[Java]
Aspose_Cells_Java_v19.9.3.zip (6.6 MB)