About Syncfusion Essential Studio File Formats

Add crucial file format management capabilities to your .NET applications.

Syncfusion Essential Studio File Formats helps you read, write, and modify PDF, Word, PowerPoint, and Excel files using .NET libraries. Included are Essential PDF, Essential DocIO, Essential XlsIO, and Essential Presentation. Essential PDF can create and modify Adobe PDF files, without any external dependencies. Essential DocIO can read, write, and modify richly formatted Microsoft Word files, Essential Presentation allows you to read, write, convert, and rasterize PowerPoint files from .NET (.pptx only) while Essential XlsIO reads and writes Microsoft Excel files. They can be used on systems that do not have Microsoft Word/Excel installed.

Syncfusion Essential Studio File Formats features full-fledged object models similar to (but up to 100x faster than) the Microsoft Office Automation libraries and can be used in Windows forms, WPF, ASP.NET, and ASP.NET MVC applications. The three other included products can be used in Windows forms, WPF, ASP.NET Webforms, ASP.NET MVC, Silverlight (PDF, Word and Excel only), and Universal (PDF, Word and Excel only) applications. Ships with numerous real-world samples.

Syncfusion Essential Studio File Formats includes:

  • Essential XlsIO - A .NET library that can read and write Microsoft Excel files. It features a full-fledged object model similar to the Microsoft Office Automation libraries. It can be used on systems that do not have Microsoft Excel installed, making it an excellent report engine for tabular data.
  • Essential PDF - A .NET library that can create and modify Adobe PDF files. It does not have any external dependencies.
  • Essential DocIO - A .NET library that can read, write, and modify Microsoft Word files. It features a full-fledged object model similar to the Microsoft Office Automation libraries. It can be used on systems that do not have Microsoft Word installed.
  • Essential Presentation - A .NET class library that can read, write, modify and render Microsoft PowerPoint files (*.pptx only). It features a full-fledged object model to represent presentations, slides and its contents. It does not have any external dependencies and can be used on systems that do not have Microsoft Office installed.

Essential XlsIO

  • Blazing Fast Performance. 100x faster than Office automation.
    Essential XlsIO has been optimized for usage on servers where speed and memory usage are critical. It can easily handle multiple requests for report generation in scenarios such as web sites serving reports to hundreds of simultaneous users. Essential XlsIO is also highly optimized to generate Excel files with a large amount of data. It is optimized for both low memory usage and speed. It works more than 100 times faster than Excel automation and consumes much less memory compared to that of Excel.
  • Easily Migrate from Office Automation
    If you have code that's already written using Office automation, it is very easy to migrate that code to XlsIO since the APIs are very similar. However the similarity ends there; XlsIO is more than 100 times faster than Office automation.
  • Compatible with Microsoft Excel Versions 97 to 2013
    Essential XlsIO can read and write files based on all popular Excel file format variants including XLS and XLSX. You can even open a file in one format and save it back in another format.
  • No Server Deployment Fees
    There are no distribution fees, per-server licensing fees, or royalties, making XlsIO very cost-effective.
  • Start Reports with Excel and Finish with XlsIO
    Let designers visually design reports using Microsoft Excel, and then use Essential XlsIO to populate it with dynamic data during run time, to generate an invoice for example. You can save the final report to a local file, stream, stream it to the client browser, or even export to other formats we support.
  • Consume Data Stored in Excel Workbooks
    When you read an existing Excel document using XlsIO, the entire document is parsed and available for manipulation through its object model. This makes consuming data stored in Excel documents as simple as loading a workbook and accessing the data through XlsIO’s intuitive object model.
  • Powerful and comprehensive API
    All of the elements in a typical Excel file like the cell values, formatting, images, charts and pivot tables are accessible through XlsIO’s comprehensive set of API’s. This makes it possible to create richly formatted Excel files as well as extract any desired piece of information in an existing Excel file.
  • Formatting Cells
    There are API’s available to read and write cell formatting options like text color, number formatting, cell background etc. It is also possible to work with named styles to format content.
  • Formulas
    XlsIO lets you read/write the formula in a cell and the computed value. It also has its own formula evaluation engine that lets you edit some cell values and retrieve the computed formulas from other cells.
  • Easily import and export data
    Essential XlsIO provides several utility methods to work with common data sources. It only takes one line of code to import an Array, Data Table, Data View, Data Column, and Business Objects into a worksheet.
  • Template Marker
    Template markers are special placeholder values inserted in an Excel template that later gets replaced with actual data when processed dynamically using XlsIO. One possible use case is to let end users design their own reports and then dynamically merge with actual data. This functionality is very similar to the mail merge functionality available in Microsoft Word.
  • Charts
    Essential XlsIO has advanced support for creating and modifying Excel charts inside a workbook. Charts can be created as an embedded chart (chart is embedded inside a worksheet) or as a chart worksheet (chart is a separate worksheet). Several formatting options are available to customize the look and feel of such charts as well.
  • Conditional Formatting
    XlsIO lets you define the conditional formatting rules and also specify the formatting options for the cells when these conditions are met.
  • Data Validation
    Essential XlsIO allows you to add data validation rules to a cell. This is valuable when you want the data entered in the workbook to be accurate and consistent. You can restrict data entry to a certain range of dates, limit choices by using a list, or make sure that only positive whole numbers are entered.
  • Sorting
    It is possible to dynamically sort a given range of cells in a worksheet.
  • Encryption and Decryption
    By using Password Encryption in Essential XlsIO, you can secure the data in your reports and make it impossible for anyone to view the workbook without the password. There are also several other options available to restrict specific user actions like inserting, formatting, and deleting rows.
  • Workbook and Worksheet Protection
    Essential XlsIO lets you add Workbook Protection to protect a workbook's structure or windows. By protecting the structure, you can prevent the user from moving the workbooks around, inserting new ones, etc. By protecting the windows in the workbook, you can control the size of the workbook, etc. Essential XlsIO has support for adding Worksheet Protection. This prevents the end user from editing the contents of the worksheet while optionally letting the end users perform some operations on the worksheet like format cells, etc.
  • Document Properties
    Document Properties are named values that provide information about the document, such as the date and time at which the document was last saved, the last user to modify the document, and so on. The built-in document properties such as Application Name, Document Title, Category, Keywords, Company, etc. can be set for the documents using Essential XlsIO. It is also possible to set custom document properties as well.
  • Tables
    Tables let you better analyze tabular data with features like sorting, filtering, summary row, etc. Essential XlsIO provides API’s for reading and writing tables.
  • Named Ranges
    Named Ranges are a powerful feature in Excel, which makes it possible to assign a name to a group of cells. XlsIO has APIs for inserting new named ranges into workbooks, and also to read existing named ranges. Named Ranges are mainly used in formulas.
  • Pivot Table
    When there is a need to summarize large and complex reports, Excel allows you to summarize data through pivot tables. A comprehensive set of APIs are included to create and customize the look and feel and behavior of pivot tables within Excel. Bind the pivot table to data, define fields based on which you want to support pivoting, and even specify the default fields the pivot should load with.
  • Convert to CSV, PDF, Word and HTML
    It is also possible to export the Excel file to other common formats like CSV, PDF, Word and HTML.
  • Viewing and Editing with Spreadsheet Control
    Essential Spreadsheet allows you to import contents from an Excel file (.xls or .xlsx), edit, and save them to the Excel file. All common features you expect from Excel are supported including formula editing and automatic computation, conditional formatting, rich text formatting, etc.


Essential PDF

  • Powerful and comprehensive API
    All of the elements in a typical PDF file like the text, formatting, images and tables are accessible through a comprehensive set of API's. This makes it possible to easily create richly formatted PDF documents as well as modify existing ones. It is also possible to merge or split PDF documents.
  • Standards Compliant
    PDF documents generated by Essential PDF conform to the PDF/A-1b (formally ISO 19005-1 Level B) and PDF/X1a:2001 (ISO 15930-1) industry standards. These standards follows a set of protocols for electronic documents such that the document is reproduced exactly during future use. Between the two levels of compliance, Essential PDF supports PDF/A-1b, which ensures accurate reproduction of the appearance of the document. Essential PDF also supports PDF/X1a:2001 compliance, which is a standard that intends to reflect best practices in graphic arts file exchange, enabling users to create documents with high-quality print production output.
  • Blazing Fast Performance
    Essential PDF has been optimized for use on servers where speed and memory usage are critical. It can easily handle multiple requests for report generation in scenarios such as Web sites serving reports to hundreds of simultaneous users. The Silverlight version of the library is a pure Silverlight client-side library that off-loads all processing to the client machine, making it an infinitely scalable reporting solution.
  • No Server Deployment Fees
    There are no per-server licensing fees or royalties which makes Essential PDF very cost-effective.
  • Text formatting
    Essential PDF supports several different text formatting options. Character, word and line spacing are supported in addition to fonts and brush customizations. Essential PDF has the capability to render HTML styled text and Rich Text which helps in rendering formatted text in fewer lines of code. Middle Eastern languages such as Hebrew and Arabic are written predominantly from right-to-left. Essential PDF also supports this format of text. In addition, inbuilt lists support allows the user to create ordered and unordered list easily.
  • Images
    Essential PDF supports both vector and raster images. The supported vector images are EMF, EMF plus and EMF plus dual which when rendered in PDF document produces native graphics and searchable text. It supports various raster image formats such as JPEG, PNG, BMP, GIFF and TIFF. In addition, various image compression methods such as CCITTFAX and JBIG2 enables document creation with a minimal size.
  • Stunning tables
    Essential PDF provides API's for creating richly formatted tables that can span across multiple pages. Large amounts of data can be easily imported from an object array, dataset, datatable or an IEnumerable collection.
  • Headers and footers
    Essential PDF has support for drawing headers and footers in a PDF document. You can add dynamic fields such as author information, page count, current page numbers in the header and footer in addition to other text. These headers and footers can include text or graphics.
  • Create and fill forms
    Essential PDF has support for processing form fields. It is possible to programmatically add, move, rename, flatten and remove form fields from the Pdf documents. In addition to this, interactive JavaScript actions can also be added to form field elements. Form field-customizations include setting border style, font size, text color and marking them as read only.
  • Document conversions
    Essential PDF also provides a variety of document conversion options. Document formats such as word, excel, HTML, RTF and XPS can be easily converted to PDF without having to install Microsoft Office or adobe acrobat. In addition to this, Essential PDF also supports converting of PDF to image and extraction of text and image from a PDF document.
  • Secure and Sign Documents
    Essential PDF has the capability of encrypting a PDF document with 40-bit, 128-bit or 256-bit encryption. It is also possible to set user and owner passwords. Content modification permissions such as copying content, printing the file, completing form fields, degraded printing, annotation modification as well as PDF document assembly can also be restricted. It is also possible to sign the document using digital certificates. The graphical appearance of the signature can also be specified.
  • Merge and Split Existing Documents
    Essential PDF allows you to merge two or more PDF documents, append new pages to an existing PDF file, extract pages, insert pages at a particular location in an existing PDF file and split one PDF into multiple documents.
  • Attachments and Annotations
    Essential PDF supports adding attachments as well as extracting them from existing documents. Annotations such as line annotation, text markup annotation, sound annotation, 3d annotation etc. are supported with the ability to change their styles and attributes.
  • Optical Character Recognition
    Essential PDF uses the Google Tesseract OCR engine to perform OCR on a PDF file. Essential PDF eliminates the 32-bit restriction of Tesseract and allows you to work in either 32-bit or 64-bit platforms without any deployment changes. Using this feature unsearchable PDF documents can be converted to a searchable PDF document. It allows end users to search, select, and copy text from images found in the PDF document.
  • Page settings and User preferences
    Essential Pdf provides complete control of the page settings which includes modifying the page setting such as size, layout, orientation etc. In addition to that, the user can also control the way the document is presented on the screen when it is opened in the viewer. Some of the available viewer preferences are HideToolbar, FitWindow, PageMode, PageScaling etc.
  • Barcode
    Essential PDF supports the most commonly used 2D barcodes such as QR barcode, DataMatrix and a number of 1D barcodes such as Code39, codabar etc. The barcodes can be rendered in the PDF document and attributes such as color, Xdimesion etc. can be customized.
  • Import and Stamp
    Essential PDF provides built-in support for importing pages from existing PDF documents. You can also stamp the imported content with either text or an image.


Essential DocIO

  • Blazing Fast Performance
    Essential DocIO has been optimized for usage on servers where speed and memory usage are critical. It can easily handle multiple requests for report generation in scenarios such as Web sites serving reports to hundreds of simultaneous users. Essential DocIO is also highly optimized to generate Word files with a large amount of data. It is optimized for both low memory usage and speed. It works more than 100 times faster than MS Word automation and consumes much less memory compared to that of MS Word.
  • Compatible with Microsoft Word Versions 97 to 2013
    Essential DocIO can read and write files based on all popular Word file format variants including DOC and DOCX. You can even open a file in one format and save it back in another format.
  • No Server Deployment Fees
    DocIO is very cost-effective since there are no per-server licensing fees, distribution fees, or royalties involved.
  • Start Reports with Word and Finish with DocIO
    Let designers visually design reports using Microsoft Word, and then use Essential DocIO to populate it with dynamic data during run time, to generate an invoice for example. You can save the final report to a local file, stream, stream it to the client browser, or even export to other formats we support.
  • Consume Data Stored in Word documents
    When you read an existing Word document using DocIO, the entire document is parsed and available for manipulation through its object model. This makes consuming data stored in Word documents as simple as loading a document and accessing the data through DocIO' s intuitive object model.
  • Powerful and comprehensive API
    All of the elements in a typical Word file like text, formatting, images, and tables are accessible through DocIO' s comprehensive set of API's. This makes it possible to create richly formatted Word documents as well as extract any desired piece of information in an existing Word file.
  • Mail merge
    Essential DocIO lets you to add Microsoft Word reporting capabilities to your .NET applications within minutes. You can visually design your report with placeholders called "merge fields" in Microsoft Word documents. Essential DocIO can then be used to populate the merge fields in the document with data from data sources like ADO.NET data table, data set, business objects, etc. and save the final report to a local file, stream, or even stream to the client browser.
  • Form Filling
    Essential DocIO allows you to create Word documents with form fields and fill those form fields with data in your .NET applications. This feature is used in electronic form filling applications.
  • Clone And Merge
    Essential DocIO allows you to create a copy of an existing document using the clone functionality and combine multiple documents to a single document using merge functionality. You can also clone and merge a particular region of the document by iterating the document elements like sections, paragraphs, tables, etc. through the document object model.
  • Find and Replace
    Essential DocIO provides the capability to search for occurrences of text in a document and then replace them with alternative text or other document elements such as tables, paragraphs, images, etc.
  • Fields
    Essential DocIO lets you to add, edit, and delete fields, which are placeholders to preserve dynamic data in the document. Each field in a Word document has a field code and field result. It also possible to manipulate the field code and update the field resultant for most of the commonly used field types.
  • Table of Contents
    Essential DocIO provides support for adding and updating the table of contents field in a Word document, allowing the reader to easily navigate the contents of the document. This feature comes with customization options such as the ability to display page numbers, hyperlinks, etc.
  • Text Formatting
    Essential DocIO provides support for setting the font name, font size, font color, font style, text alignment, spacing, indents, etc. in Word documents. You can also insert special Symbols and Unicode text.
  • List
    Essential DocIO provides support for manipulating bulleted and numbered lists which can be used to outline, arrange, and emphasize text in the documents.
  • Styles
    Essential DocIO provides support for creating and applying both the built-in and custom styles to the contents in the Word document.
  • Images
    Essential DocIO provides support for inserting both scalar and vector images into the document. Bitmap, gif, jpeg, png and tiff are some of the common image types supported.
  • Tables
    Essential DocIO provides support for inserting, editing and deleting tables in a Word document. It is possible to create cell margins, paddings, cell spacing, cell merging, nested tables, images within table cells, etc.
  • Header footer
    Essential DocIO allows you to insert, edit and remove headers and footers containing elements like text, images, page numbers, date, etc.
  • Bookmarks
    Essential DocIO provides support for inserting, editing, and deleting bookmarks in Word documents. You can insert hidden bookmarks and nest bookmarks to multiple levels. Using the BookmarkNavigator API you can also navigate existing bookmarks and replace the contents with alternative text or document elements such as tables, paragraphs, images, etc.
  • Breaks
    Essential DocIO provides support for inserting and deleting breaks in Word documents. A column break moves the following content to the next column. A page break moves the following content to the next page.
  • Page settings
    Essential DocIO provides support for defining page settings for each section in a Word document. You can design a Word document with different page setting for part of the content, by splitting the contents to multiple sections.
  • Watermark
    Essential DocIO provides support for adding, modifying and removing watermark in Word documents. You can apply a picture or text watermark.
  • Endnotes and Footnotes
    Essential DocIO provides support for adding footnotes and endnotes in a Word document. A footnote is a note of text placed at the bottom of a page. It is normally flagged by a superscript number followed by the text being referenced. An endnote is a note or reference listed at the end of a section or document. Endnotes differ from footnotes in that they are collected and listed together at the end of a section or document.
  • Comments
    Essential DocIO provides support for inserting, editing, and removing the comments in a Word document.
  • Document Properties
    Essential DocIO supports to view and modify both the standard and custom document properties of a Microsoft Word document. It also provides support for creating and retrieving document variables in a Microsoft Word document. These document variables are invisible fields that are used to store additional information in Microsoft Word documents for future use.
  • Document protection
    Essential DocIO provides the capability to restrict a Word document from being editing. All users can view the contents of the document but editing can be restricted. There are protection types that allow you to only edit comments, form fields and revisions.
  • Encryption and Decryption
    Essential DocIO allows you to encrypt Word documents using a password, which restricts anonymous users from viewing or accessing the contents of the document. You can encrypt a document while saving the document, or decrypt with valid password on opening a previously encrypted document.
  • Streaming Files
    Essential DocIO allows you to read and write document to and from stream objects. This is useful when reading Word documents from databases or business objects.
  • RTF conversion
    Essential DocIO allows you to convert the Word document to Rich text format files and vice versa.
  • HTML conversion
    Essential DocIO allows you to convert Word document to HTML format files and vice versa. The Html files should be XHTML 2.0 or 1.1 compliant, in order to be processed properly by Essential DocIO.
  • Text conversion
    Essential DocIO allows you to convert Word document to text files and vice versa.
  • Render as Image
    Essential DocIO lets you to render the contents of a Word document page by page to an image.
  • Render as PDF
    Essential DocIO lets you to convert Word document to PDF. It is possible to start from a Word template and then dynamically insert data using DocIO and then convert to PDF.
  • Convert to EPUB
    Essential DocIO also provides the capability to convert Word document to EPub format.

Essential Presentation

  • Convert to PDF - Provides the capability to convert a PowerPoint presentation to PDF.
  • Render as Image - Render a complete PowerPoint presentation or a particular slide to image format. Users can print a PowerPoint presentation by rendering the presentation slides as images.
  • Charts - Provides advanced support for creating and manipulating charts in a PowerPoint presentation. Also, provides a rich set of formatting options to customize the appearance of charts.
  • Tables - Create and modify richly formatted tables. Supports built-in table styles, allows to merge cells and format the entire table and individual cells.
  • Clone and Merge - Merge multiple presentations to a single presentation. Also allows to clone a particular slide and merge it to an existing or new presentation.
  • SmartArt - Create and manipulate SmartArt diagrams. Users can add/remove nodes, edit text in nodes, and format an entire SmartArt diagram or individual node.
  • Security - Read and write encrypted PowerPoint presentations.
  • Bullets and Numbering - Add and manipulate single-level and multilevel lists similar to Microsoft PowerPoint.