Re: Adding Worksheets to an Excel Workbook

2006-10-18 Thread wesley chun
> From: Tom Plunket > Date: Tues, Oct 17 2006 6:34 pm > > You've got a lot of sleep calls in there- did you find that things > behaved erratically without them? I haven't done any Office > automation with Python, but my DevStudio stuff has always worked a > treat without the sleep calls. sorry,

Re: Adding Worksheets to an Excel Workbook

2006-10-17 Thread Tom Plunket
wesley chun wrote: > welcome to Python!! i too, have (recently) been interested in COM > programming, so much so that i added some material... > from time import sleep > import win32com.client as win32 > > def excel(): > xl = win32.gencache.EnsureDispatch('Excel.Application') > ss = xl.

Re: Adding Worksheets to an Excel Workbook

2006-10-13 Thread Fabian Braennstroem
Hi Wesley, * wesley chun <[EMAIL PROTECTED]> wrote: >> just a small OT question coming from a linux openoffice >> system... >> >> Does there exist something similar for powerpoint? Would be >> nice, if anybody can direct me to more examples... > > > fabian, > > see below for a PP example. you men

Re: Adding Worksheets to an Excel Workbook

2006-10-11 Thread wesley chun
> just a small OT question coming from a linux openoffice > system... > > Does there exist something similar for powerpoint? Would be > nice, if anybody can direct me to more examples... fabian, see below for a PP example. you mentioned you were coming from a linux OOo system... are you trying

Re: Adding Worksheets to an Excel Workbook

2006-10-11 Thread Fabian Braennstroem
Hi, just a small OT question coming from a linux openoffice system... * wesley chun <[EMAIL PROTECTED]> wrote: >> From: [EMAIL PROTECTED] >> Date: Tues, Oct 10 2006 2:08 pm >> >> I'm a Python newbie, and I'm just getting to the wonders of COM >> programming. > > > welcome to Python!! i too, have

Re: Adding Worksheets to an Excel Workbook

2006-10-11 Thread wesley chun
> From: [EMAIL PROTECTED] > Date: Tues, Oct 10 2006 2:08 pm > > I'm a Python newbie, and I'm just getting to the wonders of COM > programming. welcome to Python!! i too, have (recently) been interested in COM programming, so much so that i added some material on Microsoft Office (Win32 COM Clien

Re: Adding Worksheets to an Excel Workbook

2006-10-11 Thread e . h . doxtator
These are all excellent suggestions. Thanks everyone for your help! -- http://mail.python.org/mailman/listinfo/python-list

Re: Adding Worksheets to an Excel Workbook

2006-10-10 Thread greg.rb
# here is a simple script: from win32com.client import Dispatch xlApp = Dispatch("Excel.Application") xlApp.Visible=1 #show me excel xlApp.Workbooks.Add() #add a workbook for r in range(1,5): #put data into spreadsheet row/column xlApp.Cells(r,r).Value=r for r in range(1,5): #read data from

Re: Adding Worksheets to an Excel Workbook

2006-10-10 Thread Mark Elston
I expect this doesn't help him much. I get the impression he is looking more for a recipe. Just doing a Google search of python + excel I got the following which make some good starting points: http://www.markcarter.me.uk/computing/python/excel.html http://mail.python.org/pipermail/python-list/2

Re: Adding Worksheets to an Excel Workbook

2006-10-10 Thread John Machin
[EMAIL PROTECTED] wrote: > All > > I'm a Python newbie, and I'm just getting to the wonders of COM > programming. I am trying to programmatically do the following: > > 1. Activate Excel > 2. Add a Workbook > 3. Add a Worksheet > 4. Populate the new Worksheet > 5. Repeat steps 3,4 while there

Adding Worksheets to an Excel Workbook

2006-10-10 Thread e . h . doxtator
All I'm a Python newbie, and I'm just getting to the wonders of COM programming. I am trying to programmatically do the following: 1. Activate Excel 2. Add a Workbook 3. Add a Worksheet 4. Populate the new Worksheet 5. Repeat steps 3,4 while there is data. How do you add a Worksheet to a W