|
GemBox.Spreadsheet V3.1
A Spreadsheet Component for .Net, ASP.Net
GemBox.Spreadsheet is a .NET component which provides easy and high performance way to write, read or convert native Microsoft Excel files (XLS files in BIFF format, CSV files in text format or XLSX files in Open XML format) without the need for Microsoft Excel on either the developer or client machines. Fully generic HTML export is also supported. GemBox.Spreadsheet Free comes free of charge while GemBox.Spreadsheet Professional is a commercial version (licensed per developer).
For more information about this product please visit the
New in GemBox.Spreadsheet v3.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)
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 40 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(), 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 (works on web servers with reduced permissions)
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 files reading, writing or modification
- HTML export from CSV/XLS/XLSX files
- Filling of XLS/XLSX forms
- Conversion between CSV, XLS, XLSX and HTML files
- Splitting of XLS/XLSX 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.
In both Free and Professional version you will receive samples for both Visual Basic .NET and C#, samples for Visual Studio .NET 2003, Visual Studio 2005 and Visual Studio 2008, and our component compiled against .NET Framework 1.1, .NET Framework 2.0, .NET Framework 3.0, .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.
Technical Information
Component Type - Contains the following types of components...
|
