Group items tagged

You can use Microsoft Script Control. If you have the win32 extensions of python, you can use python in place of vb in this control -open the VBA script editor - In menus/Tools/References add Microsoft Script Control -Make a new module and declare a new MsScriptControl.ScriptControl Global sc as new MsScriptControl.ScriptControl -Initialize the language attibute with python - Note that you and users of your document must have python and its win32 extensions installed. Activestate python distribustion include it. You can put sc.language="python" in the routine Workbook_Open() Now you can import python modules using ExecuteStatement method of the control in vba and have results from python functions with eval method. One interesting thing is that you can pass an object to the control with AddObject method and have python manipulate it. And so on..

Global sc As New MSScriptControl.ScriptControl Public Function os_getcwd() sc.Language = "python" sc.ExecuteStatement ("import os") os_getcwd = sc.Eval("os.getcwd()") End Function With this you can set your Excel formula to =os_getcwd() For me it returns "C:\Documents and Settings\Administrator\My Documents", which I needed to know at the time so I didn't have to screw around with the ever annoying pythonpath. You can put the first two lines of the function in the Workbook_Open hook, but I don't know where that is. I hope to use more Python in Excel soon. Hmm, actually, I suppose you can put those first two lines of the function after the Global declaration as well. I know just about zero VBScript and didn't get a chance to do anything else beyond proof of concept yet. I figured I would write something dynamic which allowed more transparent access to Python, maybe allowing formula like =py("os.getcwd()"), etc.

On Sat, 15 Dec 2001 17:53:49 -0800 (PST), David Brady <daves_spam_dodging_account at yahoo.com> wrote : >More win32all questions... is it possible to get the >handle of the window that currently has the focus? >win32gui.GetActiveWindow() fails because I'm looking >for a window outside the process of my Python script. E:\>python ActivePython 2.1.1, build 212 (ActiveState) Python 2.1.1 (#20, Jul 26 2001, 11:38:51) [MSC 32 bit (Intel)] on win32 Type "copyright", "credits" or "license" for more information. >>> import win32gui >>> import time >>> for x in range(10): ... time.sleep(1) ... print x, win32gui.GetWindowText(win32gui.GetForegroundWindow()) ... 0 cmd - python 1 cmd - python 2 (Untitled) * SciTE 3 (Untitled) * SciTE 4 ActivePython Documentation 5 ActivePython Documentation 6 PythonWin 7 PythonWin 8 PythonWin

Pypar does not require the Python interpreter to be modified or recompiled: Parallel python programs use the standard Python and need merely import the pypar module. This means for example that you can upgrade Python independently of your parallel codes.

Pypar is an efficient but easy-to-use module that allows programs/scripts written in the Python programming language to run in parallel on multiple processors and communicate using message passing. Pypar provides bindings to an important subset of the message passing interface standard MPI. Other Python MPI bindings available from other developers include: PyMPI, Scientific Python and pythonMPI.

Stackless Python is an alternative implementation of Python created by independent developer Christian Tismer. He started with the conventional Python language processor managed by the language's inventor, Guido van Rossum, and patched his own Stackless invention in place of a small but central part of Python's internals. Stackless Python is the result. This article introduces Tismer's technology and its significance. In future articles, you'll be able to read about how to make your own start at programming Stackless Python, as well as the prospects for a merger between Stackless and the main Python distribution.

 > According to the fact that all Thread run on the same CPU (if i didn't  > understand wrong), i'm asking if python will suffer from the future  > multicore CPU. Will not python use only one core, then a half or a  > quarter of CPU ? It could be a serious problem for the future of python... I agree that it could potentially be a serious hindrance for cpython if "multiple core" CPUs become commonplace. This is in contrast to jython and ironpython, both of which support multiple-cpu parallelism. Although I completely accept the usual arguments offered in defense of the GIL, i.e. that it isn't a problem in the great majority of use cases, I think that position will become more difficult to defend as desktop CPUs sprout more and more execution pipelines. I think that this also fits in with AM Kuchling's recent musing/thesis/prediction that the existing cpython VM may no longer be in use in 5 years, and that it may be superceded by python "interpreters" running on top of other VMs, namely the JVM, the CLR, Smalltalk VM, Parrot, etc, etc, etc. http://www.amk.ca/diary/archives/cat_python.html#003382 I too agree with Andrew's basic position: the Python language needs a period of library consolidation. There is so much duplication of functionality out there, with the situation only getting worse as people re-invent the wheel yet again using newer features such generators, gen-exps and decorators.

IPython on resizeable Win32 Console If you are on win32, you might want to use Console, an open source replacement for that inflexible old win32 terminal. Here's how. Install IPython using the .exe installer. Download stable version of Console (1.5 at this time). Create a shortcut to console.exe, right-click -> properties. Set target to e.g. C:\opt\Console\console.exe -c "/k python c:\python25\scripts\ipython.py -p sh" you can also create a tab dedicated to Ipython (and have other dedicated to other shells or command-line app). go to edit->settings->tabs : click on the add button and fill the following fields : * title : ipython ico : C:\Python24\py.ico shell : cmd.exe /k "ipython" start-up dir : whatever is good for you. note that python.exe need to be in the path Using IPython with Version 2 of Console use the -r option for creating the shortcut, e.g. C:\opt\Console2\console.exe -r "/k python c:\python25\scripts\ipython.py -p sh" Some advantages of Console2 over normal console (for IPython use) Distinctive taskbar icon Can reside in system tray There are many other benefits, so it's well worth setting up Example config for Console-2.00b120-Beta (you need to edit the xml file): http://vvtools.googlecode.com/svn/trunk/config/console.xml If you have problems with ctrl+C killing Console2 immediately, launch ipython from a normal Console2 session manually.