Import XML Map inside a Workbook using Aspose.Cells

Aspose.Cells Product Family
41

Hi,

Thanks for your posting and using Aspose.Cells.

Yes, it is also available in
Aspose.Cells for Java 8.7.0.

Please see this document for your reference. This is for Java version.

( Import XML Map inside a Workbook using Aspose.Cells|Documentation )

42

Hi,



I tried Aspose.Cells for importing XML Maps but unlike to Excel all the data are always imported even if we define an array with only some columns that are related to the xml map



Is there a way to fill only the columns that are defined in the array like Excel does when importing XML data ?



Regards

43

Hi,

Thanks for your description of the issue, screenshots and using Aspose.Cells.

It will be helpful if you could also provide us the xml files as you have shown in the screenshots as well as console application project containing your code.

We will then evaluate it and add it as a New Feature to support your needs. Thanks for your cooperation.

44

Hello,



Attached you will find a sample program and the xml files that show the requested behaviour.



I’ve also addeed a new word document that explain more precisely what we are doing now and the expected result when using Aspose.cells



Regards,



Judicaël.

45

Hi Judicaël,

Thanks for your further information and considering Aspose.Cells.

We have logged your requirement as a New Feature in our database for investigation and implementation. We will look into it and implement it if possible. Once there is some fix or other news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-44374 - Import xml map by defining an array of only some columns that are related to the xml map

46

Hi again,


This is to update you that we have resolved the problem logged earlier as CELLSNET-44374. We will shortly share the fix here for your testing.
47

Hi,


Please try our latest version/fix: Aspose.Cells for .NET 9.0.1.0 against the issue logged earlier as “CELLSNET-44374”.
Please see the APIs:
Workbook.ImportXml(string
url,string sheetName,int row, int col). If XmlMap doesn’t exist, it will import the whole xml data to sheet. If XmlMap exist, it will update the data of the xmlMap linked cells in
workbook.
e.g
Sample code:

Workbook wb = new Workbook(TestAspose.xlsm);

wb.ImportXml(FullXMLImport.xml, "Cover sheet", 0, 0);

wb.Save(outFile.xlsx);

Thank you.

48

The issues you have found earlier (filed as CELLSNET-44374) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.