GemBox.Spreadsheet

New in GemBox.Spreadsheet v3.5:

• Support for Medium Trust environment
• Full support for Data validation in XLSX
• Collections now implement generic versions of appropriate .NET interfaces
• Exporting to html supports exporting pictures
• Methods for sorting
• New methods for extracting to DataTable without needing to predefine DataTable
• Full support for sheet protection in XLSX
• Helper methods for setting Print Titles and Print Area
• Support through API for print gridlines and left/right header/footer in ODS

GemBox Spreadsheet Features:

• Various cell data types (numbers, strings, dates, floating point etc.)
• International characters (Unicode support) and international date/time formats (custom number formatting)
• Cell styles (alignment, font properties, indentation, rotation, borders, shading, protection, text wrapping and shrinking, number formats etc)
• Font formatting (size, color, font type, italic and strikeout properties, different levels of boldness, underlining, subscript and superscript)
• Smart caching for cell styles and font properties removes duplicates in an efficient way so you don’t have to worry about breaking the Excel cell style limit
• Multiple worksheets
• Row and column styles, row height and column width
• Row and column grouping and outlining
• Merged regions
• Formula support (absolute and relative references, names, 3D cell references, more than 220 supported functions in XLS, unlimited formula support in XLSX)
• Named ranges
• Worksheet and row copying, deletion and insertion
• XLS reading / writing – preserving print area, summaries and similar excel objects not directly supported by GemBox.Spreadsheet API
• CSV reading / writing – support for comma, tab, semicolon or any other delimiter
• XLSX reading / writing (Excel 2007 Open XML) – preserving illustrations, charts, pivot tables, data validations, shapes, macros and similar excel objects not directly supported by GemBox.Spreadsheet API
• Images and comments in XLSX files
• Horizontal and vertical page breaks, other print properties
• Worksheet Zoom, FirstVisibleRow, ShowGridLines, and other view properties
• Timesaving methods: ExcelWorksheet.InsertDataTable(), ExcelWorksheet.ExtractToDataTable() , ExcelColumn.AutoFit() and CellRange.FindText()
• Template support – create new workbooks using existing workbook as a template
• Mono support (GemBox.Spreadsheet.dll works on Unix/Linux/OsX machines with Mono)
• Save to stream and load from stream features (for all file formats)
• ASP.NET support
• Generic HTML export
• Full support for OpenDocument spreadsheet (.ODS) file format
• Full support for .NET Framework 4.0 and preservation of new Excel 2010 features

Implementation details:

• 100% managed code
• Fully compliant with the Common Language Specification (CLS), so you can use it from any .NET language
• Programming interface which is fully object-oriented but still similar to Microsoft Excel object, so you can learn it easily

Most common uses of GemBox.Spreadsheet:

• CSV/XLS/XLSX /ODS files reading, writing or modification
• HTML export from CSV/XLS/XLSX/ODS files
• Filling of XLS/XLSX/ODS forms
• Conversion between CSV, XLS, XLSX, ODS and HTML files
• Splitting of XLS/XLSX/ODS files into multiple files (and other way round)

GemBox.Spreadsheet comes in two editions:

• GemBox.Spreadsheet Free – free version – the same set of features as GemBox.Spreadsheet Professional except it is limited to 150 rows and 5 worksheets per workbook. LimitNear and LimitReached events allow you to control what happens when your application is near limit or when it reaches free version limit.
• GemBox.Spreadsheet Professional – commercial version – not limited by number of rows or worksheets. Comes with full technical support and 30-day money back guarantee from the day of purchase.

You can equally use GemBox.Spreadsheet from your desktop or web applications. GemBox.Spreadsheet is very fast (about 260 times faster than Microsoft Excel object) and with the small memory footprint.

On-line SampleExplorer contains samples for both C# and Visual Basic .NET. GemBox.Spreadsheet can be used from Visual Studio 2005 to Visual Studio 2010, and it works on .NET Framework 2.0, 3.0, 3.5 and 4.0.

GemBox.Spreadsheet is licensed per developer, meaning a developer can also install GemBox.Spreadsheet on their notebook or home computer.

You are covered by bug fixes and technical support as long as your product version belongs to one of last two (2) major releases or up to maximum period of one (1) year.