On Wed, Aug 10, 2011 at 6:56 AM, Tim Golden <[email protected]> wrote: > On 10/08/2011 11:15, A. S. wrote: >> >> I've worked with pywin32 and up to now inspecting the Excel macro editor >> and translating commands worked fine, but now I cannot manage to add a >> sheet at the correct position in Excel. >> >> My test program is >> >> from win32com.client import Dispatch >> >> app=Dispatch("Excel.Application") >> app.Workbooks.Add() >> app.ActiveWorkbook.Sheets.Add(After=app.ActiveWorkbook.Sheets(3)) >> >> Which adds the sheet at the incorrect position. Is there a trick? How >> come Excel gets confused? > > Well, you don't say what "at the incorrect position" means for you, but > it appears to work for me. One small hint is that Workbooks.Add returns > the new workbook so you don't have to do app.ActiveWorkbook all over > the place. In summary, this works for me: > > <code> > from win32com.client import Dispatch > > app = Dispatch ("Excel.Application") > app.Visible = 1 # Watch what's going on > wb = app.Workbooks.Add () > # [Sheet1], [Sheet2], [Sheet3] > wb.Sheets.Add (After=wb.Sheets (3)) > # [Sheet1], [Sheet2], [Sheet3], [Sheet4] > > </code> > > Do you see the same? And is that what you expected? I see [Sheet4], [Sheet1], [Sheet2], [Sheet3]
Python2.7.2, Excel 2007 _______________________________________________ python-win32 mailing list [email protected] http://mail.python.org/mailman/listinfo/python-win32
