How to insert image FIT inside a cell ?

[TranBaVinhSon]

Thanks for the great package. I want to insert image inside a cell. Currently, I'm using fixed width and height, but have no idea how to make image size fit inside a cell. How can I do that with exceljs ? Thanks in advance !
I want to

        const tmpWorkBook = new ExcelJS.Workbook();
        tmpWorkBook.xlsx.readFile(filePath)
            .then(function() {
              const worksheet = tmpWorkBook.getWorksheet("Sheet1");
              var imageID = tmpWorkBook.addImage({
                filename: imagePath,
                extension: 'png',
              });
              console.log("imageID", imageID);
              const relCol = cell.columnNumber() - 1;
              const relNum = cell.rowNumber() - 1;
              
              worksheet.addImage(imageID, {
                tl: { col: relCol, row: relNum },
                ext: { width: 100, height: 50 } // currently I'm using fixed width and height.
              });
              tmpWorkBook.xlsx.writeFile(outputPath);
            });

[TranBaVinhSon]

I noticed that I can insert image fit inside a range but wonder how I can do that with cell?

worksheet.addImage(imageId2, 'B2:D6');

[Alanscut]

See the example of add image to a cell.

worksheet.addImage(imageId2, {
  tl: { col: 0, row: 0 },
  ext: { width: 500, height: 200 }
});

[Alanscut]

Thanks for opening this request.
Please re-open if you still have issues.
Best of luck.

[ibalaji777]

See the example of add image to a cell.

worksheet.addImage(imageId2, {
  tl: { col: 0, row: 0 },
  ext: { width: 500, height: 200 }
});

It doesn't fit cell

[Knight-H]

Not sure if you still need this, but what I did was using the same cellId fits inside the cell. I think this works because the same cell is used for the top left (tl) and the bottom right (br).

sheet.addImage(imageId, `${cellId}:${cellId}`)

Example:

sheet.addImage(imageId, `J13:J13`)

[elyohan14]

Not sure if you still need this, but what I did was using the same cellId fits inside the cell. I think this works because the same cell is used for the top left (tl) and the bottom right (br).

sheet.addImage(imageId, `${cellId}:${cellId}`)

Example:

sheet.addImage(imageId, `J13:J13`)

Great, that is what I need! Thank you

[yogithesymbian]

how to fit but have margin ? because i have border of the row and make it gone when use fit ?

Not sure if you still need this, but what I did was using the same cellId fits inside the cell. I think this works because the same cell is used for the top left (tl) and the bottom right (br).

sheet.addImage(imageId, `${cellId}:${cellId}`)

Example:

sheet.addImage(imageId, `J13:J13`)

Great, that is what I need! Thank you