.NET API for GUI Web-Based Grid Control

Nuget

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.

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.

Supported Read & Write Formats

Microsoft Excel®: XLS, XLSX, XLSB, XLSM, XLT, XLTX, XLTM, CSV, TSV, TabDelimited, SpreadsheetML
OpenOffice: ODS, SXC, FODS
Text: TXT
Web: HTML, MHTML
iWork®: Numbers
Other: SXC, FODS

Save Excel® Files As

Microsoft Word®: DOCX
Microsoft PowerPoint®: PPTX
Microsoft Excel®: XLAM
Fixed Layout: PDF, XPS
Data Interchange: DIF
Vector Graphics: SVG
Image: TIFF,PNG, BMP, JPEG, GIF
Metafile: EMF
Markdown: MD

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");

Aspose.Cells for .NET

Aspose Marketplace