Aspose.Cells.GridJs
24.11.0
dotnet add package Aspose.Cells.GridJs --version 24.11.0
NuGet\Install-Package Aspose.Cells.GridJs -Version 24.11.0
<PackageReference Include="Aspose.Cells.GridJs" Version="24.11.0" />
paket add Aspose.Cells.GridJs --version 24.11.0
#r "nuget: Aspose.Cells.GridJs, 24.11.0"
// Install Aspose.Cells.GridJs as a Cake Addin #addin nuget:?package=Aspose.Cells.GridJs&version=24.11.0 // Install Aspose.Cells.GridJs as a Cake Tool #tool nuget:?package=Aspose.Cells.GridJs&version=24.11.0
.NET Library to View & Edit Spreadsheets
Aspose.Cells.GridJs is a .NET standard library designed for building cross-platform web applications that allow viewing and editing of spreadsheets. With lightweight, scalable, and customizable features, it supports popular formats such as XLS, XLSX, XLSM, and ODS, and offers export options to formats like PDF and HTML. Developers can implement custom cache storage, customize UI elements, handle cell updates, and manage files programmatically to create powerful, interactive spreadsheet solutions without needing Microsoft Excel.
Working with GridJs Server Side
Configure Folder Paths
Set up appropriate folder paths in configuration for workbook and image cache storage to manage spreadsheet data effectively.
Implement GridCacheForStream
Provide custom implementations for caching spreadsheets, such as using local or server-side storage solutions.
Get JSON from Spreadsheet
Convert spreadsheet files to JSON format using
GridJsWorkbook
, making it easy to work with data programmatically.
Extract Images and Shapes
Retrieve images and shapes from spreadsheets by saving them in a zip file in cache.
Update Spreadsheet File in Cache
Update spreadsheet files directly in cache by using JSON, facilitating real-time modifications.
Save Spreadsheet in Cache
Save updated spreadsheets to cache for later retrieval, ensuring persistent storage for changes.
Working with GridJs Client Side Script
Create Spreadsheet Instance
Use
x_spreadsheet
to create an instance for managing spreadsheet elements within an HTML container.
Load Spreadsheet with JSON Data
Load spreadsheets using JSON data to initialize worksheet content programmatically.
Set Active Sheet and Cell
Set the active sheet or cell by specifying IDs or coordinates, enhancing navigation control.
Configure Toolbar and Context Menus
Enable or disable toolbars, and show or hide context menus to customize the user interface.
Set Localization
Configure localization settings for menus and toolbars, supporting multiple languages like English, Chinese, Spanish, and more.
Enable Syntax Checking & Spell Correction
Enable syntax checking for user inputs in cells, along with an option for spell correction.
Configure Formula Explanation
Set URLs to provide users with formula explanations when they hover over cells containing formulas.
Handle Images and Shapes
Set URLs for uploading, copying, and retrieving images or shapes in spreadsheets.
File and OLE Object Operations
Set URLs for downloading files and working with OLE objects within the spreadsheet.
Re-Render Spreadsheet View
Trigger re-rendering of the spreadsheet view to reflect any changes made programmatically.
Zoom and File Naming
Set zoom levels and specify filenames to control the document's visual presentation.
Callback Functions for Email
Define callback functions for handling email sending functionality from the spreadsheet interface.
Highlight Features
Enable, add, update, or remove highlights for cell text, ranges, or shapes to improve readability.
Highlighting Features
Enable Cell Highlighting
Enable highlighting and customize highlight styles for cells in the active worksheet.
Update Highlight Styles
Update the highlight styles applied to cells in the active worksheet.
Disable Cell Highlighting
Disable highlighting for cells in the active worksheet.
Highlight Specific Text in Cells
Add, remove, and get arrays of highlighted text in cells within the active worksheet.
Highlight Cell Range
Add, remove, and get arrays for highlighted cell ranges in the active worksheet.
Inverse Cell Highlighting
Set, remove, and retrieve inverse highlighting for cell ranges in the active worksheet.
Highlight Shapes and Objects
Add, remove, and retrieve highlighted shapes, textboxes, and images in the active worksheet.
Clear Highlight Settings
Clear all highlight settings for the active worksheet.
Worksheet Customization Features
Customize Menu Bar
Show or hide the menu bar for enhanced worksheet interactivity.
Set Home Icon and Link
Set a home icon with a hyperlink for easy navigation.
Set Zoom Level
Adjust the worksheet zoom level to suit your viewing preferences.
Customize Background Color for Textboxes
Change the background color of textboxes in the worksheet for better readability.
Set Display Direction
Set the worksheet display direction for RTL or LTR based on language preferences.
Textbox and Image Features
Manage Textbox and Image Highlights
Highlight textboxes and images, and manage their visibility in the active worksheet.
Set Active Effect for Textboxes
Set and manage active effects for textbox objects to improve interactivity.
Hide or Show Text in Textboxes
Toggle the visibility of text content within textboxes.
Cell and Range Features
Manage Selected Cell Range
Get or set the selected cell range for easy data manipulation.
Set Cell Value and Style
Set values and styles for the selected cells or cell ranges.
Merge and Unmerge Cells
Merge or unmerge the selected cell area for organized data presentation.
Delete Selected Cells
Delete the selected cells to adjust the worksheet structure.
Freeze and Layout Features
Set Freeze Panes
Set freeze panes to keep specific rows or columns visible while scrolling.
Insert and Delete Rows or Columns
Insert or delete rows and columns at the selected cell location.
Set Column Width
Set the width for specific columns, multiple columns, or all columns in the worksheet.
Set Row Height
Set the height for specific rows, multiple rows, or all rows.
Image and Shape Features
Manage Image and Shape Selection
Set selectable states for images and shapes, and get the currently selected object.
Set Visibility Filters for Shapes
Set visibility filters for images and shapes in the worksheet.
Cell Value and Style Features
Get or Set Cell Value
Retrieve or set the value of specific cells in the worksheet.
Get Cell Style
Retrieve the style of a specific cell for formatting consistency.
Callback and Event Features
Set Email Send Callback
Set a callback function to send emails directly from the worksheet.
Enable or Disable Window Key Events
Enable or disable window key events for better control of GridJs interactions.
Destroy All Events in GridJs
Destroy all attached events in GridJs to clean up resources.
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.
Build a Web App with Aspose.Cells.GridJs
Aspose.Cells.GridJs is a powerful .NET library that enables you to create web applications to view and edit spreadsheets effortlessly. With support for common file formats like XLS, XLSX, XLSM, XLSB, CSV, SpreadsheetML, and ODS, you can also export to formats like PDF and HTML.
Step 1: Implement Custom Cache Logic
Create your custom cache logic by implementing
GridCacheForStream
. This helps you manage cache storage for spreadsheets effectively.
Step 2: Import Spreadsheet and Convert to JSON
Create a controller action to convert a spreadsheet file into JSON. Use
GridJsWorkbook.ImportExcelFile
andGridJsWorkbook.ExportToJson
to handle file imports and automatically store them in cache.
Step 3: Handle Cell Updates
Set up another controller action for handling cell updates in real time. Use the
GridJsWorkbook.UpdateCell
API to update cells in cache and get the updated JSON data.
Step 4: Retrieve Images and Shapes
To access images or shapes within the spreadsheet, create a controller action that retrieves their URLs. GridJs will zip all the images/shapes in cache, and you can get their URL with
GridCacheForStream.GetFileUrl
.
Step 5: Access Files in Cache
Set up a controller action to retrieve files from cache (such as images/shapes or spreadsheet files) using
GridCacheForStream.LoadStream
.
Step 6: Enable Spreadsheet Download
Finally, create a controller action to download the modified spreadsheet by using
GridJsWorkbook.SaveToCacheWithFileName
.
Basic Demo
Please visit the basic demo to learn how to use GridJs to implement a spreadsheet Editor.
Customizing Menus and Toolbars in GridJs
1. Keep Only "File" Menu in the Menubar
// Get menubar parent DOM
const menubar = document.querySelector("#gridjs-divid > div > div:nth-child(1) > div > div.x-spreadsheet-banner-info-s > div.x-spreadsheet-toolbar.x-spreadsheet-menubar");
const childs = menubar.childNodes;
// Keep only the "File" menu
for (let i = childs.length - 1; i >= 0; i--) {
if (childs[i].childNodes[0].childNodes[0].textContent !== "File") {
menubar.removeChild(childs[i]);
}
}
2. Keep Only "Download As XLSX" in File Menu
// Get menubar parent DOM
const menubar = document.querySelector("#gridjs-divid > div > div:nth-child(1) > div > div.x-spreadsheet-banner-info-s > div.x-spreadsheet-toolbar.x-spreadsheet-menubar");
const childs = menubar.childNodes;
// Find and filter the "File" menu items
for (let i = childs.length - 1; i >= 0; i--) {
if (childs[i].childNodes[0].childNodes[0].textContent === "File") {
const dropdownParent = childs[i].childNodes[0].childNodes[1];
const menuItems = dropdownParent.childNodes;
for (let ii = menuItems.length - 1; ii >= 0; ii--) {
if (menuItems[ii].textContent !== 'Download As XLSX') {
dropdownParent.removeChild(menuItems[ii]);
}
}
}
}
3. Keep Only "Zoom" Button in the Toolbar
// Get toolbar parent DOM
const toolbar = document.querySelector("#gridjs-divid > div > div.x-spreadsheet-toolbar > div.x-spreadsheet-toolbar-btns");
const childs = toolbar.childNodes;
// Keep only the "Zoom" button
for (let i = childs.length - 1; i >= 0; i--) {
if (childs[i].getAttribute("data-tooltip") !== "Zoom") {
toolbar.removeChild(childs[i]);
}
}
Spreadsheet Editing API
| .NET Cloud API
| Aspose.Cells.GridJs
| REST API
| Excel File Management
| Spreadsheet Import and Export
| Spreadsheet View and Edit
| PDF and HTML Export
| UI Customization
| Toolbar Customization
| Menu Customization
| Cross-Platform Development
| Spreadsheet Cache Management
| Real-time Spreadsheet Updates
| Spreadsheet Cell Management
| Highlight Cells and Shapes
| Localization Support
| Excel-like Web Interface
| Merge and Unmerge Cells
| Spreadsheet Zoom Control
| Freeze Panes
| Insert Delete Rows Columns
| Spreadsheet File Conversion
| OLE Object Management
| Spreadsheet JSON Conversion
| Interactive Spreadsheet Web App
| Shape and Image Handling
| Callback Functions
| Spreadsheet File Download
| GridJs Spreadsheet API
| Syntax Checking and Spell Correction
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETStandard 2.0
- Aspose.Cells (>= 24.11.0)
- System.Drawing.Common (>= 6.0.0)
- System.Security.Cryptography.Pkcs (>= 5.0.1)
- System.Text.Encoding.CodePages (>= 4.7.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories (1)
Showing the top 1 popular GitHub repositories that depend on Aspose.Cells.GridJs:
Repository | Stars |
---|---|
aspose-cells/Aspose.Cells-for-.NET
Aspose.Cells for .NET examples, plugins and showcases
|
Version | Downloads | Last updated |
---|---|---|
24.11.0 | 367 | 11/13/2024 |
24.10.0 | 535 | 10/11/2024 |
24.9.0 | 368 | 9/11/2024 |
24.8.0 | 282 | 8/8/2024 |
24.7.0 | 479 | 7/12/2024 |
24.6.0 | 1,992 | 6/14/2024 |
24.5.0 | 266 | 5/10/2024 |
24.4.0 | 553 | 4/10/2024 |
24.3.0 | 354 | 3/8/2024 |
24.2.0 | 256 | 2/5/2024 |
24.1.0 | 236 | 1/11/2024 |
23.12.0 | 374 | 12/13/2023 |
23.11.0 | 728 | 11/9/2023 |
23.10.0 | 239 | 10/13/2023 |
23.9.0 | 232 | 9/14/2023 |
23.8.0 | 425 | 8/10/2023 |
23.7.0 | 61,718 | 7/13/2023 |
23.6.0 | 3,948 | 6/8/2023 |
23.5.0 | 3,366 | 5/10/2023 |
23.4.0 | 1,969 | 4/12/2023 |
23.3.0 | 464 | 3/8/2023 |
23.2.0 | 570 | 2/9/2023 |
23.1.0 | 606 | 1/11/2023 |
22.12.0 | 1,101 | 12/9/2022 |
22.11.0 | 2,604 | 11/10/2022 |
22.10.0 | 503 | 10/13/2022 |
22.9.0 | 921 | 9/13/2022 |
22.8.0 | 1,244 | 8/5/2022 |
22.7.0 | 714 | 7/8/2022 |
22.6.0 | 721 | 6/10/2022 |
22.5.0 | 810 | 5/12/2022 |
22.4.0 | 2,122 | 4/13/2022 |
22.3.0 | 5,077 | 3/15/2022 |
22.2.0 | 3,114 | 2/14/2022 |
22.1.0 | 630 | 1/11/2022 |
21.12.0 | 399 | 12/8/2021 |
21.11.0 | 395 | 11/9/2021 |
21.10.0 | 531 | 10/15/2021 |
21.9.0 | 481 | 9/16/2021 |
21.8.0 | 507 | 8/16/2021 |