彩票走势图

　　当你需要在应用程序或者网页中呈现工作薄图像时，你可能需要将图像插入到Word文档，PDF文件和Power Point演示中。一旦你将工作表渲染成图像，这样一来，你就可以轻松地将图像粘贴到你的应用程序中。Aspose.Cells组件便提供了将Excel中的工作表转换成图像的功能。

　　Aspose.Cells.Rendering.SheetRender API可以将一个工作表转换成你所指定属性的图像，例如，Imageformat类型，分页表等。Aspose.Cells中支持多种图像格式，所以你可以从bmp, .gif, .jpg, .jpeg, .tiff, .emf等格式中任选其一。

示例

　　我们使用一个简单的Excel文件。MS Excel中的预览如下图所示。你可以看见空白的区域围绕着数据。你可以在输出图像中删除数据周围的空白区域。

[C#]

//Instantiate a workbook

//Open the template file

Workbook book = new Workbook(@"e:\test\MyTestBook1.xls");

//Get the first worksheet

Worksheet sheet = book.Worksheets[0];

//Specify your print area if you want

//sheet.PageSetup.PrintArea = "A1:H8";

//To remove the white border around the image.

sheet.PageSetup.LeftMargin = 0;

sheet.PageSetup.RightMargin = 0;

sheet.PageSetup.BottomMargin = 0;

sheet.PageSetup.TopMargin = 0;

//Define ImageOrPrintOptions

ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();

imgOptions.ImageFormat = ImageFormat.Emf;

//Set only one page would be rendered for the image

imgOptions.OnePagePerSheet = true;

imgOptions.PrintingPage = PrintingPageType.IgnoreBlank;

//Create the SheetRender object based on the sheet with its

//ImageOrPrintOptions attributes

SheetRender sr = new SheetRender(sheet, imgOptions);

//Convert the image

sr.ToImage(0, "e:\\test\\img_MyTestBook1.emf");

[VB.NET]

'Instantiate a workbook

'Open the template file

Dim book As New Workbook("e:\test\MyTestBook1.xls")

'Get the first worksheet

Dim sheet As Worksheet = book.Worksheets(0)

'Specify your print area if you want

'sheet.PageSetup.PrintArea = "A1:H8";

'To remove the white border around the image.

sheet.PageSetup.LeftMargin = 0

sheet.PageSetup.RightMargin = 0

sheet.PageSetup.BottomMargin = 0

sheet.PageSetup.TopMargin = 0

'Define ImageOrPrintOptions

Dim imgOptions As New ImageOrPrintOptions()

imgOptions.ImageFormat = ImageFormat.Emf

'Set only one page would be rendered for the image

imgOptions.OnePagePerSheet = True

imgOptions.PrintingPage = PrintingPageType.IgnoreBlank

'Create the SheetRender object based on the sheet with its

'ImageOrPrintOptions attributes

Dim sr As New SheetRender(sheet, imgOptions)

'Convert the image

sr.ToImage(0, "e:\test\img_MyTestBook1.emf")

通过上面的代码，下面是以Windows图片和传真查看器方式查看所生成的图片：