here the code
const img = new Image();
img.src = reportTemplate.logo ? reportTemplate.logo : defaultLogo;
const logoSize = 45;
const imgHeight = img.width * (logoSize / img.height);
const logo = workbook.addImage({
base64: img.src,
extension: 'png',
});
worksheet.addImage(logo, {
tl: { col: tableLength - 1, row: 0 },
ext: { width: imgHeight, height: logoSize},
editAs:'oneCell',
});
So, how to set image to place in cell as expected result?