Dear Discoursers, I have managed to upload my experiment to Pavlovia, however I am stuck now that I need to change my Python code to JS so that Pavlovia can support it . Although I have read through many other threads and although there seem to be some answers in there, I think I do not fully under…

There’s another option here that you might like to look at [image] Alternative to pandas for reading csv/excel files online Blog After a lot of sleuthing, I found something nifty that doesn’t use any extra packages. I haven’t yet ported everything online to test it, but I…

Is the key problem that you want to work with multiple sheets within the same Excel file and you couldn’t use multiple single sheet Excel or CSV files instead?

Hi wakecarter, Thank you for your reply. No, the key problem is that I need to call the excel files without using the xlrd import function, as I want to be able to run it on Pavlovia. Best regards, Snoek

I thought that you’d already seen my solution for this. I use a loop to add (append=push) rows into a two dimensional array.

Thank you for your reply. I’m not sure what solution exactly you are referring to? I do have a link to your crib cheat. The problem is that I cannot import Python functions and need a different way to load in my excel file. I am currently trying to implement this solution but I am having some trou…

You could have a look at how I do it in https://pavlovia.org/Wake/prospective-memory-ldt Since this comes up a lot I’ll add it to my template https://pavlovia.org/Wake/brookes-template-2020 over the weekend

Maybe I am understanding it wrong but I do not see you load in from excel in this example. Perhaps I am looking in the wrong place? I am looking in ‘pm_ldt.psyexp’. From my understanding I have to change my experiment within the Builder so I can refresh it in Pavlovia.

Perhaps my question before was too vague and with too much unnecessary information I want to know how I can replace import xlrd inbook = xlrd.open_workbook(infile) insheet = inbook.sheet_by_index(0) By something that will work in Pavlovia

I don’t know what inbook.sheet_by_index(0) does. Have a look at my load_targets and loadwords routines. They read items.csv (but items.xlsx should work too) into arrays for use in my trials loop

It is the way to load in excel sheets in a lot of the tutorials of PsychoPy builder. Using the package xlrd that is imported in the first line of code.

I think I will choose to manually insert all my stimuli.

Replacing importing functions in Python

Online experiments

wakecarter June 5, 2020, 3:38pm 12

There’s another option here that you might like to look at

Topic		Replies	Views
Replacing "import xlrd" to JS code - creating arrays from a csv Online experiments csv , importing , pavlovia	15	1718	February 3, 2021
Problem import excel file in pavlovia Coding pavlovia	1	802	June 8, 2021
Importing javascript libraries for use in an experiment on pavlovia Online experiments	4	773	February 26, 2021
XLRD on Pavlovia Online experiments importing , pavlovia	6	1316	November 26, 2020
Reading/Writing Excel Files (Pavlovia) Online experiments online , pavlovia	4	2179	March 4, 2022

Replacing importing functions in Python

Related topics