Excel sheet copy as picture script

Like (0) Share

Report

Posted on 24 Jan 2023 14:14:57 by surajjannu

Hello Everyone,

In excel sheet we have a functionality of "Copy as picture" on selected cells.
I wanted integrate the same feature in automation by using some scripts.
I have an excel which has both text data and graphs kept on sheet1.
I tried below script below which will only get the text data and convert it to image. [The actual operation output from Microsoft excel application is providing a result image which contains both text and graphs].

function main(workbook: ExcelScript.Workbook) {
 var apdexWorkSheet = workbook.getWorksheet("sheet1");
 apdexWorkSheet.setVisibility(ExcelScript.SheetVisibility.visible);
 var tableImage = apdexWorkSheet.getRange("A1:I81").getImage();
 var imageData = 'data&colon;image/png;base64,${tableImage}';
 return imageData;
}

could you please help me help me to automate it with right script.

Thanks and regards,
Suraj Jannu