How to dump all the excel data to XML or JSON

Aspose.Cells Product Family
1

I want to dump the data from excel to XML or JSON. Is there a API which does this ?

Regards,
Azhar

2

Hi,


Well, I am afraid, we do not support to directly export Excel workbook data to general/ common XML file. Aspose.Cells does support SpreadsheetML file format (SaveFormat.SpreadsheetML) though which is MS Excel oriented XML representation of Excel data/ contents. I think you may try to save to SpreadsheetML (.xml) file if it suit your needs. Also you may try to fill a datatable or arrays and later on you may use your own codes via .NET APIs to convert to XML or JSON for your needs.

Thank you