Re: [python-win32] Excel using python

2006-02-20 Thread Tim Golden
[yeswanty devi] | Hello all, | if we have number of excel sheets in a workbook.can | we access a selected sheet in the workbook. when i try to | acces it always goes to the last sheet. I assume this is the kind of thing you want: (somewhat exaggerated example, but ...) import os imp

Re: [python-win32] Excel using python

2006-02-20 Thread John Machin
On 20/02/2006 7:46 PM, Tim Golden wrote: > [yeswanty devi] > > | Hello all, > | if we have number of excel sheets in a workbook.can > | we access a selected sheet in the workbook. when i try to > | acces it always goes to the last sheet. > > I assume this is the kind of thing you want

Re: [python-win32] Excel using python

2006-02-20 Thread Tim Golden
[John Machin] | | On 20/02/2006 7:46 PM, Tim Golden wrote: | > [yeswanty devi] | > | > | Hello all, | > | if we have number of excel sheets in a workbook.can | > | we access a selected sheet in the workbook. when i try to | > | acces it always goes to the last sheet. | > | > I assume

Re: [python-win32] Excel using python

2006-02-20 Thread John Machin
On 20/02/2006 8:02 PM, Tim Golden wrote: > [John Machin] > | > | On 20/02/2006 7:46 PM, Tim Golden wrote: > | > [yeswanty devi] > | > > | > | Hello all, > | > | if we have number of excel sheets in a workbook.can > | > | we access a selected sheet in the workbook. when i try to > | > |

Re: [python-win32] Excel using python

2006-02-20 Thread Tim Golden
[John Machin] | > OK, given the workbook created in my previous post... [ ... snip more code ...] | OK, great, Tim, we're almost there :-) | "when i try to acces it always goes to the last sheet." ... | looks like | the OP wants the default sheet to point to some sheet other than the | last

Re: [python-win32] Excel using python

2006-02-20 Thread John Machin
On 20/02/2006 10:15 PM, Tim Golden wrote: > [John Machin] > > | > OK, given the workbook created in my previous post... > > [ ... snip more code ...] > > | OK, great, Tim, we're almost there :-) > | "when i try to acces it always goes to the last sheet." ... > | looks like > | the OP wants th

Re: [python-win32] Excel using python

2006-02-20 Thread Tim Golden
| From: John Machin [mailto:[EMAIL PROTECTED] | | Tim, that's fantastic. Hold out your hand for the elephant stamp :-) Must be an American thing? (Obligatory Monty Python reference: I'm sorry, old man, I don't quite follow your banter!) | ... apart from moderate banter, we haven't got off his |

Re: [python-win32] Excel using python

2006-02-20 Thread John Machin
On 20/02/2006 10:37 PM, Tim Golden wrote: > | From: John Machin [mailto:[EMAIL PROTECTED] > | > | Tim, that's fantastic. Hold out your hand for the elephant stamp :-) > > Must be an American thing? (Obligatory Monty Python > reference: I'm sorry, old man, I don't quite follow your > banter!) >

[python-win32] Problem with excel AutoFilter function

2006-02-20 Thread Sylvain FAUVEAU (apli-agipa)
Hello. I have a little problem with the function AutoFilter in Excel. The VB code for activate, desactivate AutoFilter is the same : AutoFilter But if I try this in python it doesn't work ! For activate the autofilter in python, I make this : selection.AutoFilter(Field=1) It works. But to desa

Re: [python-win32] Excel using python

2006-02-20 Thread p.asselman
Or how about xl.Worksheets(1).Activate() or xl.Worksheets("Sheet1").Activate() and then you may use sheetname = xl.ActiveSheet.Name and other such nice things... Best regards, Patrick Asselman > > van: "Tim Golden" <[EMAIL PROTECTED]> > datum: 2006/02/20 ma PM 12:15:49 CET > aan: > onderw

[python-win32] Excel Application

2006-02-20 Thread yeswanty devi
Hello all,  if we have number of excel sheets in a workbook.can we access a select sheet in the workbook. when i try to acces it always goes to the last sheet.   thanks,       Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, & more on new and used cars.___

[python-win32] saving an ole control object embedded in a powerpoint

2006-02-20 Thread Bertrand Mathieu
Hi, I have made a python program that extracts some informations out of PowerPoint files, using MS-Powerpoint. It works well, but I also need to extract Shockwave Flash from certain slides. I am able to get the OLE object, but I can't figure out what to do with it so as to save its content to a SW

Re: [python-win32] saving an ole control object embedded in a powerpoint

2006-02-20 Thread Mark Hammond
> The problem is that I don't know how to obtain something that would be > accepted as an IStream (through python/com machinery) and that would > write everything to a file or in a string, and that I can read later. Look at the win32com.server.util FileStream class. Usage would be something like: