Export Worksheet or Chart into Image with Desired Width and Height via Node.js

You can use Aspose.Cells for Node.js via C++ to export your worksheet or chart as an image with the desired width and height. It provides ImageOrPrintOptions.setDesiredSize(number, number, boolean) method to set the desired width and height of the exported image. The width and height are specified in units of pixels.

The following code exports the worksheet into an image with a size of 400 × 400 pixels.

const path = require("path");
const AsposeCells = require("aspose.cells.node");

// Source directory
const sourceDir = path.join(__dirname, "data");

// Output directory
const outputDir = path.join(__dirname, "output");

// Create workbook object from source file
const filePath = path.join(sourceDir, "sampleWorksheetToImageDesiredSize.xlsx");
const workbook = new AsposeCells.Workbook(filePath);

// Access first worksheet
const worksheet = workbook.getWorksheets().get(0);

// Set image or print options: we want one page per sheet. The image format is PNG and the desired dimensions are 400x400
const opts = new AsposeCells.ImageOrPrintOptions();
opts.setOnePagePerSheet(true);
opts.setImageType(AsposeCells.ImageType.Png);
opts.setDesiredSize(400, 400, false);

// Render sheet into image
const sr = new AsposeCells.SheetRender(worksheet, opts);
sr.toImage(0, path.join(outputDir, "outputWorksheetToImageDesiredSize.png"));