Aspose.Grid for .NET 2.0.0.0

Aspose.Grid for .NET 2.0.0.0 consists of two different GUI based .NET components to support desktop and web applications. It enables you to import from and export to Excel spreadsheets, DataTable and DataView.

Worksheet processing features like worksheet pagination, add/remove worksheets, add/insert/remove rows and columns of a worksheet and protecting your cells by locking or hiding them are also supported. It further supports formulae, pictures, hyperlinks, grid events and creating dynamic pivot tables.

Major Features:

1. 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.
   
2. 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.
3. 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.
4. 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.

WareSeeker Editor