Excel Worksheets to JSON


#1

Hello,

I’ve got a multi-worksheet workbook that I’d like to selectively save worksheets as a JSON files. Simply, if I have a workbook with worksheets 1, 2 and 3, I’d like to save worksheet 1 and 3 to JSON. Is there a way to do this? I see lots of support for importing JSON but not too much in terms of exporting a worksheet to JSON.

Thanks!


#2

@fischp,

Thanks for your query.

Well, I am afraid, we do not support to directly export Excel workbook data to general/ common XML or JSON file(s). 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 to convert to XML or JSON for your needs.


#3

Thank you, I’ll give your recommandations a try.

Regards