<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Le 05/07/2012 09:22, Maurizio
Spadaccino a écrit :<br>
</div>
<blockquote
cite="mid:CAECFW5nxSB6PMctO+4Gn-BQGPVhCuUYMvE44M368L-+u2yKu6g@mail.gmail.com"
type="cite">Hi all
<div><br>
</div>
<div>I'm new to Python but soon after a few days of studying its
features I find it my favourite mean of programming scripts to
allow for data storing and mining. My idea would be to inplement
python scripts from inside an excel sheet that would store and
fetch data from a Mysql database. So i need the script to be
launched, say, by pressing a button in excel and, for instance,
retrieve immediately data from the mysql table. For what I found
in the net, it seems there are three ways to control python from
excel:<span></span></div>
<div>1) run my python script via shell using the Run command in
VBA, which seems to me the easiest (but maybe slower?) way;</div>
<div>2) creating a COM server, for which I need more training
since it doesnt appear that easy;</div>
<div>3) via Microsoft Script Control, for which I saw some example
around where It looks like I can 'simulate' a python shell via
the 'executeStatement' command. </div>
<div><br>
</div>
<div>What would you suggest would be the more performing way to
achieve my goals as described above?</div>
<div><br>
</div>
<div>Thanks for you help</div>
<div>Maurizio</div>
<br>
<br>
-- <br>
Maurizio<br>
<br>
<br>
<a moz-do-not-send="true" href="http://www.mauriziospadaccino.com">www.mauriziospadaccino.com</a><br>
---------------<br>
If you can avoid printing this e-mail, you are only doing good for
our planet.<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
Look at PyUNO from OpenOffice very large API:<br>
<a class="moz-txt-link-freetext" href="http://www.openoffice.org/api/docs">http://www.openoffice.org/api/docs</a><br>
<br>
I use to create all my documention (Excell, Writer, etc...) on this
API.<br>
<br>
Cheers<br>
Karim<br>
<br>
</body>
</html>