openpyxl and psychopy/data.py

[terronymous-boosh]

Just ran a manual install of 1.84.2, loaded all the pre-requisites and ran into the following error:

trialList=data.importConditions(u'SequentialPriming.xlsx'),
  File "C:\Python27\lib\site-packages\psychopy\data.py", line 2668, in importConditions
    raise ImportError('openpyxl is required for loading excel '
ImportError: openpyxl is required for loading excel format files, but it was not found.

it seems like as of godknowswhen openpyxl (version 2.4.1 on my machine) no longer has the method cell.get_column_letter, so instead you would need to change line 29 in data.py from

from openpyxl.cell import get_column_letter

to

from openpyxl.utils import get_column_letter

[hoechenberger]

Could you try with latest master? I believe this was fixed in #1276
Could be a dupe of #1274 then.

[terronymous-boosh]

Thanks, sorry for not spotting that. Is there an easy way to install the latest master using pip? Forgive my ignorance, I'm new to python. Jon

…

On 25 Nov 2016 7:29 p.m., "Richard Höchenberger" ***@***.***> wrote: Could you try with latest master? I believe this was fixes in #1276 <#1276> Could be a dupe of #1274 <#1274> then. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#1314 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ARet-F1eceNqCEEKhbGyNTRChITuEeZhks5rBzcUgaJpZM4K8lFH> .

[hoechenberger]

pip install --upgrade git+https://github.com/psychopy/psychopy

should do the trick. If you don't have git installed, you can try

pip install --upgrade https://github.com/psychopy/psychopy/archive/master.zip

[hoechenberger]

@terronymous-boosh, any news on this one?

[Soraltan]

Hi, I had exactly the same error.

The suggested upgrade from the git reps did the trick. It is solved, as far as I can see.

[peircej]

Thanks for confirming this is fixed in repos. Will be released very soon.