Aspose.Cells.GridWeb 24.10.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);

Tags

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