GemBox.Spreadsheet 3.9 Source Code Retail » Developer Team - The Best Site for Developers

GemBox.Spreadsheet 3.9 Source Code Retail

GemBox.Spreadsheet 3.9 Source Code Retail
GemBox.Spreadsheet 3.9 Source Code Retail | 2 Mb


GemBox.Spreadsheet is a .NET component that enables developers to read, write, convert and print spreadsheet files (XLSX, XLS, ODS, CSV, HTML, PDF or XPS) from their .NET applications using one simple API. GemBox.Spreadsheet requires only .NET Framework and is many times faster than Microsoft Excel automation. GemBox.Spreadsheet is a .NET component that enables developers to read, write, convert and print spreadsheet files (XLSX, XLS, ODS, CSV, HTML, PDF, XPS) from .NET applications in a simple and efficient way without requiring Microsoft Excel to be installed on the server.

GemBox.Spreadsheet advantages

Unified programming interface for multiple file formats (XLSX, XLS, ODS, CSV, HTML, PDF and XPS).
No dependency on Microsoft Excel.
Many times faster than Microsoft Excel automation.
Plain and fair licensing. More »
100% managed code (C#), follows .NET class library design guidelines.
Simple and easy-to-use programming interface.
Preserves unsupported file format features.

Common uses

GemBox.Spreadsheet is used in a wide range of scenarios, from individual developers who need a simple way to read and write Excel documents to large corporations which need to generate large reports quickly and efficiently.

Some common uses are:

Building Excel reports.
Importing and exporting spreadsheet data to DataTable.
Reading, writing or modifying XLSX, XLS, ODS, CSV or HTML files.
Exporting to HTML, PDF and XPS from XLSX, XLS, ODS or CSV files.
Filling of XLSX, XLS or ODS forms.
Conversion between XLSX, XLS, ODS, CSV, HTML, PDF and XPS files.
Create charts.
Print reports.

GemBox.Spreadsheet Features

Read Microsoft Excel files (XLSX, XLS, ODS or CSV) and HTML files.
Write / create and convert to XLSX, XLS, ODS, CSV, HTML, PDF, XPS and image formats.
Print spreadsheets or charts.
Protect and encrypt spreadsheets.
View spreadsheets or charts in WPF applications.
Get, create or edit sheets, rows, columns, cells, formulas, hyperlinks, comments, images, charts.
Get, create or edit styles and formatting.
Get, create or edit headers and footers, grouping and outlining, data validation, sheet protection, document properties, print and view options.
Get, create or edit row height and column width, print titles and area, freeze or split panes.
Import or export spreadsheet data from/to DataTable.
Search or sort spreadsheet data.
Preserve unsupported elements (illustrations, shapes, certain charts, autofilter, conditional formatting, macros, pivot tables, smart arts, sparklines, slicers).


New in GemBox.Spreadsheet 3.9:

Major overhaul of internal implementation and public API. As a result, memory consumption is lowered almost by half which means that you can load twice larger files than with previous versions. Public API exposes additional members like ExcelCell.Row and ExcelCell.Column without any memory overhead.
Complete rewrite of cell formatting code. Cell formatting API remains unchanged, but behavior is now identical to MS Excel‘s. For more details, see remarks of CellStyle type.
New features in cell formatting:
Theme colors.
Gradient cell fills.
Support for all workbook styles.
Support for PDF encryption.
Simplified API.
Improved help documentation.
Fixed various other small issues and nuisances.



Information
Users of Guests are not allowed to comment this publication.