aspose-cells-gridjs-net-python 25.9.0

Why Use Aspose.Cells.GridJs

• It enables users to create, edit, format, collaborate on, and securely share spreadsheets with real-time updates, formula support, and rich data visualization tools, similar to traditional desktop applications.

• It supports Data Input and Editing, Formatting, Spreadsheet Navigation, Formula Calculation, Data Manipulation, Charts and Visualizations, Import and Export, Security, Add-ons, and Customization for developers to tailor the editor to specific business needs.

Features

• Import, view and edit the popular spreadsheet formats.

• Export spreadsheets to various supported file formats.

• Display and manage the image or shape or chart files.

• Perform Grid design and layout customization.

• Manage multiple worksheets with ease.

• Create and calculate Excel® formulas accurately and efficiently.

Additionally, Aspose.Cells.GridJs offers:

• Data Input and Editing: Streamline data entry and editing processes.

• Formatting: Apply various formats to enhance the presentation of your data.

• Spreadsheet Navigation: Easily navigate through complex spreadsheets.

• Formula Calculation: Accurately compute and manage Excel® formulas.

• Data Manipulation: Organize and analyze data with ease.

• Charts and Visualizations: Utilize powerful tools for visual data representation.

• Import and Export: Seamlessly transfer data between different file formats.

• Security: Ensure the protection of sensitive data with robust security features.

• Add-ons and Customization: Extend the functionality of the editor with add-ons and tailor it to specific business requirements.

By leveraging these features, Aspose.CellsGridJs provides a comprehensive solution for spreadsheet management and data analysis, making it an indispensable tool for businesses and individuals alike.

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

• Other: XML, JSON

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 file in cache,thus we can get the images/shapes zip file or the spreadsheet file in cache.

• 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 for the render of client side page.

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