RuntimeError: Error opening 'DTConditions.xlsx': File contains data in an unknown format

Builder
1

If this template helps then use it. If not then just delete and start from scratch.

OS (e.g. Win10): Win10
PsychoPy version (e.g. 1.84.x): 2023.2.3
Standard Standalone? (y/n) If not then what?: y
What are you trying to achieve?: Use excel to randomise presentation of 2 stimuli and start time of one stimuli

What did you try to make it work?:
Have worked through all the advice on other forum threads, changed audio files to 16, 44100 Hz, changed variable names to remove special characters
What specifically went wrong when you tried that?:
Still getting the same error message RuntimeError: Error opening ‘DTConditions.xlsx’: File contains data in an unknown format.

I feel like there’s something really obvious that I’m missing, but I just can’t find what’s wrong. Have attached the file - all of the audio files are in the same folder as the builder and excel file.

And while I’m asking is this the best way to randomise the start time of the second stimulus or should I code it? The first stimulus starts on 0. It’s a PRP test.
DTConditions.xlsx (15.2 KB)

2

Your spreadsheet contains six conditions but only four have wav files (and only two have values for RecColour)

image

You can put a variable in as the start time $Start .

3

Apologies I probably didn’t explain properly. I have two stimuli, one a polygon that needs to randomise between blue and yellow and a sound stimuli that needs to randomise in pitch and start time.

I have just tried making each column an equal length with 4 items but I’m still getting the same error.