一 Java中excel转换为jpg/png图片
packagecom.thinkgem.jeesite.modules.task.util;importcom.aspose.cells.ImageFormat;importcom.aspose.cells.ImageOrPrintOptions;importcom.aspose.cells.SheetRender;importcom.aspose.cells.Workbook;importcom.aspose.cells.Worksheet;importjava.io.File;public classConvertToImage {public static voidConvertToImage (){
String dataDir= getDataDir(ConvertToImage.class);//Create a new Workbook object//Open a template excel file
Workbook book = null;try{//book = new Workbook(dataDir + "2018各项目情况.xlsx");
book = new Workbook("D:\\20180702_Game10002_DataReport.xls");//Get the first worksheet//Worksheet sheet = book.getWorksheets().get(0);
Worksheet sheet = book.getWorksheets().get(0);
sheet.getPageSetup().setLeftMargin(-20);
sheet.getPageSetup().setRightMargin(0);
sheet.getPageSetup().setBottomMargin(0);
sheet.getPageSetup().setTopMargin(0);//Define ImageOrPrintOptions
ImageOrPrintOptions imgOptions = newImageOrPrintOptions();//Specify the image format
imgOptions.setImageFormat(ImageFormat.getJpeg());
imgOptions.setCellAutoFit(true);
imgOptions.setOnePagePerSheet(true);//imgOptions.setDesiredSize(1000,800);//Render th