Unable to read undefined properties (reading 'getRangeByIndexes')

Like (0) Share

Report

Posted on 12 Sep 2024 06:11:39 by WG-12090600-0

Hello
My flow consists of converting a .csv file to an excel file .xlsx,
I use the script found at: https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/convert-csv
But when you try to convert the file, it doesn't work. It throws me the following error:
We couldn't run the script. Try again.
Runtime error: Line 40: Unable to read undefined properties (reading 'getRangeByIndexes')
clientRequestId: fbae89f9-4d72-422c-8871-d5cc00be533e

Do you know how I could solve it?
Thank you
Do you know how I could solve it?
Thank you

Categories:

General

All responses (1)

Answers (0)

Suggested answer

DL-18101455-0 2 on 18 Oct 2024 at 15:10:22

Like (1)

Report

Unable to read undefined properties (reading 'getRangeByIndexes')

Hello,

I got the same issue and I found out that the script applies on the sheet "Sheet1" (first line of the function : let sheet = workbook.getWorksheet("Sheet1");)

Check if your template file has one sheet with this name. As I use a French version of Excel, the default sheet is called "Feuil1". So I changed the value in the script to match and it worked.

Hope this will helps you.

Regards