| pb09: pb-xl-horse by Poo-Brain [web] | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|||||||||||||
|
popularity : 61% |
|||||||||||||
alltime top: #7216 |
|
|||||||||||||
|
||||||||||||||
added on the 2016-02-21 16:44:51 by Chibi  |
||||||||||||||
popularity helper
comments
Installed Python 2.7.6 and win32com 220 for Python 2.7 and no joy. Just a quick black windows pop up and vanish.
added on the 2016-02-21 18:31:30 by ramon 
Updated to Python 2.7.11, same thing. What am I doing wrong?
never gonna give you up never gonna let you down
also morphing sushi is awesome
also morphing sushi is awesome
Hey ramon, what you could try is to create a bat file with
C:/Python27/Python.exe PB_XLPaard.py
pause
in it, next to the PB_XLPaard.py file, it will make the output window stay open & show the python output in it, which may help in finding out what's wrong.
Also, readme is missing this important bit:
You need excel to run this demo.
Thanks for courageously trying to run it though I do recommend checking the video! It's gonna save you a lot of headache!
C:/Python27/Python.exe PB_XLPaard.py
pause
in it, next to the PB_XLPaard.py file, it will make the output window stay open & show the python output in it, which may help in finding out what's wrong.
Also, readme is missing this important bit:
You need excel to run this demo.
Thanks for courageously trying to run it though I do recommend checking the video! It's gonna save you a lot of headache!
@ TropicalTrevor
I have Excel 2010 installed. Did the .bat thing and it tells me:
File "D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\PB_XLPaard.py", line 3, in <module> import win32api
ImportError: DLL load failed: %1 is not a valid Win32 application.
Videos are for pussies! I'm a purist!!! What's next to make this thing work? ;)
I have Excel 2010 installed. Did the .bat thing and it tells me:
File "D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\PB_XLPaard.py", line 3, in <module> import win32api
ImportError: DLL load failed: %1 is not a valid Win32 application.
Videos are for pussies! I'm a purist!!! What's next to make this thing work? ;)
@ramon: Allright, this error means your win32com install mismatches the bits of your OS / python. I recommend installing pythonx64 if you have an x64 system and then installing win32com x64 too!
Misleadingly the button on the python website always downloads x86 python,
py 2.7.11 x64 direct link
pywin32 for py2.7 x64
hope that helps!
Misleadingly the button on the python website always downloads x86 python,
py 2.7.11 x64 direct link
pywin32 for py2.7 x64
hope that helps!
@TropicalTrevor
Thanks for your help. You were right, fixed with all 64 bit component as I'm running Win7 64, but still get an error:
File "D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\PB_XLPaard.py", line 3, in <module> import win32api
ImportError: DLL load failed: The specified module could not be found.
This is what I did:
Uninstalled original pywin
Deleted 32 bit original folder C:\Python27
Re-installed 64 bit version Python 2.7.11 in C:\Python27 (default folder)
Re-installed 64 bit version pywin 220 in C:\Python27\Lib\site-packages (default folder)
"test_win32api.py" is indeed located in "C:\Python27\Lib\site-packages\win32\test" and "win32api.pyd" is also present, located in "C:\Python27\Lib\site-packages\win32". But there is no win32api.dll or other file with "win32api" in it!
This is the list of all the DLLs currently in my C:\Python27:
C:\Python27\Lib\site-packages\pythonwin\mfc90.dll
C:\Python27\Lib\site-packages\pythonwin\mfc90u.dll
C:\Python27\Lib\site-packages\pythonwin\mfcm90.dll
C:\Python27\Lib\site-packages\pythonwin\mfcm90u.dll
C:\Python27\msvcr90.dll
C:\Python27\Lib\site-packages\win32\perfmondata.dll
C:\Python27\Lib\site-packages\isapi\PyISAPI_loader.dll
C:\Python27\python27.dll
C:\Python27\Lib\site-packages\pywin32_system32\pythoncom27.dll
C:\Python27\Lib\site-packages\pywin32_system32\pythoncomloader27.dll
C:\Python27\Lib\site-packages\pywin32_system32\pywintypes27.dll
C:\Python27\Lib\site-packages\pythonwin\scintilla.dll
C:\Python27\DLLs\sqlite3.dll
C:\Python27\DLLs\tcl85.dll
C:\Python27\tcl\dde1.3\tcldde13.dll
C:\Python27\DLLs\tclpip85.dll
C:\Python27\tcl\reg1.2\tclreg12.dll
C:\Python27\tcl\tix8.4.3\tix84.dll
C:\Python27\DLLs\tk85.dll
Any clue of what is going on?
Thanks for your help. You were right, fixed with all 64 bit component as I'm running Win7 64, but still get an error:
File "D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\PB_XLPaard.py", line 3, in <module> import win32api
ImportError: DLL load failed: The specified module could not be found.
This is what I did:
Uninstalled original pywin
Deleted 32 bit original folder C:\Python27
Re-installed 64 bit version Python 2.7.11 in C:\Python27 (default folder)
Re-installed 64 bit version pywin 220 in C:\Python27\Lib\site-packages (default folder)
"test_win32api.py" is indeed located in "C:\Python27\Lib\site-packages\win32\test" and "win32api.pyd" is also present, located in "C:\Python27\Lib\site-packages\win32". But there is no win32api.dll or other file with "win32api" in it!
This is the list of all the DLLs currently in my C:\Python27:
C:\Python27\Lib\site-packages\pythonwin\mfc90.dll
C:\Python27\Lib\site-packages\pythonwin\mfc90u.dll
C:\Python27\Lib\site-packages\pythonwin\mfcm90.dll
C:\Python27\Lib\site-packages\pythonwin\mfcm90u.dll
C:\Python27\msvcr90.dll
C:\Python27\Lib\site-packages\win32\perfmondata.dll
C:\Python27\Lib\site-packages\isapi\PyISAPI_loader.dll
C:\Python27\python27.dll
C:\Python27\Lib\site-packages\pywin32_system32\pythoncom27.dll
C:\Python27\Lib\site-packages\pywin32_system32\pythoncomloader27.dll
C:\Python27\Lib\site-packages\pywin32_system32\pywintypes27.dll
C:\Python27\Lib\site-packages\pythonwin\scintilla.dll
C:\Python27\DLLs\sqlite3.dll
C:\Python27\DLLs\tcl85.dll
C:\Python27\tcl\dde1.3\tcldde13.dll
C:\Python27\DLLs\tclpip85.dll
C:\Python27\tcl\reg1.2\tclreg12.dll
C:\Python27\tcl\tix8.4.3\tix84.dll
C:\Python27\DLLs\tk85.dll
Any clue of what is going on?
.
This is the wildest thing I've ever seen.
bahaha :D
sushi met de swekbois
@everyone: Thanks for enjoying!
@ramon: Googling about I find that the installer sometimes fails to run a postinstall script which actually puts the dlls in the right place.
The second answer here explains how to manually run it if you like.
You could also try to re-run the installer as administrator or w/e. Weird old python packages with ancient installers aren't really my domain... definitely had to reinstall python at various points during the making of this demo due to similar issues.
Cheers!
@ramon: Googling about I find that the installer sometimes fails to run a postinstall script which actually puts the dlls in the right place.
The second answer here explains how to manually run it if you like.
You could also try to re-run the installer as administrator or w/e. Weird old python packages with ancient installers aren't really my domain... definitely had to reinstall python at various points during the making of this demo due to similar issues.
Cheers!
over the top
+double buffering from excelseat.
+morphing of sushi(with gyabo)
+The cool sense Japanese can't take out...
+morphing of sushi(with gyabo)
+The cool sense Japanese can't take out...
thats flipin mental!
I had tears in my eyes while watching this. You almost killed me with laughter.
Now theres something you don't see every day
...or actually I do...but not like this :P
good work poobrainers!
...or actually I do...but not like this :P
good work poobrainers!
Lol nice Excel 2013 demo :)
left me cold. oink.
@TropicalTrevor
Manually moving pywintypes27.dll and pythoncom27.dll to C:\Python27\Lib\site-packages\win32 did the trick, unfortunately, despite my Excel 2010 now opens, nothing happens :( Is Excel 2013 mandatory? This is the output of the command window that I now have:
D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse>C:\Python27\Python.exe D:\_P
C_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\PB_XLPaard.py
Traceback (most recent call last):
File "D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\PB_XLPaard.py", line 672, in <module> test()
File "D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\PB_XLPaard.py", line 656, in test
renderer = Excel(EXCEL_MAX_X, EXCEL_MAX_Y, PIXEL_SIZE, 2)
File "D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\devices.py", line 208, in __init__self.sheets, self._excel = excel_sheets(buffer_count+1, path=macroPath)
File "D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\devices.py", line 85, in excel_sheets bla[0].Move(Before=bla[1])
AttributeError: 'int' object has no attribute 'Move'
Manually moving pywintypes27.dll and pythoncom27.dll to C:\Python27\Lib\site-packages\win32 did the trick, unfortunately, despite my Excel 2010 now opens, nothing happens :( Is Excel 2013 mandatory? This is the output of the command window that I now have:
D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse>C:\Python27\Python.exe D:\_P
C_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\PB_XLPaard.py
Traceback (most recent call last):
File "D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\PB_XLPaard.py", line 672, in <module> test()
File "D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\PB_XLPaard.py", line 656, in test
renderer = Excel(EXCEL_MAX_X, EXCEL_MAX_Y, PIXEL_SIZE, 2)
File "D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\devices.py", line 208, in __init__self.sheets, self._excel = excel_sheets(buffer_count+1, path=macroPath)
File "D:\_PC_Demo\_Cross-platform\Python\PB09-PB-XL-Horse\devices.py", line 85, in excel_sheets bla[0].Move(Before=bla[1])
AttributeError: 'int' object has no attribute 'Move'
Ahahahahahahahahahaha! :D
@ramon
Actually had to download the version here for that to appear on my end haha, so it's trying to sort out three excel sheets named Sheet1, Sheet2, Sheet3, my guess is that it can't make these additional sheets. Best bet is manually adding enough sheets (ordered 1,2,3) in the opened excel & rerunnning the py file!
Actually had to download the version here for that to appear on my end haha, so it's trying to sort out three excel sheets named Sheet1, Sheet2, Sheet3, my guess is that it can't make these additional sheets. Best bet is manually adding enough sheets (ordered 1,2,3) in the opened excel & rerunnning the py file!
@TropicalTrevor
IT'S WORKING!!!!!!! My guess for the final problem was that I use the French version of Excel 2010, so the name of the sheets were in French (feuille1 etc...). There was already 3 sheets opened, so I simply renamed them all to Sheet1, Sheet2 and Sheet3 and voila! I guess the demo could have created its own sheets instead on relying on the 3 default one to avoid that kind of problem.
Now I can comment: Fantastic production! I love hacking software to make them do stuff they are not intended to do!
IT'S WORKING!!!!!!! My guess for the final problem was that I use the French version of Excel 2010, so the name of the sheets were in French (feuille1 etc...). There was already 3 sheets opened, so I simply renamed them all to Sheet1, Sheet2 and Sheet3 and voila! I guess the demo could have created its own sheets instead on relying on the 3 default one to avoid that kind of problem.
Now I can comment: Fantastic production! I love hacking software to make them do stuff they are not intended to do!
Haha too awesome!
wow, on the youtube-link i get a new hilarious error:
"This video is identical to a previously uploaded video! We´re sorry."
And no link to the identical video or anything alike! wtf?!
"This video is identical to a previously uploaded video! We´re sorry."
And no link to the identical video or anything alike! wtf?!
hilarious==ridiculous (i keep mixing those two words up! :/ )
Choppy, but neat.
okay
i like it!
submit changes
if this prod is a fake, some info is false or the download link is broken,
do not post about it in the comments, it will get lost.
instead, click here !