DevExpress Document Server目前正式更名為DevExpress Office File API
DevExpress Office File API是一個(gè)專為C#, VB.NET 和 ASP.NET等開發(fā)人員提供的非可視化.NET庫。有了這個(gè)庫，不用安裝Microsoft Office，就可以*自動(dòng)處理Excel、Word等文檔。開發(fā)人員使用一個(gè)非常易于操作的API就可以生成XLS, XLSx, DOC, DOCx, RTF, CSV 和 Snap Report等企業(yè)級(jí)文件。
更多資源請(qǐng)查看【DevExpress v19.2更新說明文檔】【DevExpress控件專題】【DevExpress中文網(wǎng)站】
點(diǎn)擊了解更多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.
自動(dòng)化電子表格文檔
DevExpress Office File API是一個(gè)高性能，低內(nèi)存占用的電子表格服務(wù)器，它有以下集成特點(diǎn)：
兼容Microsoft Excel（XLS,XLSx ）
支持中等信任環(huán)境
支持導(dǎo)出和打印為PDF
內(nèi)置公式計(jì)算工具
創(chuàng)建和修改工作表
單元格操作和范圍
支持訪問工作表中的任意單元格
支持插入、復(fù)制、清除和刪除單元格。
支持合并與拆分單元格。
支持單元格添加超鏈接。
支持單元格添加注釋。
支持命名單元格。
支持格式刷單元格。
圖片
行和列
支持訪問工作表中的任何行或列
支持插入，復(fù)制和刪除行與列
支持（取消）隱藏行或列
支持合并和拆分行與列
數(shù)據(jù)管理
單元格樣式和格式
默認(rèn)樣式。
自定義樣式。
單元格字體設(shè)置（字體、大小、顏色、樣式等等）。
單元格背景設(shè)置（顏色和陰影）。
單元格內(nèi)容對(duì)齊方式（垂直和水平對(duì)齊方式、縮進(jìn)、文字環(huán)繞方式、文本縮放和旋轉(zhuǎn)）。
單元格邊框
支持?jǐn)?shù)字格式顯示數(shù)值數(shù)據(jù)（數(shù)字、賬單、貨幣、日期、時(shí)間、百分比等等）
格式化的條件：創(chuàng)建，修改規(guī)則以格式化工作表單元格。
支持表格
自動(dòng)化Rich Edit文檔
DevExpress RichEdit 文檔服務(wù)器是根據(jù)一般文字處理要求和使用情況設(shè)計(jì)的一個(gè)文字處理引擎。相對(duì)于DevExpress RichEdit控件而言，它是非可視化的，同時(shí)由于擁有強(qiáng)大的API，它具有更多的功能，特點(diǎn)如下：
支持通過操作明細(xì)合并郵件
擴(kuò)展的文本格式選項(xiàng)
字符格式：字符格式可通過設(shè)置字體、字體大小、字符樣式、粗體、斜體、下劃線、刪除線樣式、背景顏色、前景顏色來完成。
段落格式：段落格式選項(xiàng)包括對(duì)齊方式、縮進(jìn)、可變段落和行距。
列表：支持項(xiàng)目符號(hào)、數(shù)字和混合列表。
使用樣式可以保存和應(yīng)用文檔格式。樣式方便文檔格式的快速修改和格式選項(xiàng)的集中控制。編輯器支持基于樣式的段落和字符，也支持多種繼承樣式。樣式表兼容MS Word。
全面支持表格
支持插入行、列和單元格。
支持合并和拆分單元格，支持拆分表格。
支持水平和垂直對(duì)齊單元格
支持刪除行、列和單元格
支持浮動(dòng)對(duì)象
文檔保護(hù)和終端用戶限制
密碼能防止對(duì)整個(gè)文 檔的編輯，并且選擇性的限制對(duì)文檔某些范圍的修改。
當(dāng)開啟了文檔保護(hù)模式，驗(yàn)證通過的用戶只能編輯權(quán)限允許的文檔特定范圍?？删庉嫹秶吡溜@示或用括號(hào)括起來。
DevExpress文檔保護(hù)模式是基于RTT1.91規(guī)范（只讀密碼保護(hù)和保護(hù)異常章節(jié)），因此與Microsoft® Word®文檔保護(hù)功能兼容。
Snap Document Automation
DevExpress快照?qǐng)?bào)表服務(wù)器允許直接通過API在服務(wù)端創(chuàng)建和定制快照文檔。它雖然不提供可視化界面，但是你可以用代碼直接實(shí)現(xiàn)快照?qǐng)?bào)表(Snap Report)的所有功能。
服務(wù)端快照?qǐng)?bào)表文檔
文本格式化、樣式、表格和列表
導(dǎo)出Snap報(bào)表文檔
圖表，條碼等等
條碼生成庫
通過內(nèi)置支持多數(shù)行業(yè)標(biāo)準(zhǔn)條碼，DevExpress Document Server使你能在.NET應(yīng)用程序中輕松生成條碼圖像。
支持的條碼類型
你可以為下面列出的條碼類型設(shè)置特定選項(xiàng)，也可以生成一個(gè)條碼圖像用于你的應(yīng)用程序或嵌入到文檔中。
| 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壓縮技術(shù)
DevExpress Office File API包含一個(gè).NET壓縮庫，由全托管代碼編寫，支持中等信任環(huán)境（流和內(nèi)存陣列的壓縮/解壓縮操作）。
創(chuàng)建和讀取ZIP文件
.NET流和字節(jié)陣列
支持.NET流的壓縮和解壓縮
支持字節(jié)陣列的壓縮和解壓縮
密碼和加密
注釋，覆蓋等等
單位轉(zhuǎn)換
這個(gè)庫為你提供了System.Double數(shù)據(jù)類的一組擴(kuò)展方法，使你能輕易完成不同計(jì)量單位之間的轉(zhuǎn)換，操作數(shù)值，也就是計(jì)量單位的物理取值。
支持的計(jì)量單位
面積
距離
能量
力
信息量
磁場強(qiáng)度
質(zhì)量
功率
壓強(qiáng)
速度
溫度
時(shí)間
體積
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
免費(fèi)會(huì)員
具體成交價(jià)以合同協(xié)議為準(zhǔn)
