Aspose Cell ExportXml returns only first row of Table data

Aspose.Cells Product Family
1

Hi

I have created a sample data for you. We are using aspose.cell 22.2 version.
We have xml table
mapping. The ExportXml returns only the first row data. I have attached the sample1.xml and Excel file for your reference.
Please let me know if you need any more information. We purchased the license.
THE DOCTORS MANAGEMENT COMPANY

Here is the C# code for your reference.

            var wb = new Workbook(@"C:\temp\DupeDebugWORKBOOK.xlsm");
            var ws = wb.Worksheets[0];

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

            var excelOutput = new MemoryStream();
            XmlMap mapoutput = wb.Worksheets.XmlMaps[1];
            wb.ExportXml(mapoutput.Name, excelOutput);
            StreamtoFileSave(excelOutput, @"C:\Temp\output.xml");

============
void StreamtoFileSave(Stream stream, String filePath)
{
using (var fileStream = File.Create(filePath))
{
stream.Position = 0;
stream.CopyTo(fileStream);
fileStream.Close();
}
}

sample1.zip (21.3 KB)

2

@rameshyahoo,

Thanks for the sample files.

Please notice, I am able to reproduce the issue as you mentioned by using your sample files. I found Workbook.ExportXml returns only the first row of Table data and same record is repeated number of times. I have logged a ticket with an id “CELLSNET-50478” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

@rameshyahoo,

This is to inform you that we have fixed your issue now. We will include the fix in our upcoming release: Aspose.Cells for .NET v22.3 which is scheduled to be published in March, 2022. You will be notified once the next version is released.

4

Hi Amjad

You guys are fast. I really appreciate such a good customer support.
Just I wanted to confirm, you mentioned Java. We are using Aspose.Cell for .Net.

Regards,
Ramesh

5

@rameshyahoo,

You are welcome.

My apologies. I meant Aspose.Cells for .NET v22.3. I have fixed it in my previous reply as well.

6

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