Win32com to copy Excel worksheet

Tim Howarth tim at worthy.demon.co.uk
Mon Oct 22 20:59:12 CEST 2001


I'm trying to enter data into Excel using win32com.client and would like
to copy a worksheet.

xla=Disparch('Excel.Application')
xla.sheets(1).copy

will copy the worksheet but to a new workbook which is not what I want.

Reading the VBA help (and trying it!) it is possible to specify a target
for the worksheet;

Sheets(1).copy Before:=Sheets(2)

My question, how do you pass the "Before:=Sheets(2)" parameter using
Python?

-- 
___
 |im    ---- ARM Powered ----



More information about the Python-list mailing list