[python-win32] Standard Excel add-in does not load?

Blair Hall b.hall@irl.cri.nz
Fri, 21 Mar 2003 16:42:10 +1200

If someone could help me understand what to do here, I
would appreciate it.  I am trying to find a way to write
a complex number into an Excel cell from a Python program.

To write a complex number to an Excel cell one writes :
the function is supplied by a standard add-in
'Analysis Toolpak'.

Now here's the problem. I have a simple script:

import win32com.client
import pythoncom
x = win32com.client.Dispatch('Excel.Application')
x.Visible = 1
wb = x.WorkBooks.Add()
x.Cells.Item(1,1).Formula = '=COMPLEX(1,2)'
x = None

Which gets an instance of Excel and writes '1+2i'
into the first cell and then closes.

This script will only work correctly if the Excel has been opened
BEFORE the script runs (ie by hand). If I let the script
open Excel then the insertion of a complex number fails.

The cell shows '#NAME', which suggets that
the add-in has not been loaded properly.
Furthermore, I cannot use (manually) any of the functions
that belong to that add-in.

A quick check on the Excel menu bar indicates that
the add-in is selected. However, if I unselect the add-in and then 
re-select it,
then I can get the first cell to accept the COMPLEX formula.

To summarize: it appears that the standard add-in 'Analysis Toolpak'
is not loaded correctly when Excel is activated by the script above.

Can anyone tell me why?

I am trying this on Windows95 with Excel97, Python 2.2.2 and have win32all-150