Convert Worksheet to Image - Remove whitespace around data

Sometimes, you need to present worksheet images in applications or web pages. For example, you might need to insert 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 allows you to convert Microsoft Excel worksheets to images.

Remove Whitespace around Data

The Aspose.Cells.Rendering.SheetRender API converts 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 whitespace, that is, a border, around it by default. You can remove this by setting the top, bottom, left and right page setup margins for the source worksheet to 0 and specify Aspose.Cells.Rendering.ImageOrPrintOptions attributes accordingly.

The following code snippet removes the whitespace around the data in the output image.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
//Source directory
string sourceDir = RunExamples.Get_SourceDirectory();

//Output directory
string outputDir = RunExamples.Get_OutputDirectory();

// Open the template file
Workbook book = new Workbook(sourceDir + "Book1.xlsx");

// Get the first worksheet
Worksheet sheet = book.Worksheets[0];
LoadOptions options = new LoadOptions();
options.LoadFilter = new LoadFilter(LoadDataFilterOptions.All);
// Specify your print area if you want
// Sheet.PageSetup.PrintArea = "A1:H8";

// To remove the white border around the image.
sheet.PageSetup.LeftMargin = 0;
sheet.PageSetup.RightMargin = 0;
sheet.PageSetup.BottomMargin = 0;
sheet.PageSetup.TopMargin = 0;

// Define ImageOrPrintOptions
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
imgOptions.ImageType = Drawing.ImageType.Emf;

// Set only one page would be rendered for the image
imgOptions.OnePagePerSheet = true;
imgOptions.PrintingPage = PrintingPageType.IgnoreBlank;

// Create the SheetRender object based on the sheet with its
// ImageOrPrintOptions attributes
SheetRender sr = new SheetRender(sheet, imgOptions);
            
// Convert the image
sr.ToImage(0, outputDir + "outputRemoveWhitespaceAroundData.emf");