Skip to content

Instantly share code, notes, and snippets.

@aspose-com-gists
Created March 10, 2021 17:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aspose-com-gists/634e9fb6f8515504317a7b71aa57b17a to your computer and use it in GitHub Desktop.
Save aspose-com-gists/634e9fb6f8515504317a7b71aa57b17a to your computer and use it in GitHub Desktop.
Excel to Image Conversion Java
// Load Excel file
Workbook workbook = new Workbook("workbook.xlsx");
// Create an object of ImageOrPrintOptions
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
// Set the image type
imgOptions.setImageType(ImageType.PNG);
// Set one page per sheet rendering
imgOptions.setOnePagePerSheet(true);
// Set gridline
imgOptions.setGridlineType(GridlineType.DOTTED);
// Get the first worksheet
Worksheet sheet = workbook.getWorksheets().get(0);
// Create a SheetRender object for the target sheet
SheetRender sr = new SheetRender(sheet, imgOptions);
for (int page = 0; page < sr.getPageCount(); page++) {
// Generate an image for the worksheet
sr.toImage(page, "image" + page + ".png");
}
// Load Excel file
Workbook workbook = new Workbook("workbook.xlsx");
// Create an object of ImageOrPrintOptions
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
// Set the output image type
imgOptions.setImageType(ImageType.PNG);
// Get the first worksheet
Worksheet sheet = workbook.getWorksheets().get(0);
// Create a SheetRender object for the target sheet
SheetRender sr = new SheetRender(sheet, imgOptions);
for (int page = 0; page < sr.getPageCount(); page++) {
// Generate an image for the worksheet
sr.toImage(page, "image" + page + ".png");
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment