HANDY AND EFFECTIVE EXCEL LIBRARY FOR .NET

CodeUltimate 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. CodeUltimate Excel lets you create excel files from the stream, files, and memory.

CodeUltimate Excel Key Features

Workbook Traits

  • Create Excel workbooks on the fly
  • Ease to modify an already available workbook
  • Support to load existing workbook from files and stream
  • Generate excel documents from scratch
  • Ability to save, update the document to the client browser
  • Functions and formulas are fully supported
  • Multiple file sheet supported 
  • Named ranges are used to calculate a range of cell
  • Add, delete, modify formulas and functions and settings
  • Ease to load, create, modify excel workbooks
  • Ability to use custom XML documents
  • Ability to open an existing excel document from file and stream 
  • Ease to hide and show workbook
  • No need for third-party libraries
  • Ability to add custom XML document file
  • Easy to use, load, modify multiple document files
  • Ability to create, add, modify named ranges 
  • Create, modify, load formula auditing settings

Charts Traits

  • Ease to create many types of  charts 
  • Support to create, edit and modify  3-D charts
  • Sparklines add, edit options
  • Ability to use a Pivot table
  • Ease to open, load and modify existing tables
  • Support to create, edit and modify  2-D charts
  • Ability to use custom charts
  • Support settings of charts
  • Support different types of Pivot tables

Import/Export Data

  • Import/export data from various sources: DataSets, DataTable, Array, DataColumn and etc  
  • Support to export data from files  and streams
  • Ease to use External sources to import/export data: MS Access, Database, and etc
  • Ease to import data in files, streams
  • Ability to load import/export data from dynamic and business objects
  • Large data import/export memory optimization
  •  Ease to import/export data to Word

Worksheet Traits

  • Create, load, add Worksheets from scratch
  • Formatting is supported
  • Ease to move ranges over worksheets
  • Provide different copy options for range copy
  • Number Formats get, set
  • Header and footer settings are supported
  • Support Text Alignment settings
  • Ability to get, modify, load paper size, margins, page size, scaling and orientation
  • Fill settings get, set
  • Ease to edit dill settings
  • Ability to convert a range of worksheet into a single  image
  • Support various Excel Theme: 2007 and 2010
  • Support for macros
  • Ability to preserve macros
  • Horizontal and vertical page breaks
  • Support to load existing worksheets
  • Support to use ranges
  • Support for copy range
  • Copy Range over worksheets
  • Font Settings get, update, set
  • Ease to change header and footer properties and settings
  • Print Settings are supported
  • Custom page breaks 
  • Border settings get, set
  • Ease to edit border settings
  • Worksheet to image conversion
  • Charts to images conversion
  • Rows and columns auto sizing
  • Support to edit orientations: horizontal and vertical
  • Support to get, set and edit custom page breaks

Security And Data Features

  • Ease to apply data validations
  • Provide data sorting
  • Ability to open Encrypted/Decrypted documents
  • Easily protect/unprotect documents
  • Ease to replace data of worksheet
  • Support to save decrypted documents
  • Support to lock cells
  • Ability to add, update Data validations
  • Supported Encrypted/decrypted documents
  • Ease to encrypt/decrypt existing documents
  • Ability to protect/unprotect the worksheet
  • Support to save encrypted documents
  • Workbook protect/unprotect ability
  • Support to unlock cells

Images, Shapes, Row, Column, Link

  • Add, edit, delete images in a worksheet
  • Ability to merge and unmerge cells in a worksheet
  • Ability to set, edit freeze/unfreeze settings
  • OLE object add, remove  
  • Support to group/ungroup columns and rows
  • Comments can be added, remove, edit 
  • Ability to edit, create a combo box
  • Ease to add, remove background images
  • Ease to add, remove hyperlinks
  • Autoshapes create, edit, delete supported
  • Ease to unhide/hide rows and columns
  • Ease to split panes
  • Working with group data
  • Rows and columns manipulation
  • Checkboxes are supported to add, remove, edit
  • Support background images 
  • Hyperlinks are supported
  • Support subtotal of group data