Export Worksheet or Chart into Image with Desired Width and Height

You can use Aspose.Cells to export your worksheet or chart into an image with the desired width and height. It provides ImageOrPrintOptions.SetDesiredSize() method to set the desired width and height of the exported image. The width and height are specified in the unit of pixels.

The following code exports the worksheet into an image with 400x400 size.

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

// Create workbook object from source file
Workbook workbook = new Workbook(sourceDir + "sampleWorksheetToImageDesiredSize.xlsx");

// Access first worksheet
Worksheet worksheet = workbook.Worksheets[0];

// Set image or print options we want one page per sheet. The image format is in png and desired dimensions are 400x400
Aspose.Cells.Rendering.ImageOrPrintOptions opts = new Aspose.Cells.Rendering.ImageOrPrintOptions();
opts.OnePagePerSheet = true;
opts.ImageType = Drawing.ImageType.Png;
opts.SetDesiredSize(400, 400, false);

// Render sheet into image
Aspose.Cells.Rendering.SheetRender sr = new Aspose.Cells.Rendering.SheetRender(worksheet, opts);
sr.ToImage(0, outputDir + "outputWorksheetToImageDesiredSize.png");