Author Topic: help me ,what is wrong ???  (Read 657 times)

hxdef1000

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
help me ,what is wrong ???
« on: March 29, 2015, 03:09:18 AM »
system:win7 32bit pro
python:3.4 32bit
office:2010 32bit

python path:C:\Python34
pyxll:C:\Python34

pyxll.cfg
[PYXLL]
developer_mode = 1
pythonpath =
   .\examples
modules =
   misc
   worksheetfuncs
   customtypes
   asyncfunc
   menus
   automation
   callbacks
   objectcache
   tools.eclipse_debug
   tools.reload

[LOG]
verbosity = info
format = %(asctime)s - %(levelname)s : %(message)s
path = ./logs
file = pyxll.%(date)s.log

hxdef1000

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: help me ,what is wrong ???
« Reply #1 on: March 29, 2015, 03:11:13 AM »
the pic in the file

hxdef1000

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: help me ,what is wrong ???
« Reply #2 on: March 29, 2015, 03:12:46 AM »
log
2015-03-29 10:11:31,805 - INFO :
------------------------------------------------------------------------------
  PyXLL

  Version          2.2.2
  Buildtime        2014-12-14 17:48
  Python version   3.4.2.final.0
  Excel version    14.0

  www.pyxll.com
------------------------------------------------------------------------------

2015-03-29 10:11:32,001 - WARNING : *** win32com.client could not be imported          ***
2015-03-29 10:11:32,001 - WARNING : *** some of the automation examples will not work  ***
2015-03-29 10:11:32,001 - WARNING : *** to fix this, install the pywin32 extensions.   ***
2015-03-29 10:11:32,005 - WARNING : *** win32com.client could not be imported           ***
2015-03-29 10:11:32,005 - WARNING : *** some of the objectcache examples will not work  ***
2015-03-29 10:11:32,005 - WARNING : *** to fix this, install the pywin32 extensions     ***
2015-03-29 10:11:32,011 - WARNING : pydevd failed to import - eclipse debugging won't work
2015-03-29 10:11:32,012 - WARNING : Check the eclipse path in C:\Python34\examples\tools\eclipse_debug.py
2015-03-29 10:11:43,769 - ERROR : Error calling function button_example
2015-03-29 10:11:43,770 - ERROR : Traceback (most recent call last):
2015-03-29 10:11:43,770 - ERROR :   File "C:\Python34\examples\automation.py", line 110, in button_example
2015-03-29 10:11:43,773 - ERROR :     xl = xl_app()
2015-03-29 10:11:43,773 - ERROR :   File "C:\Python34\examples\automation.py", line 79, in xl_app
2015-03-29 10:11:43,775 - ERROR :     xl_window = pyxll.get_active_object()
2015-03-29 10:11:43,775 - ERROR : ImportError: No module named 'pythoncom'
2015-03-29 10:11:44,731 - ERROR : Error calling function checkbox_example
2015-03-29 10:11:44,731 - ERROR : Traceback (most recent call last):
2015-03-29 10:11:44,732 - ERROR :   File "C:\Python34\examples\automation.py", line 116, in checkbox_example
2015-03-29 10:11:44,734 - ERROR :     xl = xl_app()
2015-03-29 10:11:44,734 - ERROR :   File "C:\Python34\examples\automation.py", line 79, in xl_app
2015-03-29 10:11:44,736 - ERROR :     xl_window = pyxll.get_active_object()
2015-03-29 10:11:44,736 - ERROR : ImportError: No module named 'pythoncom'
2015-03-29 10:11:51,568 - INFO : callbacks.on_close: PyXLL is closing

Tony

  • Administrator
  • Hero Member
  • *****
  • Posts: 574
  • Karma: +13/-1
    • View Profile
Re: help me ,what is wrong ???
« Reply #3 on: March 29, 2015, 03:26:00 PM »
Hi,

it looks like the only thing that's wrong is that you don't have the pywin32 packages installed.

You can get them from PyPI:
https://pypi.python.org/pypi/pywin32/214

These are optional and you can use PyXLL without them, but some of the examples (like the automation ones you are looking at) require them.

Best regards,
Tony