Aspose.Cells.GridWeb 20.10.0

Aspose.Cells.GridWeb for .NET consists of API and Web controls to create, process, manipulate and convert Microsoft Excel® spreadsheets without needing Office Automation.

Install-Package Aspose.Cells.GridWeb -Version 20.10.0
dotnet add package Aspose.Cells.GridWeb --version 20.10.0
<PackageReference Include="Aspose.Cells.GridWeb" Version="20.10.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Aspose.Cells.GridWeb --version 20.10.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

.NET API for GUI Web-Based Grid Control

Version 20.10 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.

New Features & Enhancements Version 20.10

  • Ability to verify the password for encrypted files.
  • Render extra row and column in HTML without disturbing formulas/references to resemble the output with MS Excel.

Please visit Aspose.Cells for .NET 20.10 Release Notes for the detailed notes.

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

.NET API for GUI Web-Based Grid Control

Version 20.10 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.

New Features & Enhancements Version 20.10

  • Ability to verify the password for encrypted files.
  • Render extra row and column in HTML without disturbing formulas/references to resemble the output with MS Excel.

Please visit Aspose.Cells for .NET 20.10 Release Notes for the detailed notes.

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

Release Notes

https://docs.aspose.com/display/cellsnet/Aspose.Cells+for+.NET+20.5+Release+Notes

  • .NETCoreApp 2.1

    • No dependencies.
  • .NETFramework 2.0

    • No dependencies.
  • .NETFramework 4.0

    • No dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
20.10.0 96 10/16/2020
20.7.0 127 7/20/2020
20.6.0 127 6/29/2020
20.5.0 186 5/21/2020