🌐 Mailman 3 October 2002 - Python-list - python.org

Python 2.1, COM (Excel), and Threads...
by stephen.tubbs＠paretopartners.com Nov. 2, 2002

Nov. 2, 2002

Hi - I am trying to get a threaded job server running that will thread scripts to manipulate various MS office apps. My first attempt has failed on Excel. It seems that invoking win32com.client.Dispatch('Excel.Application') from within a thread does not initialize the same way as it does when it is called from within the main python environment. A simple example: from threading import Thread class foo: def run(self): try: import win32com.client self.excel = win32com.client.Dispatch("Excel.Application") self.excel.Visible = 1 k = self.excel.Workbooks.Add() v = k.Worksheets(1) v.Cells(1,1).Value = str(self) except: import traceback traceback.print_exc() l = Thread(target = foo().run, #creates a new instance name = 'foo',verbose = 1) l.start() This causes the following stack trace: Traceback (most recent call last): File "I:\F\P\sp\interfaces\dispatcher\testexcelinthread.py", line 18, in run self.excel = win32com.client.Dispatch("Excel.Application") File "d:\python21\win32com\client\__init__.py", line 94, in Dispatch dispatch, userName = dynamic._GetGoodDispatchAndUserName(dispatch,userName,clsctx) File "d:\python21\win32com\client\dynamic.py", line 81, in _GetGoodDispatchAndUserName return (_GetGoodDispatch(IDispatch, clsctx), userName) File "d:\python21\win32com\client\dynamic.py", line 72, in _GetGoodDispatch IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, pythoncom.IID_IDispatch) com_error: (-2147221008, 'CoInitialize has not been called.', None, None) Is there an alternate initialization procedure that will work from within a Thread? Any help would be greatly appreciated. Stephen

4 5

Classes question
by Emmanuel Jeandel Nov. 2, 2002

Nov. 2, 2002

Hi, I have the following code : class A: def __init__(self): pass def f(self): self.x = B() class B(A): def __init__(self): A.__init__(self) I would like to have the class A and the class B in two differents files. Is it possible ? I think that it is not directly possible, but if there is a mean with a small change in the code... Thanks in advance Emmanuel

3 4

Re: Win32 DDE support documentation?
by Syver Enstad Nov. 1, 2002

Nov. 1, 2002

"Andrew Thompson" <andrew.thompson(a)ashecastle.com> writes: > I am trying to find some documentation for DDE (ala Microsoft Excel) but > seem to be going around in circles between Python.org and the vaults. > Does anyone know where I can find information on either hot or warm > links ? > > Many thanks. > Andrew. Hi Andrew. I've written a patch for the dde module in win32all to provide support for hot links. If you have access to the msvc compiler I can give you the source for it, or I could send you some compiled binaries.

3 2

Macros in Python, and using reg exps to build a scheme interpreter
by Peter L. Markowsky Nov. 1, 2002

Nov. 1, 2002

Hi, Currently in one of my classes I'm building a scheme interpreter in Java. This has brought two questions to mind. First does python use language macros to define higher level functionality. And two does anyone know a good place to look for how to implement a scheme parser using regular expressions? Thanks, Pete

2 1

MySQL + Python.
by Ingo Linkweiler Nov. 1, 2002

Nov. 1, 2002

Hello, I want to use Python for CGI-Skripting. My provider offers a MySQL database and scripting with PHP and Python. Is it possible to use MySQL with Python, if I do not know the platform? Do you know any "pure" Python-Modules to use MySQL ? Ingo

3 4

Re: Python-based browser plugins?
by paul＠boddie.net Nov. 1, 2002

Nov. 1, 2002

Terry Hancock <hancock(a)anansispaceworks.com> wrote in message news:<mailman.1036047036.2186.python-list(a)python.org>... > > Anyway, though -- returning to topic, is a C Python solution unviable? Your > defending the Java/Jython option suggests maybe you think so (and that was > what I thought before). I guess I already know the answer here -- but I was > wondering if the challenge would pique anyone's interest, as it would be > interesting to be proved wrong. :-) An interesting project would be a plug-in for popular browsers based on Python/Pygame/SDL. The hard part of this would surely be the integration with the browser, but I can imagine that IE, Mozilla and Konqueror are all open to this kind of thing. Paul

7 7

translate tables versus replace
by David Bear Nov. 1, 2002

Nov. 1, 2002

I have a string that contains certain chars that I want removed. The chars can be anywhere and in any order. I initially thought of something like string.replace(line, badchar1, '').replace(badchar2, '').replace(badchar3, '') But then I thought perhaps a translate table would work. A translate table that would convert the badchars into a space might work. I was hoping there was an easier way. However my biggest concern is performance of successive calls to replace versus a call to translate. Which might be 'faster'...?

2 1

How to use new email package to read a mailbox?
by Andrew Koenig Nov. 1, 2002

Nov. 1, 2002

The documentation for the mailbox package says that the default behavior of class UnixMailbox is to use rfc822.Message to create messages. However, rfc822 is noted as deprecated. Suppose I have a file that represents a Unix mailbox. What's the right idiom to use to process each message in that file using the new email package? -- Andrew Koenig, ark(a)research.att.com, http://www.research.att.com/info/ark

3 3

Python-based browser plugins?
by Terry Hancock Nov. 1, 2002

Nov. 1, 2002

[I actually posted this question to the mailing list a couple of days ago, but I think it fell victim to the mail-news gateway problem. If it's a repeat, I apologize]. This starts with Java, but ends with Python ... ;-D Although I have no special familiarity with it or inclination towards it, I have been considering using Java and/or Jython as a means of delivering applet and/or plugin clientside content-creation tools for a web collaboration application (specific examples would include a wysiwyg/wysiwym sdocbook XML editor and a simple 2D drawing/CAD tool that would create DXF or SVG output). I had hoped to be able to use as much pre-existing code as possible for this, in an effort to keep the task feasible (I was considering using Jython to handle the top-level part and rely on a free class library for the heavy parts). I found a HowTo describing a method of running a program as an applet, or downloading and installing as a plugin at the user's discretion, which gets past the bulk downloading problem in a flexible way. Sounds good so far. However, after reading an article on "the status of Java in Debian", I have become very concerned about the use of Java from a free-software perspective. It seems that Sun has taken a very aggressive stance regarding Java2, which the Java programmer community seems to have become very reliant on -- especially for the types of apps I'm talking about. It seems there is, for example, no end-to-end free-software way to run a Java2 applet. Unfortunately, the Java developer community seems to be very enamoured of Java2, and components built on it, such as Swing, seem to be an important part of any of the apps I would've considered using. Several people have posted in this group on the feasibility of replacing Java with Python, and my post resolves to another such question: is there any way I could distribute applets/plugins implemented in Python (I probably mean ordinary "C Python" here), such that the user will have a similarly transparent experience? (The other option of using Java1-only, I'll ask on the Jython list, I suppose). Unfortunately, the only browser that I know can do this is Grail, which is hardly mainstream! To be useful, I need something that will at least work on Windows, Macs, and Linux/X systems running IE, Netscape, or Mozilla (and it'd be nice if Konqueror, Opera, and others would work, too). In principle, I don't really care if it stays in the browser window, but it's got to work for the "teen using Mom's borrowed Win 9x system" crowd -- which is where the applets concept really shines. On the other hand, the curmudgeonly "just left of Richard Stallman" crowd isn't going to like relying on a non-free system (and I agree), which it would appear that Java2 is (no free Java2 implementations). But maybe I'm wrong and there is a way to get what I want using Python (pure or otherwise). That *would* be one less language to learn in short order! Any ideas would be greatly appreciated! :-D Cheers, Terry -- Terry Hancock Anansi Spaceworks http://www.anansispaceworks.com

3 2

Newbie: Where are SetCommMask, GetCommState, etc?
by engsol＠teleport.com Nov. 1, 2002

Nov. 1, 2002

The crime scene: Win NT, Python222, Mark Hammond's book on Win32, and win32comport_demo.py The problem: I connected my machine to another machine running Hyperterminal, using a null-modem cable, then fired up the demo. Works just fine. Now I want to learn in detail how it works. The demo script refers to SetCommMask, SetupComm, GetCommState, etc., but I can't find an explanantion how they work. I want to poke and prod my com ports, including the UART registers. Any pointers? Thanks.... Norm

2 1