aspose-cells-gridjs-net-python 24.3.1

Why Use Aspose.Cells.GridJs?

It allows you to import and export Excel® files, manipulate data & formatting, customize grid design and layout, manage multiple worksheets, create and calculate Excel® formulas, and perform numerous other Excel®-like operations.

Features

• Import, view and edit the popular spreadsheet formats.

• Export the spreadsheets to various supported file formats.

• Get the image or shape files being used within the spreadsheet.

• Perform Grid design and layout customization.

• Multiple worksheet management.

• Creation and calculation of Excel® formulas.

Supported Import & Export Formats

• Microsoft Excel®: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, CSV, TSV, TabDelimited, SpreadsheetML

• OpenOffice®: ODS, SXC, FODS

• Text: TXT

• Web: HTML, MHTML

• Apple iWork®: Numbers

Get Started

Are you ready to give Aspose.Cells.GridJs a try? Simply execute pip install aspose_cells_gridjs_net_python.

General Usage

Below is the basic process steps to develop a web application of GridJs.

• Set cache storage directory by Config.set_file_cache_directory(‘you storage path’)

• Set License by Config.set_license(‘you license path’)

• Set image route url GridJsWorkbook.set_image_url_base(‘route for view image’);

• Set up a route action to get json from the spreadsheet file. You can use GridJsWorkbook.ImportExcelFile and GridJsWorkbook.ExportToJson APIs, GridJs will automatically store the spread file in cache.

• Set up a route action to get json for the update operation.You can use GridJsWorkbook.UpdateCell API，GridJs will do update operation in cache and return the updated json.

• Set up a route action to get the images/shapes files url in the spreadsheet, GridJs will automatically zip all the images/shapes in cache .It will use GridCacheForStream.GetFileUrl API.

• Set up a route action to get file in cache,thus we can get the images/shapes zip file or the spreadsheet file in cache. It will use GridCacheForStream.LoadStream API.

• Set up a route action to download the spreadsheet.You can use GridJsWorkbook.SaveToCacheWithFileName API.

Basic Demo

Below is a basic demo to show the usage of Aspose.Cells.GridJs : https://github.com/aspose-cells/Aspose.Cells-for-Python-via-.NET/tree/main/Examples_GridJs_Python_Net in the demo we use gridjs-spreadsheet <https://www.npmjs.com/package/gridjs-spreadsheet> for the render of client side page.

Product Page | Docs | API Reference | Demos | Blog | Code Samples | Free Support | Temporary License | EULA