Remove White Spaces from the Data before Rendering to Image

Sometimes, you need to present worksheet images in applications or web pages. For example, you might need to insert an images into a Word document, a PDF file, a PowerPoint presentation or some other document. Basically, you want to render a worksheet as an image so that it can be pasted into other applications. Aspose.Cells APIs allows you to convert Microsoft Excel worksheets to images.

The SheetRender class is capable of converting a worksheet to an image file with any specified attributes, for example, image format, paginated sheets, etc. Several image formats are supported, including BMP, GIF, JPG, TIFF, and EMF.

When you use the sheet-to-image feature, the output image has white/blank space, that is, a border, around it by default. You can remove this. Set the top, left, bottom, and right page setup margins for the source worksheet to 0 and specify ImageOrPrintOptions attributes accordingly.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(RemoveWhitespaceAroundData.class) + "TechnicalArticles/";

// Instantiate a workbook
// Open the template file
Workbook book = new Workbook(dataDir + "book1.xlsx");

// Get the first worksheet
Worksheet sheet = book.getWorksheets().get(0);

// Specify your print area if you want
// sheet.PageSetup.PrintArea = "A1:H8";

// To remove the white border around the image.
sheet.getPageSetup().setLeftMargin(0);
sheet.getPageSetup().setRightMargin(0);
sheet.getPageSetup().setTopMargin(0);
sheet.getPageSetup().setBottomMargin(0);

// Define ImageOrPrintOptions
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.setImageType(ImageType.EMF);
// Set only one page would be rendered for the image
imgOptions.setOnePagePerSheet(true);
imgOptions.setPrintingPage(PrintingPageType.IGNORE_BLANK);

// Create the SheetRender object based on the sheet with its
// ImageOrPrintOptions attributes
SheetRender render = new SheetRender(sheet, imgOptions);
// Convert the image
render.toImage(0, dataDir + "RWhitespaceAroundData_out.emf");