在VS中添加DevExpress Document Server：[1]

1、打开Visual Studio，然后通过选择醒薪FILE-New-Project…，创建一个新的Windows Forms Application项目。

2、添加以下库为引用：DevExpress.Data.v13.1.dll、 DevExpress.Docs.v13.1.dll、

DevExpress.Office.v13.1.Core.dll、 DevExpress.Spreadsheet.v13.1.Core.dll和DevExpress.Utils.v13.1.dll。

3、其实集成步骤在上一部已经完成了，接霸耻下来用个小例子为搁牺轿大家展示下简单的功能。使用以下代码：

using DevExpress.Spreadsheet;

// ...

// Create an instance of a workbook.

Workbook workbook = new DevExpress.Spreadsheet.Workbook();

// Access the first worksheet in the workbook.

Worksheet worksheet = workbook.Worksheets[0];

// Access the "A1" cell in the worksheet.

Cell cell = worksheet.Cells["A1"];

// Specify the "A1" cell value.

cell.Value = 1;

// Fill cells with sequential numbers by using shared formulas.

worksheet.Range["A2:A10"].Formula = "=SUM(A1+1)";

worksheet.Range["B1:B10"].Formula = "=A1+2";

// Multiply values contained in the cell range A1 through A10

// by the corresponding values contained in B1 through B10,

// and display the results in cells C1 through C10.

worksheet.Cells["C1"].CreateArrayFormula("=A1:A10*B1:B10", 10, 1);

// Save the document file under the specified name.

workbook.SaveDocument("TestDoc.xlsx", DocumentFormat.OpenXml);

// Display gridlines in PDF.

worksheet.PrintOptions.PrintGridlines = true;

// Export the document to PDF.

workbook.ExportToPdf("TestDoc.pdf");

// Open the PDF document using the default viewer..

System.Diagnostics.Process.Start("TestDoc.pdf");

// Open the XLSX document using the default application.

System.Diagnostics.Process.Start("TestDoc.xlsx");

4、运行项目，下图就是执行了以上代码后生成的文件。