GemBox.Spreadsheet

New in GemBox.Spreadsheet v3.7:

• Write support for the:
• Adobe Portable Document Format (PDF)
• Microsoft XMP Paper Specification (XPS)
• Image formats (BMP, GIF, JPEG, PNG, TIFF, WMP)
• MIME HTML (MHTML) format
• Support for printing
• Convert a spreadsheet to the XpsDocument and ImageSource (providing a means to embed a spreadsheet in WPF application with DocumentViewer and Image controls)
• Support for exporting and importing spreadsheet to System.Windows.Forms.DataGridView
• Unification of Free and Professional versions. Easier performance evaluation
• Simplified API
• Improved help documentation

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.5 and preservation of new Excel 2010 and Excel 2013 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:

• Building Excel reports
• Importing and exporting spreadsheet data to DataTable
• Reading, writing or modifying XLS, CSV, XLSX or ODS files
• Exporting to HTML, PDF and XPS from XLS, CSV, XLSX or ODS files
• Filling of XLS, XLSX and ODS forms
• Conversion between XLS, CSV, XLSX, ODS, HTML, PDF and XPS files
• Print reports

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. SpreadsheetInfo.FreeLimitReached events allows you to control what happens when your application 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 2012, and it works on .NET Framework 2.0, 3.0, 3.5, 4.0 and 4.5.

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.