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).




[/b]

[b] Only for V.I.P

Warning! You are not allowed to view this text.