lg-experiment / scripts Goto Github PK

Hello,

I have this error when I use the script : "Line 46: Cannot read properties of undefined (reading ‘0’)"

Why ? any help please ?

I correctly set the key in excel. I have automate tab. I am working with office 365 online.

Thanks for help.

I have downloaded the XelPlus ASK AI in EXCEL.xlsx file, and copied the ts script into the Code Editor. I have replaced the Initial "button" with a new button linked to the Open AI in Excel script. I have established an API, and have copied it to cell B1 on the "API" tab. I have entered "Who won the 1985 World Series?" into cell B2 on the "Prompt" tab. When I run the code, I get the error "undefined is not an object (evaluating 'json.choices[0]'). I have added a console.log statement to write out json() following the "await response.json()" statement. The output appears to be blank.

Great video! I got the script to run without error. However, it doesn't answer the question I write into cell B2 on the 'Prompt' sheet. The first time I run it, it returns an answer of sorts, but it isn't an answer to the question I've asked. Subsequent running of the scripts returns random lines of code. I must have missed a step somewhere, but I can't figure it out. Any help?

I've tried to follow the instruction on the video but I found the following issue 👍

1. if tI use the ts code as is, I get an error ("type error"). I was able to fix the problem enclosing the provided sript inside this code

function main(workbook: ExcelScript.Workbook) {
// Your code here
}

2. after fixing above problem, I can input a question but I have no answer. Nor errors or warning in the output console.

API works, if I use a curl request with similar settings for model and prompt, I get my answer but in xls nothing happen.
I also added some extra logging lines but still no error in Output or Problems view.

Thanks for support.

Dear Leila,

I copy pasted your office script into code editor and this is the error message I got:
Line 46: Cannot read properties of undefined (reading '0') Can you help me?

This is the solution proposal from chat gpt but it didn't really help me:
"The error message "Cannot read properties of undefined (reading '0')" on line 45 typically means that you are trying to access an index of an array or an object property that does not exist. The error message suggests that the object or array you are trying to access is undefined.

To solve this issue, you need to make sure that the object or array you are accessing is defined and contains the property or index you are trying to access. Here are some steps you can take to solve the error:

Check if the object or array you are trying to access is defined. If it is undefined, make sure it is initialized properly.

Check if the property or index you are trying to access exists. If it does not exist, you may need to create it or modify your code to access a different property or index.

Check if the object or array you are trying to access is being modified or deleted before the error occurs. If it is, you may need to modify your code to prevent these actions or ensure they happen in the correct order.

Use console.log statements to log out the values of the variables involved in the error. This can help you pinpoint where the error is occurring and what values are causing the issue.

By following these steps, you should be able to solve the "Cannot read properties of undefined (reading '0')" error on line 45."

hi

Windows 10, office 365. I pasted in the .ts and put in the apiKey. I can run it, no compile errors, but it never terminates.
Pity there is no way to single step I Officescript code.
I put in a console.log but nothing happened.

I will look into my AV software and Trusted Sources to see if something is blocking access on my Win11Pro machine. I am attaching a screenshot. I renamed the file after I received the error a few times, which is why the name is a little different in the screenshot.