Aspose.Cells.GridJs Basics

Basics of GridJs

Aspose.Cells.GridJs is a library that allows users to develop cross-platform web application to view or edit spreadsheet file quickly and easily.

It enable users to create, edit, format, collaborate on, and securely share spreadsheets with real-time updates, formula support, and rich data visualization tools, akin to traditional desktop applications.
It supports Data Input and Editing,Format,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.

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.

Below is a basic demo to show the usage of Aspose.Cells.GridJs :

In the demo we use gridjs-spreadsheet for the render of client side page.

If you have any questions,requirements or need help, please feedback to the following website https://forum.aspose.com/c/cells/9