Dear Jon,
I have a similar problem. Maybe you can help me out with that one. I got used to pandas and save some data concerning the order of trials in an excel file with the pandas to_excel command. It works under linux, but I have problems on the standalone version of psychopy on windows 7.
I get the following error:
Traceback (most recent call last):
File "E:\dfg_win\main.py", line 105, in <module>
order_df.to_excel(filename_order, header=True, encoding='utf-8', index=False)
File "C:\Program Files (x86)\PsychoPy2\lib\site-packages\pandas\core\frame.py", line 1260, in to_excel
excel_writer = ExcelWriter(excel_writer, engine=engine)
File "C:\Program Files (x86)\PsychoPy2\lib\site-packages\pandas\io\excel.py", line 635, in __init__
.format(self.openpyxl_majorver))
ValueError: Installed openpyxl is not supported at this time. Use 1.x.y.
Openpyxl-1.5.8 is installed, so that's strange. I tried copying my version of openpyxl from Linux as well as installing different versions of openpyxl but get always some kind of error. Do you know any simple way to get around the problem?
For now I just use to_csv instead and it works, so it's not a big deal, but if you know a way to solve it, I would appreciate it.
best wishes
Piotr