GemBox.Spreadsheet - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

GemBox.Spreadsheet by GemBox Software

URLs: gembox-spreadsheet, gembox spreadsheet, gemboxspreadsheet, gembox

Easily create, convert, write and read Excel files. 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 automation object. GemBox.Spreadsheet is licensed per developer, server deployment is royalty free.

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.

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

Easily create, convert, write and read Excel files.

Pricing: GemBox.Spreadsheet Professional V3.5 1 Developer License, GemBox.Spreadsheet Professional V3.5 4 Developer License, GemBox.Spreadsheet Professional V3.5 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address), GemBox.Spreadsheet Professional V3.5 Source Code License (Requires a developer license for each developer), GemBox.Spreadsheet Professional V3.5 Upgrade License 1 Developer Upgrade License from previous version, GemBox.Spreadsheet Professional V3.5 Upgrade License 4 Developer Upgrade License from previous version, GemBox.Spreadsheet Professional V3.5 Upgrade License 1 Site Wide Upgrade License (Allows Unlimited Developers at a Single Physical Address), GemBox.Spreadsheet Professional V3.5 Upgrade License Upgrade for Source Code License (Requires a developer license for each developer)

Evals & Downloads: Read the GemBox.Spreadsheet help file, Read the GemBox Software License Agreement, Download the GemBox.Spreadsheet V3.5 Free Edition on to your computer - Limited functionality

Operating System for Deployment: Windows 7, Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: .NET Class, 100% Managed Code

Built Using: Visual C# .NET

Compatible Containers: Microsoft Visual Studio 2010, Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Studio .NET 2003, Microsoft Visual Studio .NET, Microsoft Visual Basic 2010, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual Basic .NET 2003, Microsoft Visual Basic .NET, Microsoft Visual C++ 2010, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C++ .NET 2003, Microsoft Visual C++ .NET, Microsoft Visual C# 2010, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Visual C# .NET 2003, Microsoft Visual C# .NET, Microsoft Office 2010, .NET Framework 4.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Keywords: Excel BIFF XLS CSV reporting Excel Lite GemBox Spreadsheet Gem Box XLSX OpenXML openxml GemBox.Spreadsheet GemBox Spreadsheet GemBoxSpreadsheet HTML Export ODS OpenDocument

Spreadsheet spread sheet worksheet workbook excel lotus 123 1-2-3 xls xl

Conversion Convert converts converting

Reporting Reports Report

Text word words processing textbox

Part numbers: PC-516072-389888 516072-389888 PC-516072-389898 516072-389898 PC-516072-389890 516072-389890 PC-516072-389900 516072-389900 PC-516072-389892 516072-389892 PC-516072-389894 516072-389894 PC-516072-389896 516072-389896 PC-516072-389902 516072-389902

Mfr. Part No: GS35N01 GS35N04 GS35NSC GS35NSW GS35U01 GS35U04 GS35USC GS35USW