Save a XLSB file as JSON in Python
API
POST
https://api.aspose.cloud/v3.0/cells/{name}/SaveAs
Saving file formats from XLSB as JSON is a complex task. All XLSB to JSON format transitions is performed by our Python SDK while maintaining the source XLSB spreadsheet's main structural and logical content. Our Python library is a professional solution to save XLSB as JSON files online. This Cloud SDK gives Python developers powerful functionality and perfect JSON output.
Python Code Example for saving XLSB as JSON using REST API
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-python/
cells_api = CellsApi(os.getenv('ProductClientId'),os.getenv('ProductClientSecret'))
name ='Book1.xlsb'
saveOptions = None
newfilename = "Book1Saveas.json"
isAutoFitRows= True
isAutoFitColumns= True
folder = "PythonTest"
saveResponse = cells_api.cells_save_as_post_document_save_as(name,save_options=saveOptions, newfilename=(folder +'/' + newfilename),folder=folder)
How to save XLSB as JSON using the Cells Cloud Python library.
- Register an account at Dashboard to get free API quota & authorization details
- Install Python library and add the reference (import the library) to your project.
- Open the source file in Python.
- Use the `post_workbook_save_as` method to retrieve the resulting stream.
System Requirements
- Python 2.7 or newer
- Python 3.10 or newer