DevExpress Document Server目前正式更名為DevExpress Office File API
DevExpress Office File API是一個專為C#, VB.NET 和 ASP.NET等開發人員提供的非可視化.NET庫。有了這個庫,不用安裝Microsoft Office,就可以完全自動處理Excel、Word等文檔。開發人員使用一個非常易于操作的API就可以生成XLS, XLSx, DOC, DOCx, RTF, CSV 和 Snap Report等企業級文件。
更多資源請查看【DevExpress v19.2更新說明文檔】【DevExpress控件專題】【】
點擊了解更多DevExpress 漢化資源信息
The DevExpress Document Server is a non-visual .NET Library, built and optimized for C#, VB.NET and ASP.NET developers alike. It allows you and your team to fully automate Excel and Word without using Microsoft Office automation. Generate XLS, XLSx, DOC, DOCx, RTF, CSV and Snap Report files using a straightforward API that's easy-to-use and ready for the enterprise.
自動化電子表格文檔
DevExpress Office File API是一個高性能,低內存占用的電子表格服務器,它有以下集成特點:
兼容Microsoft Excel(XLS,XLSx )
支持中等信任環境
支持導出和打印為PDF
內置公式計算工具
創建和修改工作表
支持創建、復制、重命名、移動和刪除工作表。
支持(取消)隱藏工作表。
查看和打印選項(使用文檔工作表文件專業編程)。
單元格操作和范圍
支持訪問工作表中的任意單元格
支持插入、復制、清除和刪除單元格。
支持合并與拆分單元格。
支持單元格添加超鏈接。
支持單元格添加注釋。
支持命名單元格。
支持格式刷單元格。
圖片
行和列
支持訪問工作表中的任何行或列
支持插入,復制和刪除行與列
支持(取消)隱藏行或列
支持合并和拆分行與列
數據管理
支持設置和修改單元格的數據類型
支持從不同數據源向單元格導入數據
單元格樣式和格式
默認樣式。
自定義樣式。
單元格字體設置(字體、大小、顏色、樣式等等)。
單元格背景設置(顏色和陰影)。
單元格內容對齊方式(垂直和水平對齊方式、縮進、文字環繞方式、文本縮放和旋轉)。
單元格邊框
支持數字格式顯示數值數據(數字、賬單、貨幣、日期、時間、百分比等等)
格式化的條件:創建,修改規則以格式化工作表單元格。
支持表格
支持插入、修改、復制和刪除表格。
使用默認表格樣式或自定義樣式格式化表格。
自動化Rich Edit文檔
DevExpress RichEdit 文檔服務器是根據一般文字處理要求和使用情況設計的一個文字處理引擎。相對于DevExpress RichEdit控件而言,它是非可視化的,同時由于擁有強大的API,它具有更多的功能,特點如下:
支持通過操作明細合并郵件
擴展的文本格式選項
字符格式:字符格式可通過設置字體、字體大小、字符樣式、粗體、斜體、下劃線、刪除線樣式、背景顏色、前景顏色來完成。
段落格式:段落格式選項包括對齊方式、縮進、可變段落和行距。
列表:支持項目符號、數字和混合列表。
使用樣式可以保存和應用文檔格式。樣式方便文檔格式的快速修改和格式選項的集中控制。編輯器支持基于樣式的段落和字符,也支持多種繼承樣式。樣式表兼容MS Word。
全面支持表格
支持插入行、列和單元格。
支持合并和拆分單元格,支持拆分表格。
支持水平和垂直對齊單元格
支持刪除行、列和單元格
支持浮動對象
文檔保護和終端用戶限制
密碼能防止對整個文 檔的編輯,并且選擇性的限制對文檔某些范圍的修改。
當開啟了文檔保護模式,驗證通過的用戶只能編輯權限允許的文檔特定范圍。可編輯范圍高亮顯示或用括號括起來。
DevExpress文檔保護模式是基于RTT1.91規范(只讀密碼保護和保護異常章節),因此與Microsoft® Word®文檔保護功能兼容。
Snap Document Automation
DevExpress快照報表服務器允許直接通過API在服務端創建和定制快照文檔。它雖然不提供可視化界面,但是你可以用代碼直接實現快照報表(Snap Report)的所有功能。
服務端快照報表文檔
支持重新生成和使用Snap API完全定制報表
支持保存和加載Snap報表
文本格式化、樣式、表格和列表
導出Snap報表文檔
圖表,條碼等等
條碼生成庫
通過內置支持多數行業標準條碼,DevExpress Document Server使你能在.NET應用程序中輕松生成條碼圖像。
支持的條碼類型
你可以為下面列出的條碼類型設置特定選項,也可以生成一個條碼圖像用于你的應用程序或嵌入到文檔中。
Codabar |
Intelligent Mail |
Code 11 (USD-8) |
Interleaved 2 of 5 |
Code 128 |
Matrix 2 of 5 |
Code 39 (USD-3) |
MSI/Plessey |
Code 39 Extended |
PDF417 |
Code 93 |
PostNet |
Code 93 Extended |
QR Code |
Data Matrix |
UPC Supplemental 2 |
EAN 8 |
UPC Supplemental 5 |
EAN 13 |
UPC-A |
EAN-128 (UCC) |
UPC-E0 |
GS1- Data Matrix |
UPC-E1 |
Industrial 2 of 5 |
|
ZIP壓縮技術
DevExpress Office File API包含一個.NET壓縮庫,由全托管代碼編寫,支持中等信任環境(流和內存陣列的壓縮/解壓縮操作)。
創建和讀取ZIP文件
.NET流和字節陣列
支持.NET流的壓縮和解壓縮
支持字節陣列的壓縮和解壓縮
密碼和加密
注釋,覆蓋等等
設置單個文件注釋
允許覆蓋單個文件
以編程方式過濾要處理的文件
進度跟蹤機制,允許取消存檔操作
全面的API讓你能控制所有的存檔項和存檔行為
對象模型設計,方便擴展
單位轉換
這個庫為你提供了System.Double數據類的一組擴展方法,使你能輕易完成不同計量單位之間的轉換,操作數值,也就是計量單位的物理取值。
支持的計量單位
面積
距離
能量
力
信息量
磁場強度
質量
功率
壓強
速度
溫度
時間
體積

Spreadsheet Document Automation
The DevExpress .NET Document Server ships with a high performance and low memory footprint Spreadsheet Server and includes the following integrated features:
Microsoft Excel compatibility (XLS, XLSx)
- Load, convert and save workbooks to XLS binary file format.
- Load, convert and save workbooks to XLSX, CSV and TXT file formats.
Medium Trust support
- Run your spreadsheet solutions in medium trust environments.
Print and export to PDF support
- Output your spreadsheets to PDF.
Built-in formula calculation engine
- Comprehensive range of supported functions for use in formulas:
- Financial, Statistical, Engineering, Logical, Text, Date&Time, Lookup&Reference, Math&Trig, Informational
- Calculation results match MS Excel
- Named formulas and defined names in formulas
- Cell references in formulas (A1, R1C1, 3D and structured references)
- Array formulas
- Shared formulas
- Constants and calculation operators in formulas
Create and modify Worksheets
- Create, copy, rename, move and delete worksheets
- Hide and unhide worksheets
- View and print options (specified programmatically in a document workbook file)
Manipulate Cells and Cell Ranges
- Access any cell or cell range in a worksheet
- Insert, copy, clear and delete cells
- Merge and unmerge Cells
- Add hyperlinks to cells
- Add comments to cells
- Named cells
- Format cells
Pictures
- Insert, move, change, transform and delete pictures incorporated into a worksheet
Rows and Columns
- Access any row or column in a worksheet
- Insert, copy and delete rows and columns
- Adjust row height and column width
- Hide and unhide rows and columns
- Group and ungroup rows and columns
Data Management
- Set and modify the data type of a cell
- Import data to cells from different data sources
Cell Styles and Formatting
- Built-in styles
- Custom styles
- Cell font settings (font name, size, color, style, etc.)
- Cell background (color and shading)
- Cell content alignment (vertical and horizontal alignment, indent, text wrapping, text shrinking and text rotation)
- Cell borders
- Number formats to display numeric data (number, accounting, currency, date, time, percentage, etc.)
- Conditional Formatting: Create and modify rules to format worksheet cells
Table support
- Insert, modify, copy and delete tables.
- Format tables using supported built-in table styles or custom styles.

Rich Edit Document Automation
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:
Mail merge with master-detail support
- The DevExpress Document Server offers comprehensive mail merge options for a variety of business requirements. With it, you can generate many unique document types, including form letters, mailing shots, mailing labels, and personalized business documents. It supports images, and offers enhanced configurability and processing through multiple mail merge specific events. For advanced use cases, you can implement and register your own URI stream provider to intercept custom field codes. In addition, The Document Server ships with Master-Detail mail merge support, allowing you to combine the utility of the Document Server and document variables to create custom reports (including catalogs, header/detail invoices or statements).
Extended text formatting options
- Character Formatting: Characters can be formatted using different settings for font, font size, character style - bold, italics, underlined, strike-through style and different colors for background and foreground.
- Paragraph Formatting: Formatting options for paragraphs include alignment, indentation, variable paragraph and line spacing.
- Lists: Supports bulleted, numbered and mixed lists.
- Document formatting can be stored and applied by using styles. Styles facilitate quick modification of a document's formatting and allow centralized control of formatting options. The editor supports both paragraph and character based styles, as well as multiple style inheritance. Stylesheets are compatible with MS Word.
Comprehensive table support
- Insert rows, columns and cells.
- Split and merge cells and split the table.
- Align cell content horizontally and vertically.
- Delete cells, columns and rows.
Floating objects
- The DevExpress Document Server supports floating objects (pictures and text boxes) within a document - including rotation of floating objects using its API.
Document protection and end-user restrictions
- Password protect an entire document against editing, and selectively restrict modifying the document in certain document ranges. When document protection is active, authenticated users can edit only the specific document ranges to which the permissions are assigned. Editable ranges can be highlighted and enclosed in brackets.
- The DevExpress document protection model is based on the RTF 1.9.1 specification (read-only password protection and protection exceptions sections) and is therefore compatible with the Microsoft® Word® document protection feature.

Snap Document Automation
The DevExpress Snap Report Server allows you to create and customize Snap documents on the server via its straightforward API. Though it does not offer a visual interface, you can use all the capabilities of Snap Reports directly from code.
Snap Report documents on the server
- Generate reports from scratch and fully customize them using the Snap API.
- Save and load Snap Report documents.
Text formatting, styles, tables and lists
- Use a rich set of text formatting features and create custom styles for document elements (characters, paragraphs, lists and tables).
Export Snap Report documents
- Export to PDF, Microsoft Word formats (DOCX, DOC and RTF) and other popular file formats (TXT, ODT, EPUB).
Charts, barcodes, and more...
- Full support for embedded charts, barcodes, hyperlinks and check boxes.
- Full support of all features provided by the DevExpress Rich Edit Document Automation.

Barcode Generation Library
With built-in support for numerous industry standard barcode types, the DevExpress Document Server allows you to easily generate barcode images within your .NET application.
Supported Barcode types
You can set specific options for each barcode type listed below and generate an image for use in your application or for insertion into a document.
Codabar |
Intelligent Mail |
Code 11 (USD-8) |
Interleaved 2 of 5 |
Code 128 |
Matrix 2 of 5 |
Code 39 (USD-3) |
MSI/Plessey |
Code 39 Extended |
PDF417 |
Code 93 |
PostNet |
Code 93 Extended |
QR Code |
Data Matrix |
UPC Supplemental 2 |
EAN 8 |
UPC Supplemental 5 |
EAN 13 |
UPC-A |
EAN-128 (UCC) |
UPC-E0 |
GS1- Data Matrix |
UPC-E1 |
Industrial 2 of 5 |
|

Zip Compression
The Devexpress Document Server 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).
Create and read zip files
- Create new zip files or update existing zip files on disk or in memory
- Zip or unzip to and from disks or memory
.NET stream and byte arrays
- Compress or decompress .NET stream
- Compress or decompress byte arrays
Passwords and encryption
- Zip password encryption with support for AES encryption of 128, 192, and 256 bits
- Supports different encryption passwords for each file
Comments, overwrites and more...
- Set individual file comments
- Allow file overwrite on a per file basis
- Programmatically filter files to process
- Progress tracking mechanism that allows cancelling archive operations
- Comprehensive API that enables you to control each archive item and all actions
- Object model designed for easy extensibility

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.
Supported units of measurement
- Area
- Distance
- Energy
- Force
- Information
- Magnetism
- Mass
- Power
- Pressure
- Speed
- Temperature
- Time
- Volume