Create, load, and modify Excel files with ease

A high-performance and reliable Excel library which lets you add create, load, and manipulate Excel documents right in your .NET applications easily with a few lines of code.

Ultimate Excel's Key Features

Workbook Features

  • Create an Excel workbook from scratch
  • Modify an existing workbook
  • Open an existing Excel document from file system or stream
  • Save document to a local file, stream, or display in the client browser
  • On-demand loading when Excel file contains multiple worksheets
  • Show and hide worksheets
  • Add custom XML documents
  • Extract custom XML documents
  • Access, create or modify document properties
  • Read and write formulas and functions.
  • Add or edit named ranges
  • Use named ranges for the calculation for a range of cells
  • Set or edit formula auditing settings
  • Automatic and manual calculation switch

Import and Export

  • Supports for importing data with sources from DataSet, DataTable, DataColumn, DataView and Array
  • Import data source can also be from Business Objects, dynamic objects
  • Supports for importing data on-the-fly from various external sources like Microsoft Access, SQL Server and Excel
  • Optimize memory usage when importing large amounts of data
  • Export data from Excel document to targets like DataTable, DataView, etc.

Charts

  • Create and edit 2-D charts
  • Create and edit 3-D charts
  • Create and edit custom charts
  • Create and edit sparklines.
  • Supports for pivot tables
  • Create and edit pivot tables
  • Supports for various pivot table settings like visibility of field list, page, row & column filters, collapse button, header captions, field caption and field option, etc.

Worksheet Features

  • Supports for formatting
  • Create and edit conditional formatting
  • Auto fit or resize rows and columns
  • Set or edit cell border settings
  • Set or edit all the cell text alignments
  • Set or edit number formats
  • Set or edit fill settings
  • Set or edit font settings
  • Get and apply header and footer settings
  • Set or edit horizontal and vertical page breaks
  • Set or edit custom page breaks
  • Supports for various page setup settings such as paper size, margins, orientation, scaling, etc
  • Supports for applying print settings
  • Copy ranges across worksheets
  • Supports for different copy options for range copy
  • Move ranges across worksheets
  • Supports for Excel 2007 themes
  • Add or copy worksheets in the same workbook or across workbooks
  • Macros preservation
  • Converts an entire worksheet into a single image
  • Converts specific range of a worksheet into a single image
  • Converts charts to images

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

  • Create and edit autoshapes
  • Create and edit text boxes
  • Create and edit check boxes
  • Create and edit combo boxes
  • Create and edit comments
  • Row and column manipulation
  • Set or edit settings to freeze, unfreeze, and split panes
  • Hide or unhide rows and columns
  • Merge or unmerge cells
  • Add and remove images in worksheets
  • Set or edit background image
  • Add, delete, and modify hyperlinks
  • Group/ungroup rows and columns
  • Add/edit subtotals of grouped data
  • Add and remove OLE objects

Data and Security

  • Create and edit data validation
  • Set or edit auto-filters to filter data
  • Set or edit data sorting
  • Find and replace worksheet data
  • Open encrypted documents
  • Encrypt and save documents
  • Protect/unprotect workbook
  • Protect/unprotect worksheets
  • Lock/unlock cells (write protection)

Get Started Today

And see why tens of thousands of developers worldwide choose ComponentPro

Download Your Free 30 Day Trial

Supported Platforms

List of the supported platforms

.NET Framework:
2.0, 3.0, 3.5. 4.0, 4.5.x, 4.6.x, 4.7; both 32-bit and 64-bit editions
OS: Windows XP or later
Visual Studio: 2008, 2010, 2012, 2013, 2015, 2017
 

Customers

Over 10,000 customers globally integrate our libraries in their applications

Testimonials

Hear what customers say about our products

Having been using your Ultimate Studio Package for 5 months, and I would like to give your product 5 star rate, your product is one of the best products I've used in over 5 years of C# development. It's a real joy to work with!

Jack Berkhout Senior Software Developer - MCPD Microsoft Corp.

It was a really good idea for me to switch from the previous suite to your Ultimate Studio few months ago. It has a modern design and the classes saved me a lot of time. Thank you very much...

Robert Osorio Senior Developer JPMorgan Chase

Our developers have been using the Ultimate Suite for over 6 mons now on an intranet web application. We were very impressed by the feature-set, the ease of use and the great online tutorials and code examples. I will recommend ComponentPro to my colleages.

Mark Deaney CTO PowerCT

I am impressed with the components in the Ultimate Studio package. I have been developing a commercial desktop application employing virtually all of components, I have found them to be amazing, easy to use and loaded with many features.

Peter Windsor Senior Software Developer Allocate Software

I have been a user of Ultimate Studio package for more than 3 months. Their components are powerful and flexible. I rate them 5 star for the developer support.

Chris Calzaretta Senior Software Developer Quantesys

I'm really happy with your customer support. Your developers response very quick. Keep up the good work!

Burke Jones Project Manager Marquam Group

With their quick response, now I can easily solve my issue by adding a few lines of code to my application. And EXCELLENCE is the word best describes your products.

David Callaghan Senior Software Developer SIEMENS

Your customer support is amazing. Detailed code examples and a friendly and helpful online documentation. Your components are amazing.

Brian Shackelford Software Architect Municipal Technologies

Your products are great. It makes my life so much easier. Now I only need to focus on business logic instead of having to deal with many limitations of the .NET framework.

Geoff Suddard Software Developer Office Choice Limited