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

Free Support Forum - aspose.com

How to dump all the excel data to XML or JSON

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



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