usmanazizgroupdocs
6/21/2016 - 7:57 PM

renderExcelAsImageWithHiddenSheets2.java

// For complete examples and data files, please go to https://github.com/groupdocs-viewer/GroupDocs.Viewer-for-Java
try {
	// Setup GroupDocs.Viewer config
	ViewerConfig config = Utilities.getConfiguration();

	// Create image or html handler
	ViewerImageHandler imageHandler = new ViewerImageHandler(config);
	String guid = fileName;
	 
	// Set image options to show grid lines
	ImageOptions options = new ImageOptions();
	options.getCellsOptions().setShowHiddenSheets(true);
	 
	DocumentInfoContainer container = imageHandler.getDocumentInfo(new DocumentInfoOptions(guid));
	 
	for (PageData page : container.getPages())
	 System.out.println(String.format("Page number: %d, Page Name: %s, IsVisible: %s", page.getNumber(), page.getName(), page.isVisible()));
	 
	List<PageImage> pages = imageHandler.getPages(guid, options);
	 
	for (PageImage page : pages) {
	 System.out.println("Page number: " + page.getPageNumber());
	 
	 // Page image stream
	 final InputStream imageContent = page.getStream();
	}
} catch (Exception exp) {
	System.out.println("Exception: " + exp.getMessage());
	exp.printStackTrace();
}