URL of experiment: / Description of the problem: How to import excel file on Pavlovia? Xlrd funtion is out of questions since I can’t import python libraries. Here is the code that I use in Builder: import xlrd infile = "file_name.xlsx" workbook = xlrd.open_workbook(infile) sheet = workbook.sheet…

Thank you sal! I am still having trouble with this, although I followed the instructions. I get the following error: “Cannot read property ‘0’ of undefined”. So I guess nothing gets written in the list “stimData”. Here is the piece of code: testfile = 'additional_files/EIM_Sentence_List1.csv'; var…

Hi @pavle , where are you putting this piece of code? In the JS side or the python side? Can you take a screenshot or show what you have in both the PY and JS side of the code component?

I am not sure how this is supposed to work. I did make some progress, but it seems to be in vain. This is my test study made so that I can exercise importing and displaying data. As you can see, text_stim gets assigned value “Anja”, but nonetheless, the text that appears on the screen is “Hello Worl…

Okay, in the builder interface you should have a code component in builder that is defining the text stimuli kr and text_stim. It should have two panes, with python code on the left and javascript on the right. Make sure you have the code type set to “Both” so that you can edit them independently. …

I’m so sorry, I somehow missed this notification! I had this same problem at first. You probably already figured it out, but what you’re calling stimData is actually the file itself, but not the list of stimuli. After that bit of code where you define stimData, you need a line that actually grabs th…

XLRD on Pavlovia

Online experiments

sal November 17, 2020, 7:08pm 2

Check out this thread and another thread they cite in there.

Topic		Replies	Views
Replacing "import xlrd" to JS code - creating arrays from a csv Online experiments csv , importing , pavlovia	15	1718	February 3, 2021
Replacing importing functions in Python Online experiments	12	2005	June 6, 2020
Problem import excel file in pavlovia Coding pavlovia	1	802	June 8, 2021
How to store image file paths on Pavlovia Online experiments images , pavlovia	9	3613	November 10, 2019
Read from xlsx in javascript Online experiments	8	2925	May 17, 2020

XLRD on Pavlovia

Related topics