Aspose.Cells.GridWeb 23.8.0

.NET API for GUI Web-Based Grid Control

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

Aspose.Cells.GridWeb is a GUI based web control that can be embedded in ASP.NET web forms like other web controls provided by the Microsoft .NET Framework. Aspose.Cells.GridWeb web control provides cross-browser support.

What is Aspose.Cells.GridWeb for .NET?

Aspose.Cells.GridWeb for .NET is a web control that you can embed in your ASP.NET web forms to integrate spreadsheet manipulation capabilities with 0% dependency on Microsoft Excel. It is built using the Microsoft .NET Framework and supports many popular browsers, such as, Microsoft Internet Explorer, Google Chrome, Mozilla FireFox, and Opera.

It’s client-side features include, cell context menu, client side validation, formula input/edit, merge/unmerge cells, sheet paging, cell font settings, cell border settings and many more. You can also apply custom styles, import/export MS Excel files, enable various grid modes (Edit, View, Session, Sessionless), and print the contents of the Aspose.Cells.GridWeb control via a JavaScript call.

Furthermore, you can work with custom command buttons, set Aspose.Cells.GridWeb control toolbar, add/remove context menu items, Grid events, and double click events. The support for serializing Aspose.Cells.GridWeb data to SQL Server or StateServer is also available.

GridWeb Processing Features

Worksheet Features

• Add/remove worksheets.
• Sort worksheet data horizontally & vertically.
• Supports worksheet pagination.
• Create spreadsheets from scratch.

Row & Column Features

• Add, insert, and remove rows and columns in a worksheet.
• Hide/show, Freeze/unfreeze rows & columns.
• Customize the headers of rows & columns.

Cell Features

• Merge or split cells.
• Edit multiple cells on the client-side with a single post back to the server-side.
• Supports number, date, and time format settings.
• Supports custom format settings.
• Control text alignment, borders, & font settings.

Formatting Features

• Create web-based interactive grid apps that look and feel like desktop spreadsheet apps.
• Supports client-side cell formatting.
• Provides both built-in and customizable visual styles.

Import/Export Features

• Import from and export to Excel spreadsheets.
• Import and export data directly from and to DataView or DataTable objects.

Utility Features

• Supports drop-down list and regular expressions validations.
• Add and remove comments.
• Insert and remove pictures.
• Add and remove hyperlinks.
• Keyboard navigation.
• Get the Release or Running Version of Aspose.Cells.GridWeb.

Advance Features

• Supports creating and calculating formulas on web pages.
• Provides 80+ pre-defined functions related to math, text, data, date, time, & logic.
• Supports creating dynamic pivot tables.
• Perform actions under different grid events.
• Use Aspose.Cells.GridWeb control in session-less mode.
• Submit grid data with a single click.
• Print the GridWeb contents from a web page without saving the result as an Excel file.

Read & Write Spreadsheet Formats

Microsoft Excel®: XLS, XLSX, XLSB, XLT, XLTX, XLTM, XLSM, XML
OpenOffice: ODS
Text: CSV, TSV
Web: HTML, MHTML
Numbers: Apple's iWork office suite Numbers app documents

Save Excel Files As

Fixed Layout: PDF, PDF/A, XPS
Data Interchange: DIF
Images: JPEG, PNG, BMP, SVG, TIFF, EMF, GIF

Supported Technologies

Browsers: Microsoft Internet Explorer, Mozilla Firefox, Opera, Google Chrome, Microsoft Edge
Excel: Microsoft Excel 97, Microsoft Excel 2000, Microsoft Excel XP, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013
Platforms: ASP.NET Web Forms

Get Started

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

Row & Column Header Customization of GridWeb control via C# Code

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet that is currently active
GridWorksheet workSheet = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex];

// Create custom row header caption.
workSheet.SetRowCaption(1, "Row1");
workSheet.SetRowCaption(2, "Row2");

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