XmlMaps

Aspose.Cells Product Family
1

Is there associated property for XMlMaps to get the RootElementName for the map like there is in Excel?

Also, is there XmlMapQuery like functionality available in Excel ?
e.g.

Range XmlMapQuery(string XPath, object SelectionNamespaces, object Map);

If not, any chance it could be added?

Thanks,
Dean

2

@Hogtooth

Thanks for considering Aspose APIs.

Please provide us more information regarding your query. Please provide us some Excel file(s) or screenshots that explain what you are trying to achieve.

Please also see these articles regarding XmlMaps for more help.

3

It would be kind of the opposite of LinkToXml Map.

The query returns the range associated with the path.
Attached is an xlsm demonstrating the usage of XmlMapQuery (16.8 KB)

4

@Hogtooth

Do you want us to add this feature in Aspose.Cells? Could you provide some articles that explain the usage of this method?

  • Worksheet.XmlMapQuery Method (Excel)
5

Yes, please implement this feature.
The attached Excel file has example code.

Dean Kinnear

6

@Hogtooth

Thanks for your feedback and considering Aspose APIs.

We have logged your requirements as

  • CELLSNET-45747 - Associated property needed for XMLMaps to get the RootElementName for the map like there is in Excel
  • CELLSNET-45748 - XmlMapQuery like functionality needed as available in Excel
7

@Hogtooth

Thanks for using Aspose APIs.

This is to inform you that we have fixed your logged issues now. We will soon provide the fix after performing QA and including other enhancements and fixes.

8

The issues you have found earlier (filed as CELLSNET-45747;CELLSNET-45748) have been fixed in this Aspose.Cells for .NET 17.11 update.

Please also check the following article: