A high-performance and reliable Excel Library which lets you add create, load, and manipulate Excel documents right in your .NET applications quickly with a few lines of code. Atp Excel is a 100%-managed, highly effective and effortless .NET class library that helps to create, load, and modify Excel files with ease and few lines of code. We have ready-made classes, functions to add and use Excel components in C#, VB.NET, ASP.NET, Desktop, and Mobile applications. Atp Excel lets you create excel files from the stream, files, and memory.

For more information about our products, please visit: https://www.atp-inc.net/

Key Features of Excel Library

Workbook Features

1. Create Excel files with a single line of code. The help file contains code examples for all methods and properties.
2. Modify an existing workbook
3. Open an existing Excel document from a file stream or file system
4. Save the document to a local file, stream, or display in the client browser
5. Custom XML documents

Import and Export

1. Supports for importing data with different data sources like DataSet, DataTable, DataColumn, DataView, and Array
2. Import data from Business Objects, dynamic objects
3. Supports for importing data from various external sources like Microsoft Access, SQL Server and Excel
4. Optimize memory management techniques are used when importing large amounts of data
5. Export data from Excel document to targets sources like DataTable, DataView, etc.

Charts

1. Create and Modify dit sparklines.
2. Supports for pivot tables with ease.
3. Create and edit pivot tables with just a few lines of code.
4. Supports for many pivot table setting

Worksheet Features

1. Supports for Worksheet formatting
2. Create and Modify conditional formatting
3. Autofit or resize rows and columns
4. Set or Modify cell border settings

Supports for Shapes, Images, Link, OLE, Row and, Columns

1. Add and remove images in worksheets with less effort.
2. Set or modify background image very easily
3. Add, delete, and edit hyperlinks with ease.
4. Group/ungroup rows and columns

And many more Feature

Requirements

Visual Studio 2012 and above

Optimized for Visual Studio