Spreadsheet如何转换Excel中的工作表为图片和PDF等多种文件格式

作者：控件中国网出处：控件中国网 2016-04-18 14:18:22 阅读：7

Spreadsheet是一款类似Excel的可视化编辑Excel文件的控件，包含在Essential Studio for Windows Forms界面套包控件产品里，开发人员可以利用Spreadsheet轻松转换Excel中的工作表为多种文件格式，下面就主要介绍转换工作表为图片、PDF和HTML文件，具体可以参考下面的代码：

1.转换Excel工作表为图片

IWorksheet sheet = Spreadsheet.Workbook.ActiveSheet;

sheet.UsedRangeIncludesFormatting = false;

int lastRow = sheet.UsedRange.LastRow + 1;

int lastColumn = sheet.UsedRange.LastColumn + 1;

System.Drawing.Image img = sheet.ConvertToImage(1, 1, lastRow, lastColumn, ImageType.Bitmap, null);

img.Save("Sample.png", ImageFormat.Png);

System.Diagnostics.Process.Start("Sample.png");

2.转换Excel工作表为PDF文件

ExcelToPdfConverter converter = new ExcelToPdfConverter(Spreadsheet.Workbook);

//Intialize the PdfDocument

PdfDocument pdfDoc = new PdfDocument();

//Intialize the ExcelToPdfConverter Settings

ExcelToPdfConverterSettings settings = new ExcelToPdfConverterSettings();

settings.LayoutOptions = LayoutOptions.NoScaling;

//Assign the PdfDocument to the templateDocument property of ExcelToPdfConverterSettings

settings.TemplateDocument = pdfDoc;

settings.DisplayGridLines = GridLinesDisplayStyle.Invisible;

//Convert Excel Document into PDF document

pdfDoc = converter.Convert(settings);

//Save the PDF file

pdfDoc.Save("Sample.pdf");

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

功能分类