Aspose.Cells.GridDesktop 24.10.0

.NET Excel® GUI Desktop-Based Grid Control

Aspose.Cells.GridDesktop is a .NET GUI control that provides an Excel®-like interface for your desktop applications. It allows developers to seamlessly embed spreadsheet capabilities like data manipulation, formatting, formula calculation, charting, and more. No need for Microsoft Excel® installation.

Accessing and Modifying Worksheet Data

Access Cells and Worksheets

Access Worksheet by Index/Name

Retrieve or directly reference active worksheets using ActiveSheetIndex or GetActiveWorksheet methods.

Access and Modify Cells

Use the Value property to retrieve and modify cell contents, including custom formatting (font, color).

Access and Modify Rows

Programmatically adjust row properties such as height, style, and index.

Styling Cells, Rows, and Columns

Apply Styles

Row and Column Styling

Apply uniform styles (font, alignment, borders) to entire rows or columns.

Customize Cell Appearance

Use custom styles, including borders, font, alignment, and background colors, for individual cells.

Font and Color Customization

Modify fonts and colors for specific cells, rows, or columns.

Managing Worksheets

Add, Remove, and Rename Worksheets

Add/Insert Rows/Columns

Programmatically insert rows and columns at specified positions.

Add/Remove Worksheets

Add, insert, or remove entire worksheets, adjusting the workbook's layout as needed.

Rename and Move Worksheets

Rename worksheets or move them within the workbook using the MoveTo() method.

Data Validation and Interaction

Implement Validation

Column/Worksheet-Level Validation

Apply validation rules at the column or worksheet level to ensure data integrity.

Event Handling

Manage events such as cell changes, worksheet loading, and user interactions for dynamic control.

Advanced Features in GridDesktop

Pivot Tables

Create and Render Pivot Tables

Use PivotTable functionality for dynamic data analysis and summaries in GridDesktop.

Merging and Formulas

Merge and Unmerge Cells

Combine adjacent cells or revert to individual cells as needed.

Manage Formulas

Programmatically insert and manage Excel®-compatible formulas, with automatic recalculation using RunAllFormulas.

Formatting and Visualization

Export, Sort, and Filter Data

Export to DataTable

Export worksheet data to a DataTable for external processing.

Sort and Filter Data

Programmatically sort worksheet data or apply custom filters for data viewing.

Text Overflow Management

Handle Text Overflow

Control how text is displayed when it exceeds the cell width in GridDesktop.

Interface and Interaction

Zoom and Customization

Zoom Control

Programmatically adjust zoom levels for easier navigation and viewing.

Format Painter

Copy and apply formatting from one cell to another efficiently.

Undo/Redo Features

Implement undo/redo functionalities to manage user actions within the worksheet.

Manage Hyperlinks, Comments, and Pictures

Hyperlinks

Insert, edit, or remove hyperlinks to navigate within or outside the workbook.

Comments and Pictures

Add, modify, or delete comments and images to enhance cell content.

Integration and Customization

WPF and Custom Menus

WPF Integration

Embed GridDesktop into WPF applications with WindowsFormsHost for interactive Excel® handling.

Context Menu Customization

Modify right-click context menus for tailored user workflows.

Localization

Custom Localization

Localize GridDesktop controls by loading custom resource files for menus and toolbars.

Get Started

Are you ready to give Aspose.Cells.GridDesktop a try? Simply execute Install-Package Aspose.Cells.GridDesktop from Package Manager Console in Visual Studio to fetch the NuGet package. If you already have Aspose.Cells.GridDesktop and want to upgrade the version, please execute Update-Package Aspose.Cells.GridDesktop to get the latest version.

How to Use Aspose.Cells.GridDesktop

Upgrade from Aspose.Grid.Desktop

The Aspose.Grid.Desktop namespace is renamed to Aspose.Cells.GridDesktop. There are no major API changes—just update the namespace to switch.

Create and Use GridDesktop Control

1. Create a Windows Application project in Visual Studio.
2. Drag and drop the Aspose.Cells.GridDesktop control from the Toolbox to your form.
3. Run the application to see the control on the form. You can interact with the GridDesktop by adding values, adjusting row height, column width, and more through its context menu.

How to Use FormulaBar with Aspose.Cells.GridDesktop

Steps to Add FormulaBar

1. Create a Windows Forms App (.NET Framework) in Visual Studio.
2. Add GridDesktop and FormulaBar controls from the Toolbox by selecting "Choose Items..." and adding references to Aspose.Cells.GridDesktop.dll.
3. Drag and drop both controls onto the form and link the FormulaBar to the GridDesktop control via the properties tab.
4. Run and test the application to ensure FormulaBar and GridDesktop are linked correctly.

Tags

.NET Excel Grid Control | Excel-like GUI Control | Spreadsheet Data Manipulation | GridDesktop Control | Excel Formula Calculation | Excel PivotTables | Cell Formatting | Excel Integration | Data Validation | WPF Grid Control | Export to DataTable | Merge and Unmerge Cells | Row and Column Styling | Undo Redo Support | Zoom Control | Named Ranges | Hyperlinks | Grid Customization | Context Menu Customization | Localization Support | Excel Charting | FormulaBar Integration