Row selection does not work

Builder
1

Hi all,

I want the loop to only select specific number of rows but it’s not working. When I put in the rows number in the trial window (see screenshot below) I get the following error message. Can anyone please help?

Thanks in advance!

Error message:

Traceback (most recent call last):
File “C:\Users\h-mumtaz\AppData\Local\Programs\PsychoPy\lib\site-packages\psychopy\app\builder\dialogs_init_.py”, line 1853, in onOK
self.updateSummary()
File “C:\Users\h-mumtaz\AppData\Local\Programs\PsychoPy\lib\site-packages\psychopy\app\builder\dialogs_init_.py”, line 1742, in updateSummary
_c, _n = data.importConditions(self.conditionsFileAbs.strip(),
File “C:\Users\h-mumtaz\AppData\Local\Programs\PsychoPy\lib\site-packages\psychopy\data\utils.py”, line 384, in importConditions
wb = load_workbook(filename=fileName, data_only=True)
File “C:\Users\h-mumtaz\AppData\Local\Programs\PsychoPy\lib\site-packages\openpyxl\reader\excel.py”, line 315, in load_workbook
reader = ExcelReader(filename, read_only, keep_vba,
File “C:\Users\h-mumtaz\AppData\Local\Programs\PsychoPy\lib\site-packages\openpyxl\reader\excel.py”, line 124, in init
self.archive = _validate_archive(fn)
File “C:\Users\h-mumtaz\AppData\Local\Programs\PsychoPy\lib\site-packages\openpyxl\reader\excel.py”, line 96, in _validate_archive
archive = ZipFile(filename, ‘r’)
File “C:\Users\h-mumtaz\AppData\Local\Programs\PsychoPy\lib\zipfile.py”, line 1251, in init
self.fp = io.open(file, filemode)
PermissionError: [Errno 13] Permission denied: ‘C:\Users\h-mumtaz\OneDrive - UWE Bristol\Picture style comparison study\Experiment\Main_Experiment\object_words.xlsx’

image

2

Also, it seems that psychopy is reading the conditions file wrongly as well. I only have 32 conditions but it shows 91. I have checked my spreadsheet many times but can’t figure out what seems to be the issue.

3

Does it work if you leave selected rows blank?

Try deleting the 60 blank rows below your conditions in your Excel file

4

Thanks a lot for the swift response!

It does work , yes. And yes, I have deleted the extra rows but it still gives the same error.

5

Try putting useRows = '2:10' in Begin Experiment and then put $useRows in the loop.