Generate Thumbnail of the Worksheet

It can be useful to generate thumbnails from worksheets. A thumbnail is a small image that can be pasted into a Word document or a PowerPoint presentation to give a preview of what’s on the worksheet. It can be added to a webpage with a link to download the original document and has a host of other uses.

Aspose.Cells for .NET allows you to output worksheets to image files so making a thumbnail is easy. The sample code below shows you, how to output worksheets to image files.

// 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();

// Instantiate and open an Excel file
Workbook book = new Workbook(sourceDir + "sampleGenerateThumbnailOfWorksheet.xlsx");

// Define ImageOrPrintOptions
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();

// Specify the image format
imgOptions.ImageType = Drawing.ImageType.Jpeg;
            
// Set the vertical and horizontal resolution
imgOptions.VerticalResolution = 200;
imgOptions.HorizontalResolution = 200;
            
// One page per sheet is enabled
imgOptions.OnePagePerSheet = true;

// Get the first worksheet
Worksheet sheet = book.Worksheets[0];
            
// Render the sheet with respect to specified image/print options
SheetRender sr = new SheetRender(sheet, imgOptions);
            
// Render the image for the sheet
Bitmap bmp = sr.ToImage(0);
            
// Create a bitmap
Bitmap thumb = new Bitmap(600, 600);
            
// Get the graphics for the bitmap
System.Drawing.Graphics gr = System.Drawing.Graphics.FromImage(thumb);

if (bmp != null)
{
    // Draw the image
    gr.DrawImage(bmp, 0, 0, 600, 600);
}
            
// Save the thumbnail
thumb.Save(outputDir + "outputGenerateThumbnailOfWorksheet.bmp");