[DevExpress]透過 .NET Document Automation 來將 Excel 檔轉成 PDF

2015-05-12

1562
0
.NET
2015-05-13

快速透過 DevExpress 的 Spreadsheet 來將 Excel 轉成 PDF 檔!

環境:Visual Studio 2013, DevExpress v14.2

之前使用 Rich Edit Document Server ，來將 Word 轉成 PDF。

如果要將 Excel 轉出 PDF，則可以透過 Spreadsheet Document Server 來達到哦!

首先請加入以下的參考，

DevExpress.Data.V14.2
DevExpress.Docs.V14.2
DevExpress.Docs.V14.2
DevExpress.Office.V14.2.Core
DevExpress.SpreadSheet.V14.2.Core
DevExpress.Utils.V14.2

再來就是準備一個Excel檔(c:\t2.xls)來轉成PDF檔，如下，

//using DevExpress.Spreadsheet;
// Create an instance of a workbook.
Workbook workbook = new DevExpress.Spreadsheet.Workbook();
workbook.LoadDocument(@"c:\t2.xls");
workbook.ExportToPdf(@"c:\t2.pdf" );

如果要部署DLL的話，請參考「Redistributable Assemblies (Document Server)」。

DevExpress.Charts.v14.2.Core.dll
DevExpress.Data.v14.2.dll
DevExpress.DataAccess.v14.2.dll
DevExpress.Docs.v14.2.dll
DevExpress.Office.v14.2.Core.dll
DevExpress.Pdf.v14.2.Core.dll
DevExpress.Pdf.v14.2.Drawing.dll
DevExpress.Printing.v14.2.Core.dll
DevExpress.RichEdit.v14.2.Core.dll
DevExpress.Snap.v14.2.Core.dll
DevExpress.Spreadsheet.v14.2.Core.dll
DevExpress.Utils.v14.2.dll

如果DLL不全的話，產出的PDF會是 1 KB，內容是一個白色的方塊哦!

感謝同事 Daniel 的協同測試。