467,143 Members | 1,245 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,143 developers. It's quick & easy.

How to run Excel Solver function from Python

I am trying to write a Python script file which analyses data in an
iterative manner. During each iteration, I wish to utilise the Solver
function in Excel to perform some constrained, non-linear fitting to
the data. I have a VBA macro which runs the Solver, and am using
self.xlapp = win32com.client.dynamic.Dispatch("Excel.Applicatio n")
..
..
..
self.xlapp.run(macro)

I am using the Python script to interface with another software called
ABAQUS and am executing the script through the ABAQUS Python
interpreter (which is Python 2.0). Howvever, when I run the script I
get the error

'Solver : An unexpected internal error has occurred, or available
memory was exhausted'

Could anyone please provide some explanation to this problem? The
macro and Solver run fine if I don't call from the Python script.
Thank you and any help is much appreciated.
Jul 18 '05 #1
  • viewed: 5241
Share:
1 Reply
Having widened my search, I found that this problem seems to be
related to Excel itself and not many have found a solution. But I
found this and it works a treat!!

http://groups.google.com/groups?hl=e...bl%26rnum%3D19

Sorry for posting this problem at the wrong place.
Jul 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
reply views Thread by Josh Golden | last post: by
3 posts views Thread by Mr.Doubt | last post: by
reply views Thread by engsolnorm@hotmail.com | last post: by
1 post views Thread by Laszlo Zsolt Nagy | last post: by
2 posts views Thread by tristan.chaplin@gmail.com | last post: by
7 posts views Thread by Holger Fitschen | last post: by
8 posts views Thread by =?Utf-8?B?SmVycnkgQw==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.