Aspose.Cells.GridJs 23.7.0

.NET Library to View & Edit Spreadsheets

Product Page | Docs | Demos | API Reference | Examples | Blog | Search | 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.

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 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 | Search | Free Support | Temporary License