GemBox.Spreadsheet v3.3 Released
GemBox.Spreadsheet is a .NET component that enables developers to write, read or convert spreadsheet files (XLS, CSV, XLSX,
HTML or ODS) from their .NET applications using one simple API. GemBox.Spreadsheet
requires only .NET Framework and is many times faster than Excel Interop/Automation object. GemBox.Spreadsheet Free Excel component is free of charge while GemBox.Spreadsheet Professional is a commercial version.
Some of the new features:
- Full support for OpenDocument spreadsheet (.ODS) file format - Read and write ODS/ODF files from .NET
- XLS formula parser now supports additional 150 Excel functions
- New sample explorer
Other 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
Examples of common uses of GemBox.Spreadsheet:
- Reading XLS, XLSX, CSV and ODS files
- Writing XLS, XLSX, CSV and ODS files
- Writing Reports in XLS, XLSX, CSV and ODS files
- Importing data from Excel files to .NET
- Exporting data to Excel files from .NET
- Import or Export DataGrid to Excel or HTML files
- Import or Export DataSet to Excel or HTML files
- Import or Export DataTable to Excel or HTML files
- Exporting Excel files to HTML from .NET
- Converting XLS, XLSX, CSV, HTML and ODS
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
On-line SampleExplorer contains samples for both C# and Visual Basic .NET. GemBox.Spreadsheet
can be used from Visual Studio 2005 and Visual Studio 2008, and it works on .NET
Framework 2.0, .NET Framework 3.0 and .NET Framework 3.5.
We only charge for developer licenses and use flexible licensing, meaning developer
can also install GemBox.Spreadsheet on his 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.