Hi,
XLSX.zip (14.9 KB)
Workbook book = new Workbook("grid.xlsx");
System.out.println("Sheet Count: " + book.getWorksheets().getCount());
Worksheet sheet = book.getWorksheets().get(0);
sheet.getPageSetup().setPrintArea("A1:C3");
sheet.getPageSetup().setLeftMargin(0);
sheet.getPageSetup().setTopMargin(0);
sheet.getPageSetup().setRightMargin(0);
sheet.getPageSetup().setBottomMargin(0);
sheet.getPageSetup().setPrintHeadings(false);
sheet.getPageSetup().setHeader(1, "");
//sheet.getPageSetup().setPrintGridlines(true);
//Define ImageOrPrintOptions
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
//System.out.println(imgOptions.get);
imgOptions.setImageFormat(ImageFormat.getEmf());
imgOptions.setOnePagePerSheet(true);
imgOptions.setCellAutoFit(true);
SheetRender sr = new SheetRender(sheet, imgOptions);
sr.toImage(0, "grid.emf");
Thanks