About DevExpress Office File API

Read and write Excel and Word files, create Snap Reports, create and edit PDF documents, generate barcodes and compressed archives.

DevExpress Office File API is a non-visual .NET library that allows you to fully automate Excel and Word without using Microsoft Office automation. You can generate XLS, XLSx, DOC, DOCx, RTF, CSV, PDF and Snap Report files using a straightforward API that's easy-to-use and ready for the enterprise.

Spreadsheet Document Automation
Read/Write Microsoft Excel Documents
The DevExpress Office File API ships with a high performance and low memory footprint Spreadsheet Server and includes the following integrated features:

  • Microsoft Excel compatibility (XLS, XLSX)
  • Medium Trust support
  • Create, edit, print and export to PDF documents
  • Built-in formula calculation engine
  • Create and modify Worksheets
  • Manipulate Cells and Cell Ranges
  • Pictures
  • Charts
  • Rows and Columns
  • Data Management
  • Cell Styles and Formatting
  • Table support
  • Pivot Tables    

XL Export Library
High-Performance Excel Document Write-Only Library
In contrast to the multi-purpose spreadsheet document generation library - which can load and edit documents and thus needs to create and maintain an in-memory model - the XL Export API is designed for the singular task of generating Excel files by writing them directly to stream. It's blazing fast and optimized for the output of extremely large files.

  • Supported Formats (XLSX, XLS, CSV)
  • Medium Trust support
  • Document Generation
  • Cell Formatting
  • Page View / Page Setup
  • Sparklines

Rich Edit Document Automation    
Read/Write Microsoft Word Documents
The DevExpress RichEdit Document Server is a word processing engine designed to fully automate common word processing requirements and use-case scenarios. It is the non-visual equivalent of the DevExpress RichEdit Control, with complete functionality available via its powerful API. Features include:

  • Supported Formats (DOC, DOCX, RTF, ODT, EPUB, MHT, HTML)
  • Extended text formatting options
  • Comprehensive table support
  • Floating objects
  • Document protection and end-user restrictions
  • Document fields
  • Layout API
  • Mail merge with master-detail support
  • Spell Checking
  • Auto Correction

Snap Document Automation    
Generate DevExpress Snap Report Documents
The DevExpress Snap Report Server allows you to create and customize documents generated in WYSIWYG Report Writer (Snap) via its straightforward API. Though it does not offer a visual interface, you can use all the capabilities of Snap Reports directly from code.

  • Generate and modify reports on the server
  • Apply text formatting and styles
  • Create tables and lists
  • Export Snap Report documents
  • Embed charts, barcodes, and more.

PDF Document Processor    
Read, Write, Print and Export PDF Documents
The DevExpress Office File API ships with a high performance and low memory footprint PDF Document Processor and includes the following integrated features:

  • Document Creation API
  • Form Filling
  • Merging or Splitting PDF Documents
  • Page Manipulation
  • Password Protection
  • Signing a Document
  • Content Extraction
  • Text Search
  • Print and Export

And More    

  • Barcode Generation Library - With built-in support for over 20 industry standard barcode types, the DevExpress Document Server allows you to easily generate barcode images within your .NET application.
  • Zip Compression - The DevExpress Office File API includes a .NET Compression Library that's written with 100% managed code and available in Medium-Trust environments (stream and memory array compression/decompression operations).
  • Unit Conversion - This library provides you with a set of extension methods for the System.Double data type. It enables you to easily perform conversion between different units of measurement and to operate with quantity values, i.e. physical values expressed in units of measurement.