Aspose.Cells.GridJs 24.9.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 .NET standard library that allows users to develop cross-platform web application to view or edit spreadsheet quickly and easily. Aspose.Cells.GridJs is based on .netstandard 2.0.

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.

General Features

• Supports multiple spreadsheet formats: XLS, XLSX, XLSM, XLSB, CSV, SpreadsheetML, ODS.
• Export options: Can export to formats like PDF, HTML.
• Spreadsheet operations: Import, view, edit, and update spreadsheet files.
• Image and shape handling: Export images and shapes in a zip file.
• Custom cache storage: Implements GridCacheForStream for custom cache storage.
• Controller actions: Set up controller actions for retrieving, updating, and downloading spreadsheets.
• Mobile support: GridJs adapts to mobile screens and offers mobile browser editing capabilities.
• Docker support: Run GridJs in a Docker container with steps provided for creating and managing Docker images.

Server-Side Features

• Server-side storage: Examples provided for local file storage and AWS integration.
• Cache management: Save, load, and retrieve files from cache.
• Spreadsheet update: Supports updating spreadsheets in cache and merging them from JSON.

Client-Side Features

• Spreadsheet instance creation: Uses x_spreadsheet(id, options) to create instances.
• Update modes: Support for server-based updates.
• Localization: Supports multiple languages (English, Chinese, Spanish, Portuguese, etc.).
• TextBox control: Allows text selection in TextBox objects when in read mode.
• Syntax checking and spell correction: Features syntax checking and spell correction with server-side API integration.
• Formula explanation: Displays formula explanations upon hovering over formula cells.
• Customization options: Customize toolbars, context menus, and more.

UI Customization

• Custom context menus: Support for adding, deleting, and updating custom context menu items.
• GridJs toolbar: Allows customization of toolbars and context menus.
• Image and shape handling: Provides operations for adding, copying, and removing images and shapes.
• Event handling: Supports various event callbacks for cell selection, object selection, sheet selection, and cell editing.

Advanced Features

• TextBox objects: Special shapes that can be customized, hidden, or highlighted.
• Custom calculation engine: Extendable engine to implement custom Excel-like functions.
• GridJs Highlight Feature: Supports adding, removing, and customizing highlights for cells, shapes, and textboxes.
• File storage and synchronization: Methods to ensure synchronization between client UI operations and server-side updates.

Spell and Syntax Features

• Syntax checking: Can automatically check and correct syntax and spelling errors in user input with the ability to customize.
• Spell correction: Allows for integration of custom logic or third-party libraries for spell checking.

Formula Features

• Formula explanation: Display formula breakdowns with server-side API setup.

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