GemBox.Spreadsheet Version History

New in GemBox.Spreadsheet 4.1:

Release date: 2016-09-27

New in GemBox.Spreadsheet 3.9:

Release date: 2014-12-23

New in GemBox.Spreadsheet 3.7:

Release date: 2013-02-01

  • Write support for the:
    • Adobe Portable Document Format (PDF),
    • Microsoft XMP Paper Specification (XPS),
    • Single File Web Page (MHTML),
    • Image formats (BMP, GIF, JPEG, PNG, TIFF, WMP).
  • Read and write support for the:
    • Web Page (HTML),
    • Fixed Columns Width Text.
  • Support for printing.
  • Support for XLSX encryption.
  • Support for Charts (graphs).
  • Included utility GemBox.Spreadsheet.WinFormsUtilities.dll for¬†importing and exporting ExcelWorksheet to System.Windows.Forms.DataGridView control.
  • Convert a spreadsheet to the XpsDocument and ImageSource (providing a means to embed a spreadsheet in WPF application with DocumentViewer and Image controls).
  • Unification of Free and Professional versions. Easier performance evaluation.
  • Simplified API.
  • Improved help documentation.
  • Fixed various other small issues and nuisances.

New in GemBox.Spreadsheet 3.5:

Release date: 2011-07-27

  • Support for Medium Trust
  • 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 (column type is defined by the data in appropriate column)
  • 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
  • Inserting/extracting pictures using absolute positioning is now more accurate

New in GemBox.Spreadsheet 3.3:

Release date: 2009-07-14

  • Full support for OpenDocument spreadsheet (.ODS) file format
  • XLS formula parser now supports additional 150 Excel functions
  • Support for document properties
  • New sample explorer (separate download)

New in GemBox.Spreadsheet 3.1:

  • Generic HTML export (override any part of data export with custom method)
  • Customizable ExtractToDataTable methods
  • Hyperlink support in XLSX
  • Native samples and DLL for Visual Studio 2008 (.NET 3.5)

New in GemBox.Spreadsheet 2.9:

  • Read/write support for new XLSX files (Excel 2007 Open XML)
  • Faster loading of XLS files (up to 6 times faster!)
  • Mono support (GemBox.Spreadsheet.dll works on Unix/Linux machines with Mono)

New in GemBox.Spreadsheet 2.7:

  • Save to stream and load from stream features (both XLS and CSV files)
  • Improved ASP.NET support (works on web servers with reduced permissions)
  • Delete(), InsertEmpty() and InsertCopy() methods on ExcelColumn
  • Using 10 to 15 percent less memory when reading or writing XLS files

Note that with version 2.7 we have made some major changes:

a) We changed name, “ExcelLite” is now called “GemBox.Spreadsheet”

b) DLL is now called “GemBox.Spreadsheet.dll”

c) Namespace is now “GemBox.Spreadsheet”

d) Due to many issues with MS control licensing, we no longer support licensing via licenses.licx file, we only support SetLicense() method

e) ExcelLite.SetLicense() is now called SpreadsheetInfo.SetLicense()