Home Products Excel Component

Ultimate Excel Component for .NET and Silverlight

Excel library for .NET Framework - Create & edit XLS files, and create reports

A high-performance and reliable Excel library which lets you add Excel functionality to your .NET applications easily with a few lines of code. Ultimate Excel is now available for .NET and Silverlight.

Ultimate Excel for .NET is also included in

Powerful Excel Component

Ultimate Excel for .NET is a 100%-managed Excel document component that helps you add Excel capabilities in your .NET applications. With a few lines of code, you can create a complex Excel document from scratch or load an existing Excel file. In addition to the ease-of-use and flexibility, the Ultimate Excel component also offers many features including: drawing text, image, tables and other shapes, compression, hyperlinks, security and custom fonts. Excel files created using the Ultimate Excel component are compatible with all versions of Microsoft Excel.

ultimate excel is optimized for performance

Intuitive and Fully Documented API

Connect, authenticate the user to the server and transfer files with a few lines of code using the intuitive API of ComponentPro's Ultimate Excel. By using 100% managed code written in C#, the component takes advantage of the numerous built-in features of the .NET Framework to enhance performance. Moreover, the library is CLS compliant, and it does not use any unsafe blocks for minimal permission requirements.

Our classes are fully documented with detailed example code which helps you shorten the learning curve. If your development environment is Visual Studio, enjoy the full integration of the online documentation. Just mark or select a keyword and press F1 in your Visual Studio IDE, and the online documentation is represented instantly.

ultimate sftp is intuitive and fully documented API

Supports .NET and Silverlight

The component not only supports .NET Framework but it also allows you to develop similar applications in Silverlight.

Developers can use the library in any .NET languages like C#, VB.NET, J#, C++, and F#. The following is a list of all supported platforms:

  • .NET Framework: 2.0, 3.5, 4.0, 4.5, 4.5.1
  • Silverlight: 3, 4, 5
ultimate sftp support .net framework, mono, android, ios, and .NET CF

Features

Drawing Text

  • Drawing MultiPage text in Excel pages
  • Center, Left, Right and justify text alignment
  • Drawing RTF text
  • Inserting Unicode
  • Drawing RTL text
  • Drawing HTML formatted text
  • Drawing text with bullets and lists

Font Types

  • Predefined fonts, True type fonts and CJK fonts

Drawing Shapes

  • Drawing shapes such as rectangles, circles, arcs, ellipses, etc.
  • Filling shapes by using brushes like gradient brush, tiling brush, radial brush, etc.
  • Transparent drawing of shapes
  • Drawing lines with different patterns
  • Colors such as RGB, CMYK and gray scales

Image Support

  • Loading Images to Excel documents from streams and files on disk
  • Drawing both scalar and vector images in documents
  • Soft Mask Images and Watermarks

Table Support

  • Importing and Formatting ADO.NET tables, and also formatting rows and columns of the table accordingly
  • HeaderRow formatting
  • Inserting Graphic elements inside the table
  • Inserting Tables in the header

Interactive Features

  • Various types of Annotations
  • Attaching various files to the Excel document
  • Configuring Bookmarks for the pages in the document
  • Importing and Reorganizing the bookmarks while merging multiple documents. Ultimate Excel adds an ability to preserve the bookmarks while merging multiple documents with bookmarks in this new version
  • Links to a page in the same document
  • Hyperlinks for Web URLs
  • Hyperlinks for other external files

Form Fields

  • Drawing Form Fields like buttons, text boxes, list boxes, check boxes, etc., into the Excel document
  • Form field actions

Page Elements

  • Drawing Header and Footer in a Excel document
  • Inserting Dynamic fields

Document and Page Settings

  • Different Orientations of the Excel page such as Landscape and Portrait
  • Setting pages with different sizes
  • Setting document properties like Author Name, Creation Date, Keywords, etc.
  • Hiding the Toolbar, Menubar, etc.
  • Setting page margins in the document
  • Setting the Page Mode and Page Layout
  • Page transitions

Compression

  • Compression for reducing the size of the created Excel files

Security

  • Setting the Owner or User Password
  • Allowing or disallowing permissions over Excel document
  • Digital Signature—certify and standard signatures
  • HTML Pagination and HTML Streams

    • HTML web page pagination to render large web pages into Excel without any text truncation at page breaks. Also, you can render the web pages as streams to create Excel without any intermediate files on disk

    Enhanced Bookmarks Support

    • Applying rich styles for bookmarks of Excel with this version. You can apply new styles for the bookmarks, and differentiate the child bookmarks with customized appearances. This version also provides support for inserting bookmarks between other bookmarks

    Rich EMF and RTF

    • Rendering RTF text that has rich formatting into Excel without any overlapping

    Page Labels

    • You can control the text with the new version of Excel by using Page Labels (Pages tab in Adobe Reader) feature

    Dynamic Fields

    • Flattening a particular field as well as whole form
    • Creating special objects that display information calculated automatically
    • Inserting dynamic information into the Excel document

    Reading Existing Excel Document

    • Reading existing Excel documents from streams, bytes and disks
    • Opening and modifying the encrypted document with password

    Modifying Existing Excel Document

    • Merging multiple Excel documents into a single document
    • Splitting a single Excel document into multiple documents
    • Importing pages from one document to another
    • Creating new pages in the existing document
    • Preserving bookmarks while merging documents with bookmarks
    • Importing Excel pages as templates
    • Stamp or watermark the existing document
    • Encrypting the existing document

    Form Filling and Flattening

    • Reading existing Excel acroforms
    • Filling the acroform
    • Flattening a particular field or whole form
    • Merging multiple Excel forms
    • Form reading and form filling

    Support

    • Royalty free run-time.
    • 1 year minor and major product updates.
    • Full Windows Vista support.
    • Supports Visual Studio 2005 to 2013 (.NET 2.0 to .NET 4.5.1), Delphi 8, C# Builder and other compliant development environments.
    • Ultimate Excel can run under .NET Framework 2.x, 3.x, and 4.0.
    • Ultimate Excel can be used from ASP.NET web pages, ASP.NET MVC, Windows Forms, Web Services, WPF, Silverlight applications.

    .NET Technology

    • 100% managed code written in C# (Complete source code included in the Gold License with Source Code).
    • CLS compliant (Common Language Specification).
    • Object-oriented design created specifically for .NET Framework version 2.x and above.
    • Does not use unsafe blocks for minimal permission requirements.
    • Seamless integration with the .NET base class libraries.
    • Documentation fully integrated into Visual Studio .NET.
    • C# and VB.NET samples included in the setup package show how to work with Ultimate Excel.

Testimonials

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