Aspose.Cells.GridJs 24.3.0

.NET Library to View & Edit Spreadsheets

Product Page | Docs | Demos | API Reference | Examples | Blog | Releases | Free Support | Temporary License

Aspose.Cells.GridJs is a lightweight, scalable, and customizable toolkit that provides cross-platform web applications, enables convenient development for editing or viewing Excel/Spreadsheet files, offers simple deployment, and provides easy-to-use APIs.

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 the 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

Get Started

Simply execute Install-Package Aspose.Cells.GridJs from Package Manager Console in Visual Studio to fetch the NuGet package. If you already have Aspose.Cells.GridJs and want to upgrade the version, please execute Update-Package Aspose.Cells.GridJs to get the latest version.

General Usage

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

• Implement GridCacheForStream to write your own business logic for cache storage.
• Set up a controller 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 controller 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 controller 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 controller 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 controller 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-.NET/tree/master/Examples_GridJs

Product Page | Docs | Demos | API Reference | Examples | Blog | Releases | Free Support | Temporary License