Office File API
- 3 minutes to read
Office File API allows you to process rich-text documents, spreadsheets, reports, draw barcodes, create or edit PDF documents, compress data and convert different units without any UI components, such as Rich Edit Control or Spreadsheet, involved. You can use the assemblies in applications that target a variety of platforms (ASP.NET, ASP.NET MVC, WinForms and WPF).
To explore the Office File API functionality, review the demo applications available to you with the product.
Office File API for .NET Core allows you to process rich text documents, spreadsheets, and PDF documents in code. The library supports .NET Standard 2.0+ / .NET Core 2.1+. You can use it to develop desktop, web, or console applications that run on different platforms, including Windows, Mac, and Linux.
To explore the Office File API functionality, review the demo applications available to you with the product. See Install NuGet Packages topic for detailed installation information.
Included Components
Spreadsheet Document API | |
| The Spreadsheet Document API allows you to create or modify spreadsheets in code. The library supports the same feature set as DevExpress Spreadsheet UI Controls, so you can edit and analyze data, use formulas with varying difficulty levels, specify print settings and protect the document from editing. This component supports different for import and export. You can open and save documents in a variety of supported file formats. Learn more: |
Word Processing Document API | |
| Word Processing Document API allows you to use all the word processing features in code. The powerful API can automate such common tasks as format conversion, character and paragraph formatting, table operations, page layout adjustment and mail merge. Learn more: |
PDF Document API | |
| PDF Document API allows you to merge, split, edit, create, password protect, and digitally sign PDF files in code. Learn more: |
Excel Export Library | |
| Excel Export API is a write-only spreadsheet library that allows you to create documents (export data to XLSX, XLS, and CSV spreadsheets) with minimal memory footprint. Learn more: |
Unit Conversion API | |
| Unit Conversion API allows you to easily convert values between different measurement units (weight, distance, power, and so on). Learn more: |
Snap Report API | |
| This library provides the complete reporting engine functionality combined with the basic Word Processing Document API features. You can generate a tabular or mail merge report, edit it, add visual data (sparklines, bar codes or charts) and export the resulting document to any popular format (DOC, HTML, RTF, etc.). Learn more: |
Zip Compression and Archive API | |
| The Zip Compression and Archive API is a component with a zip archiver functionality. Generate new archives, edit existing zip files, filter files before compression, and set a password for the whole archive or for each file individually. Learn more: |
Barcode Generation API | |
| The Barcode Generation API allows you to generate different types of barcodes used in applications or documents. Each barcode type provides its own options (orientation, color, quantity, etc.). Learn more: |
Limitations
The following features are not available:
Print PDF files or export PDF content to an image (Linux and Mac OS).
All PDF features related to the DirectX rendering (all operating systems):
- Stroke and Clip rendering modes
- Advanced transparency and blend modes
- CJK fonts support
Export PDF files with embedded fonts (Linux and Mac OS).