We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How to export a named range to file in the form of some XML

Hi,

Is there any way in Aspose to export a named range from Excel into an XML file ? Then I would like to apply an XSL over the XML.

Thanks,
Jaspreet

Hi,


Aspose.Cells is a spreadsheet management library used to create, manage or render MS Excel file formats. Well, you may try the following options, you may choose any one if it works for your needs.

1) You may try to save Excel file to SpreadsheetML file format which is an XML representation of spreadsheet (XML file) including all information about it if it suits your needs, see the document for file formats and conversions document for your reference:
http://www.aspose.com/docs/display/cellsjava/Saving+Files


2) You may try to export your desired Worksheet’s data to fill an Array, see the document for your reference:
http://www.aspose.com/docs/display/cellsjava/Exporting+Data+from+Worksheets
Then, you will have to use your own codes to create an XML file based on data in the arrays.

3) You have to get a named range data manually using Aspose.Cells APIs (see the document for your reference: http://www.aspose.com/docs/display/cellsjava/Named+Ranges) and then you will have to use your own codes to create an XML file based on that data.

Thank you.