Aspose.Cells.GridWeb
24.11.0
dotnet add package Aspose.Cells.GridWeb --version 24.11.0
NuGet\Install-Package Aspose.Cells.GridWeb -Version 24.11.0
<PackageReference Include="Aspose.Cells.GridWeb" Version="24.11.0" />
paket add Aspose.Cells.GridWeb --version 24.11.0
#r "nuget: Aspose.Cells.GridWeb, 24.11.0"
// Install Aspose.Cells.GridWeb as a Cake Addin #addin nuget:?package=Aspose.Cells.GridWeb&version=24.11.0 // Install Aspose.Cells.GridWeb as a Cake Tool #tool nuget:?package=Aspose.Cells.GridWeb&version=24.11.0
.NET API for GUI Web-Based Grid Control
Aspose.Cells.GridWeb is a powerful .NET API offering a GUI-based web control that can be embedded in ASP.NET web forms to create, view, edit, and manipulate Microsoft Excel spreadsheets. With cross-browser compatibility and rich APIs, developers can seamlessly integrate spreadsheet functionality into web applications without the need for Office Automation. It provides full support for importing and exporting Excel formats, custom styling, client-side scripting, data validation, and spreadsheet manipulation, making it a versatile tool for any .NET web developer.
Working with GridWeb
Add GridWeb to Web Form
Create a new web form and embed the GridWeb control for spreadsheet functionalities.
Apply Styles to GridWeb
Use preset or custom styles to customize the appearance of GridWeb.
Resize GridWeb and its Header Bar
Adjust the height and width of GridWeb and its header bars at runtime for better readability.
Enable GridWeb EditBox
Enable the edit box to edit cell values directly within the GridWeb interface.
Execute Client-Side Function on Page Change
Use the OnPageChangeClientFunction property to trigger client-side functions when changing GridWeb pages.
Print GridWeb
Print the contents of GridWeb directly from the web page using client-side JavaScript functions.
Get GridWeb Release or Version
Use
GridWeb.GetVersion()
to get the current running version of Aspose.Cells.GridWeb.
Add or Remove Context Menu Items in GridWeb
Customize context menus in GridWeb using ASP.NET markup or .NET code.
Set Column Header Tip
Set tooltips for column headers to provide additional context for each column.
Enable Different GridWeb Modes
Switch between Edit, View, Session, and Sessionless modes based on the application's needs.
Render Interactive Scrollbar in GridWeb
Add an interactive scrollbar to GridWeb using jQuery UI for enhanced user navigation.
LoadOptions for GridWeb
Set specific encoding options for loading text-based spreadsheet files into GridWeb.
Working with Worksheets in GridWeb
Add Worksheets
Add worksheets to GridWeb without specifying names or with specific names.
Rename Worksheets
Rename worksheets in GridWeb to make them more meaningful.
Copy a Worksheet
Add a copy of an existing worksheet to GridWeb for reuse.
Sort Worksheet Data
Sort data in a worksheet programmatically for organized presentation.
Manage Hyperlinks in Worksheet
Add, edit, or remove hyperlinks within a GridWeb worksheet for navigation.
Show Buttons to Add/Remove Worksheets
Enable buttons for adding or removing worksheets directly in the GridWeb UI.
Import DataView to GridWeb
Import data from DataView objects into a GridWeb worksheet to display data dynamically.
Working with Rows and Columns in GridWeb
Insert Rows and Columns
Insert new rows or columns in the worksheet to modify the structure.
Delete Rows and Columns
Remove rows or columns to adjust the content layout.
Customize Row and Column Headers
Set custom properties for row and column headers for enhanced worksheet interactivity.
Freeze and Unfreeze Panes
Freeze specific rows or columns in GridWeb to keep them visible during scrolling.
Group Rows and Create Subtotal
Group multiple rows together and create subtotals to organize data efficiently.
Working with Cells in GridWeb
Access and Modify Cell Value
Access a cell and modify its value directly in the worksheet.
Add Cell Formulas
Add and evaluate formulas in cells to perform calculations.
Protect Cells
Protect cells in GridWeb to prevent unauthorized edits.
Merge and Unmerge Cells
Merge or unmerge selected cells for better data presentation.
Add Cell Validations
Add validation rules to cells to ensure data integrity.
Filter Data
Apply filters to worksheet data for easy analysis.
Highlight Cell Features
Add highlights to cell text, ranges, or shapes to improve visual emphasis.
Working with GridWeb Client-Side Script
Write GridWeb Client-Side Script
Write JavaScript code to interact with GridWeb, such as validating input or handling events.
Using
OnAjaxCallFinishedClientFunction
Use client-side functions to track updated cells in real time for better data handling.
Add/Remove Hyperlinks from Client Side
Add or remove hyperlinks using JavaScript for dynamic link management.
Update Font Settings from Client Side
Change font settings like size, color, and style of cells directly from the client side.
Validate Entire Worksheet
Validate the entire worksheet instead of only updated cells to ensure all data is correct.
Use Client-Side Functions for Range Selection
Use JavaScript functions to select ranges or get the selected range in GridWeb.
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.
Adjust Row Height and Column Width in Aspose.Cells.GridWeb
Aspose.Cells.GridWeb allows you to easily set row heights and column widths, ensuring that cell contents are fully visible, even when they span multiple lines or exceed the cell width. You can specify dimensions in points, inches, pixels, and more.
Setting Row Height
To adjust the height of a row, access the worksheet’s GridCells
collection and use setRowHeight()
:
// Accessing the cells collection of the currently active worksheet
GridCells cells = gridweb.getWorkSheets().get(gridweb.getActiveSheetIndex()).getCells();
// Set the height of the 1st row to 50 points
cells.setRowHeight(0, 50);
Setting Column Width
To adjust the width of a column, use setColumnWidth()
:
// Accessing the cells collection of the currently active worksheet
GridCells cells = gridweb.getWorkSheets().get(gridweb.getActiveSheetIndex()).getCells();
// Set the width of the 1st column to 150 points
cells.setColumnWidth(0, 150);
Spreadsheet Web Control
| GridWeb for ASP.NET
| .NET Spreadsheet API
| Excel Web Control
| Spreadsheet Viewer
| Spreadsheet Editor
| Cross-Browser Support
| GridWeb Customization
| GridWeb Styles
| Context Menu Customization
| Client-Side Scripting
| Interactive Spreadsheet
| Row Height and Column Width
| Worksheet Manipulation
| Spreadsheet Data Validation
| Cell Formatting
| Excel File Formats
| PDF Export
| SVG Export
| Image Export
| ASP.NET Web Forms
| Microsoft Excel Integration
| Spreadsheet Data Handling
| Freeze Panes
| Merge Cells
| Worksheet Navigation
| Data Filtering
| JavaScript Integration
| GridWeb Highlighting
| Dynamic Row and Column Operations
| Excel Workbook Management
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. 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. net6.0-windows7.0 is compatible. 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. net7.0-windows7.0 is compatible. 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. net8.0-windows7.0 is compatible. |
.NET Framework | net40 is compatible. net403 was computed. net45 was computed. net451 was computed. net452 was computed. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
-
.NETFramework 4.0
- No dependencies.
-
net6.0
- SkiaSharp (>= 2.88.6)
- System.Security.Cryptography.Pkcs (>= 6.0.3)
- System.Text.Encoding.CodePages (>= 4.7.0)
-
net6.0-windows7.0
- System.Drawing.Common (>= 7.0.0)
- System.Security.Cryptography.Pkcs (>= 6.0.3)
- System.Text.Encoding.CodePages (>= 4.7.0)
-
net7.0-windows7.0
- System.Drawing.Common (>= 7.0.0)
- System.Security.Cryptography.Pkcs (>= 6.0.3)
- System.Text.Encoding.CodePages (>= 4.7.0)
-
net8.0-windows7.0
- System.Drawing.Common (>= 7.0.0)
- System.Security.Cryptography.Pkcs (>= 6.0.3)
- 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.GridWeb:
Repository | Stars |
---|---|
aspose-cells/Aspose.Cells-for-.NET
Aspose.Cells for .NET examples, plugins and showcases
|
Version | Downloads | Last updated |
---|---|---|
24.11.0 | 168 | 11/13/2024 |
24.10.0 | 181 | 10/11/2024 |
24.9.0 | 284 | 9/11/2024 |
24.8.0 | 647 | 8/8/2024 |
24.7.0 | 165 | 7/12/2024 |
24.6.0 | 128 | 6/14/2024 |
24.5.0 | 2,470 | 5/10/2024 |
24.4.0 | 287 | 4/10/2024 |
24.3.0 | 225 | 3/8/2024 |
24.2.0 | 1,564 | 2/5/2024 |
24.1.0 | 305 | 1/11/2024 |
23.12.0 | 293 | 12/13/2023 |
23.11.0 | 437 | 11/9/2023 |
23.10.0 | 1,880 | 10/13/2023 |
23.9.0 | 305 | 9/14/2023 |
23.8.0 | 392 | 8/10/2023 |
23.7.0 | 345 | 7/13/2023 |
23.6.0 | 362 | 6/8/2023 |
23.5.0 | 349 | 5/10/2023 |
23.4.0 | 359 | 4/12/2023 |
23.3.0 | 1,213 | 3/8/2023 |
23.2.0 | 428 | 2/9/2023 |
23.1.0 | 526 | 1/11/2023 |
22.12.0 | 501 | 12/9/2022 |
22.11.0 | 537 | 11/10/2022 |
22.10.0 | 3,122 | 10/13/2022 |
22.9.0 | 658 | 9/13/2022 |
22.8.0 | 729 | 8/5/2022 |
22.7.0 | 697 | 7/8/2022 |
22.6.0 | 765 | 6/10/2022 |
22.5.0 | 837 | 5/12/2022 |
22.4.0 | 907 | 4/13/2022 |
22.3.0 | 798 | 3/15/2022 |
22.2.0 | 807 | 2/14/2022 |
22.1.0 | 802 | 1/11/2022 |
21.12.0 | 723 | 12/8/2021 |
21.11.0 | 1,285 | 11/9/2021 |
21.10.0 | 1,308 | 10/15/2021 |
21.9.0 | 644 | 9/16/2021 |
21.8.0 | 707 | 8/16/2021 |
20.12.0 | 2,134 | 12/22/2020 |
20.10.0 | 738 | 10/16/2020 |
20.7.0 | 704 | 7/20/2020 |
20.6.0 | 727 | 6/29/2020 |
20.5.0 | 1,757 | 5/21/2020 |