Office File API

  • 3 minutes to read

The DevExpress Office File API library allows you to create, load, edit, export, and print rich text documents, spreadsheets, and PDF files without any UI components involved. You can also generate barcodes, compress data, and convert different measurement units.

The Office File API supports the following platforms and operating systems:

  • Windows, Linux, macOS
  • Azure, Docker
  • .NET Framework 4.5.2+ / .NET 5
  • .NET Standard 2.0+ / .NET Core 2.1+ / NET Core 3.0+

The following topics contain information about necessary libraries and NuGet packages: Install NuGet Packages and Redistribution and Deployment (.NET Framework).

Review available demo applications to explore the Office File API features.

Included Components

Spreadsheet Document API

image

The DevExpress Spreadsheet Document API allows you to import, export, modify, and print workbooks in code. You can edit spreadsheet content, analyze and visualize data, create formulas, specify print settings, and protect documents with passwords and digital signatures.

Word Processing Document API

image

The DevExpress Word Processing Document API allows you to use all the word processing features in code. You can automate such common tasks as file conversion, character and paragraph formatting, document protection, printing, and mail merge.

PDF Document API

image

The DevExpress PDF Document API allows you to create, edit, merge, split, password protect, and digitally sign PDF files in code.

Excel Export Library

The DevExpress Excel Export API is a write-only spreadsheet library that allows you to export data to XLSX, XLS, and CSV files with minimal memory footprint.

Unit Conversion API

The DevExpress Unit Conversion API allows you to easily convert values between different measurement units (weight, distance, power, and so on).

Zip Compression and Archive API

The DevExpress Zip Compression and Archive API allows you to generate and edit zip archives, filter files before compression, and specify a password for the entire archive or individual files.

Barcode Generation API

The DevExpress Barcode Generation API allows you to generate different barcode types and specify barcode options (orientation, color, quality, and so on).

Snap Report API

The DevExpress Snap Report API offers the complete reporting functionality combined with the basic Word Processing Document API features. You can generate and edit mail merge and tabular reports, add visual data (sparklines, barcodes, and charts), and export resulting documents to popular format (DOCX, RTF, PDF, HTML, and so on).

This product does not support .NET Core/.NET 5.

.NET Core Limitations

The following feature is not available in the Office File API for .NET Core/.NET 5:

  • Print documents, workbooks, and PDF files (Linux and macOS).