GemBox.Spreadsheet - .NET - V3.1 - Resumen

de GemBox Software - Tipo de producto: Componente / .NET Class / 100% Managed Code

Resumen

GemBox.Spreadsheet by GemBox Software

Easily create, convert, write and read from Microsoft Excel files. GemBox.Spreadsheet is a .NET component that provides elegant and high performance way to write and read from XLS files (BIFF format), CSV files (text format) or XLSX files (Excel 2007 XML format) without the need for Microsoft Excel on either the developer or client machines. Generated files can be opened in any Excel version from Office 97 and any application supporting the BIFF8 format (like OpenOffice). Fully generic HTML export (XHTML format) is also supported. Server deployment is royalty free.

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 the 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 a 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.

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)

PartNumbers: PC-516072-157609 516072-157609 PC-516072-157614 516072-157614 PC-516072-157610 516072-157610 PC-516072-157615 516072-157615 PC-516072-157611 516072-157611 PC-516072-157612 516072-157612 PC-516072-157613 516072-157613 PC-516072-157616 516072-157616

Publisher PartNumbers: GS29N01 GS29N04 GS29NSC GS29NSW GS29U01 GS29U04 GS29USC GS29USW

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

Resources: Read the GemBox.Spreadsheet help file, Read the GemBox Software License Agreement, Download the GemBox.Spreadsheet V3.1 Free Edition on to your computer - Limited functionality

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

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 2008, Microsoft Visual Studio 2005, Microsoft Visual Studio .NET 2003, Microsoft Visual Studio .NET, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual Basic .NET 2003, Microsoft Visual Basic .NET, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C++ .NET 2003, Microsoft Visual C++ .NET, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Visual C# .NET 2003, Microsoft Visual C# .NET, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0, .NET Framework 1.1, .NET Framework 1.0

Search Items: New Product June 05, New Product Aug 05, New Product Sep 05

Keywords: Text word words processing textbox Spreadsheet spread sheet worksheet workbook excel lotus 123 1-2-3 xls xl Reporting Reports Report Conversion Convert converts converting Author Excel BIFF XLS CSV reporting Excel Lite GemBox Spreadsheet Gem Box XLSX OpenXML openxml GemBox.Spreadsheet GemBox Spreadsheet GemBoxSpreadsheet HTML Export