Problem Debugging Microsoft Office Script in Excel

Here is the code (it wasn't letting me post it with the main message):

async function main(workbook: ExcelScript.Workbook) {

// Fetch the image from a URL.



const sheet = workbook.getWorksheet("Form1");



const response = await fetch(sheet.getRange("I7"));



// Store the response as an ArrayBuffer, since it is a raw image file.

const data = await response.arrayBuffer();



// Convert the image data into a base64-encoded string.

const image = convertToBase64(data);



// Add the image to a worksheet.

workbook.getWorksheet("WebSheet").addImage(image);

}



/**

* Converts an ArrayBuffer containing a .png image into a base64-encoded string.

*/

function convertToBase64(input: ArrayBuffer) {

const uInt8Array = new Uint8Array(input);

const count = uInt8Array.length;



// Allocate the necessary space up front.

const charCodeArray = new Array(count) as string[];



// Convert every entry in the array to a character.

for (let i = count; i >= 0; i--) {

charCodeArray[i] = String.fromCharCode(uInt8Array[i]);

}



// Convert the characters to base64.

const base64 = btoa(charCodeArray.join(''));

return base64;

}

Also, I just read the agreement terms of this website. I had posted an identical question on MrExcel but no one answered.

I hope to have better luck here...

Thanks for the suggestion mogul. Unfortunately, the same problem exists after changing the name of the variable "response" to "resp".

I looked at your code and did a little research.

const response = await fetch(sheet.getRange("I7"));

should be

const response = await fetch(sheet.getRange('I7').getText());


I would break it up. Log url to make sure it is right.

const url = sheet.getRange('I7').getText();
console.log(url);
const response = await fetch(url);

That worked!

Thank you very much mogul for your help.

Welcome. Might want to mark it as solved.