Aspose.Grid for .NET

What’s new in Aspose.Grid 2.0.1?

• Now supports importing/exporting to Excel 2007 (xlsx) file format
• Now supports reading of merged cells style from an Excel file.
• Now supports Auto RowFilter and Custom RowFilter (adding IgnoreCase and IsStartWithCriteria properties to GridColumn to customize behaviors of auto rowfilter)
• Added CustomMsgTitle property to Validation to customize the title of MessageBox
• Added RecalculateFormulas property
• Added Width and Height properties to Comment
• Added CommentFont property to GridDesktop to set font of Comments
• Added IsVisible property to Worksheet
• Now supports reading/writing CustomProperties of Worksheets in Excel files, and adding read-only CustomProperties property to Worksheets
• Now supports vlookup function/formula
• Now supports Undo/Redo features when changing values of cells
• Added ContextMenuManager property to GridDesktop to manage context menu
• Added RowColumnHiddenChanged event
• Now supports multi-selection of rows/columns/regions
• Now supports importing/ exporting frozen Panes from/ to excel files

What’s new in Aspose.Grid 1.9x?

• New formula engine, improves the performance of calculations more than 20x than the old one
• Provides a new interface that enables users define their own formula functions. Please see the API document about WebWorksheets.RegisterCustomFunctionHandler for details
• Two new server event:RowDeleting, ColumnDeleting
• New client-side functions: getCellValue, setCellValue, getActiveRow, getActiveColumn, setActiveCell, getActiveCell, setActiveCellByCell, getCell, getCellRow, getCellColumn, getCellValueByCell and setCellValueByCell
• New client-side events: onSubmit, onError, onSelectCell, onUnselectCell, onDoubleClickCell, onCellError, onCellUpdated
• Includes full featured demo that shows the usage of the client-side functions and events
• Supports multiple rows selecting
• Supports keyboard selecting by holding the shift-key and pressing the arrow keys
• Supports create hints in the row and column headers
• Supports paste a string to multiple cells
• Supports datetime calculation. You may add days in a number to a date type value, or subtract a date value from another date value to get the duration in days between the two date value

General Features

• Provides components for both desktop and web applications
• Provides support for importing from and exporting to Excel spreadsheets
• Provides an easy to use, feature-rich API for complete control of the look, feel and behavior of the grid.
• Provides easy to apply skins
• Provides extensive support for formulas
• Provides support for multiple pages
• Provides support for a large array of cell types
• Provides support for both edit and view modes
• Provides support for hiding and unhiding of rows and columns
• Provides easy, full featured examples in both C# and VB.NET

Aspose.Grid.Desktop - Aspose.Grid.Desktop is a GUI based winform control.

Product Features:

• Create desktop spreadsheet application
• Manipulate data and cell styles in Aspose.Grid.Desktop control
• Various cells format settings and format painter
• Easy, full featured examples in both C# and VB .NET
• Support for loading data directly from Excel® spreadsheets
• Support for importing data directly from a DataTable object
• Support for creating and calculating formula

Product Description:

Aspose.Grid.Desktop is a GUI based winform control that enables developers to create desktop spreadsheet application. Aspose.Grid.Desktop can load Excel® spreadsheets with out any need of Microsoft Excel®. Developers can easily drag the Aspose.Grid.Desktop control from Visual Studio .Net toolbox and drop it on their windows forms or usercontrols. The control not only supports importing of spreadsheet files and other data sources but also provides a set of APIs to create contents and styles from scratch.. These features make Aspose.Grid.Desktop extremely convenient for developers to create powerful and professional desktop applications to display and manage spreadsheet data.

Aspose.Grid.Web - Aspose.Grid.Web is a visual ASP.Net component.

Product Features:

• Create interactive web pages that look and feel like a desktop spreadsheet application.
• Manipulate data in web pages and post back to server side
• Various cells format settings
• Easy, full featured examples in both C# and VB .NET
• Support for loading data directly from Excel® spreadsheets
• Support for creating web page - spreadsheet displays from scratch
• Support for importing data directly from a dataview object
• Support for embedding standard styles as well as custom styles
• Support for creating and calculating formula on web pages
• Support Freeze Panes
• Keyboard navigation

Product Description:

Aspose.Grid.Web is a pure .Net web component that delivers interactive web pages that look and feel just like a spreadsheet window. Aspose.Grid.Web can load Excel® spreadsheets without any need for Microsoft Excel®. Developers can easily drag the component from Visual Studio toolbox and drop it on their web pages. The component not only supports importing of spreadsheet files and data sources, but also provides a set of APIs to create contents and styles from scratch. These features make it extremely convenient for developers to create powerful, professional displays of spreadsheet data.