Export xlsb to Json

Aspose.Cells Product Family
, ,
1

Team,

We have a data with 10000+ rows and 1000 + columns in a worksheet. We want export it to Json for further processing. Could you please let us know if this can be done using Aspose.Cells ? If yes, How?

2

@susoma,

Aspose.Cells does support to export data from Excel spreadsheet to JSON. See the following sample code for your reference:
e.g.
Sample code:

// load XLS file with an instance of Workbook
var workbook = new Cells.Workbook("J8CR782.xls", new Cells.LoadOptions(Cells.LoadFormat.Auto));
// access CellsCollection of the worksheet containing data to be converted
var cells = workbook.Worksheets[0].Cells;
// create & set ExportRangeToJsonOptions for advanced options
var exportOptions = new Aspose.Cells.Utility.ExportRangeToJsonOptions();
// create a range of cells containing data to be exported
var range = cells.CreateRange(0, 0, cells.LastCell.Row + 1, cells.LastCell.Column + 1);
// export range as JSON data
string jsonData = Aspose.Cells.Utility.JsonUtility.ExportRangeToJson(range, exportOptions);
// write data file to disc in JSON format
System.IO.File.WriteAllText("output.json", jsonData);

Also, see the document for further reference:

Hope, this helps a bit.

3

Amjad,

Thanks for the quick response.

We tried the snippet with Aspose.Cells 19.3 version,

It says, Aspose.Cells.Utility.ExportRangeToJsonOptions does not exist. Could you let us know which version of Aspose.Cells does the snippet work with?

Thanks,

4

@susoma,

These APIs are supported in newer Aspose.Cells versions. So, you need to use Aspose.Cells version >= v20.2.