Create, Modify and load your excel sheet without any hassle

Now you can create, load, and manipulate your excel documents very easily by using a high-performance and secure excel library in your .NET applications effectively with a couple of lines of code.

Workbook Features

  • Create Excel files with a single line of code. The help file contains code examples for all methods and properties.
  •  Modify an existing workbook
  •  Open an existing Excel document from a file stream or file system
  •  Save the document to a local file, stream, or display in the client browser
  •  custom XML documents
  •  Provides Access, create or modify document properties
  •  Read and write functions and formulas.
  •  Add or modify named ranges
  •  Use named ranges for the calculation for different ranges of cells
  •  Set or edit formula auditing settings
  •  Manual and Automated calculation switch
  •   custom XML documents
  •  Show/hide worksheets
  •  On-demand loading of worksheets when Excel file contains multiple worksheets


Import and Export

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

Charts

  • Create and Modify 2-D charts
  • Create and Modify 3-D charts
  • Create and Modify custom charts
  • Create and Modify dit sparklines.
  • Supports for pivot tables with ease.
  • Create and edit pivot tables with just a few lines of code.
  • Supports for various pivot table settings like the visibility of field list, page, row & column filters, collapse button, header captions, field caption and field option, etc.

Worksheet Features

  • Supports for Worksheet formatting
  • Create and Modify conditional formatting
  • Autofit or resize rows and columns
  • Set or Modify cell border settings
  • Set or Modify all the cell text alignments
  • Set or Modify number formats
  • Set or Modify fill settings
  • Set or Modify font settings
  • Get and apply header and footer settings
  • Set or Modify horizontal and vertical page breaks
  • Set or Modify custom page breaks
  • Supports for various page setup settings like 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 your worksheets
  • Supports for Excel 2007 themes to look and feel
  • Add or copy worksheets in the same workbook / across workbooks
  • Macros preservation supported
  • Converts an entire worksheet into a single image with ease.
  • Converts a specific range of a worksheet into a single image with ease.
  • Converts charts to images with just a few lines of code.

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

  • Create and modify auto shapes
  • Create and edit text boxes
  • Create and edit check boxes
  • Create and edit combo boxes
  • Create and edit comments
  • Row and column manipulation with no effort.
  • Set/modify settings to freeze, unfreeze, and split panes
  • Hide /unhide rows and columns
  • Merge /unmerge cells
  • Add and remove images in worksheets with less effort.
  • Set or modify background image very easily
  • Add, delete, and edit hyperlinks with ease.
  • Group/ungroup rows and columns
  • Add/Modify subtotals of grouped data with no effort.
  • Add and remove OLE objects

Data and Security

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

Get Started Today

ComponentPro is used by tens of thousands of developers worldwide

Download Your Free 30-Day Trial