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中文网站】
点击了解更多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 99% 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