Sign In  Sign Up Live-Chat
Aspose-Banner

Overview

Aspose.Grid is your total grid solution. Aspose.Grid comes packaged with two different GUI based .NET components: one to support desktop applications and another to support web applications. Both versions are equally matched in order to make implementation in either platform a snap. Aspose.Grid provides the ability to import from and export to Excel® spreadsheets. Aspose.Grid also offers an easy to use, feature-rich API which provides developers with complete control over the look, feel and behavior of their grids. Nowhere else will you find a component as feature-rich, easy to use and well priced as Aspose.Grid.



Testimonials

Good and useful product. Great adaptation of fundamental Excel functionalities. Thank you! Nathan Burlak, MJJ Brilliant Inc, USA More..

Convenient Data Exchange
Aspose.Grid allows you to import and export your data to and from Excel Spreadsheets, DataTable and DataView. Aspose.Grid supports four versions of MS Excel files namely Excel 97, Excel 2000, Excel 2002 and Excel 2003.

XLS 2003 XLS 2002 XLS 2000 XLS 97

Extended Worksheet Processing
With Aspose.Grid you can easily Add/Remove Worksheets, Sort Worksheet data both horizontally & vertically, Worksheet Pagination, rename Worksheets and create spreadsheets from scratch. In addition to this, Aspose.Grid allows you to Add/Insert/Remove Rows and Columns of a Worksheet, Hide/Unhide Rows and Columns, Freeze/Unfreeze Rows & Columns and customize the Headers of Rows & Columns. You can also edit multiple cells on client side with a Single PostBack to server side, control the Text Alignment of Cells, manage the Border Settings of a Cell, control the Font Settings of a Cell and Merge or Unmerge Cells. Number/Date/Time Format Settings of Cells and Custom Format Settings of Cells are also supported.

Cell Format and Data Manipulation
Using Aspose.Grid you can easily apply a focused cell’s style and font to other cells using Format Painter, as well as create web based Interactive Grid Applications that look and feel like desktop spreadsheet applications. Aspose.Grid supports client side Cell Formatting and provides both Built-in & Customizable Visual Styles. You also have the option of Adding or Removing Comments, Pictures, Hyperlinks, Validation Rules and Controls (like CheckBox, ComboBox etc.) in Cells. In addition to this, keyboard Navigation of Cells and DropDownList/Regular Expressions Validations are also supported.

Advanced Functionality
Aspose.Grid offers a wealth of advanced features which include the ability to protect your cells by Locking or Hiding them, supports creating and calculating Formulas, allowing you to perform your desired actions under different Grid Events as well as providing 80+ Pre-Defined Functions related to Math, Text & Data, Date & Time and Logic. In addition to this, Aspose.Grid also supports creating dynamic Pivot Tables and allows you to use Aspose.Grid.Web control in Session less Mode and to submit Grid data with a Single Click.