Aspose.Cells.GridWeb 20.7.0

.NET API for GUI Web-Based Grid Control

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.

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

Getting Started with Aspose.Cells.GridWeb

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

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