110,586
社区成员
发帖
与我相关
我的任务
分享
Workbook book = newWorkbook("d:\\Book1.xls");
//创建一个图表选项的对象
ImageOrPrintOptions imgOptions = newImageOrPrintOptions();
//设置图片类型
imgOptions.setImageFormat(ImageFormat.getPng());
//获取第一张工作表
Worksheet sheet = book.getWorksheets().get(0);
//创建一个纸张底色渲染对象
SheetRender sr = new SheetRender(sheet, imgOptions);
for (int j = 0; j < sr.getPageCount(); j )
{
//将工作表转为图片
sr.toImage(j, "d:\\files\\mysheetimg_" j ".png");
}
using Aspose.Cells;
using Aspose.Cells.Rendering;
public void ExcelToImg()
{
Workbook book = new Workbook(@"f:\book.xlsx");
Worksheet sheet = book.Worksheets[0];
sheet.PageSetup.LeftMargin = 0;
sheet.PageSetup.RightMargin = 0;
sheet.PageSetup.BottomMargin = 0;
sheet.PageSetup.TopMargin = 0;
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg;
imgOptions.OnePagePerSheet = true;
imgOptions.PrintingPage = PrintingPageType.IgnoreBlank;
SheetRender sr = new SheetRender(sheet, imgOptions);
sr.ToImage(0, "f:\\book.jpg");
}
Excel文件
生成图片