Aspose.Cells.GridDesktop 24.9.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