A ok, thx, I found it and it is as you are saying thx it worked! Blazej
On 28 January 2010 20:36, Tim Roberts <t...@probo.com> wrote: > Błażej Kaczorowski wrote: >> I use python on win to deal with Excels and stuff at work. I was >> trying to find proper documentation of fe. to Worksheets >> Worksheets.Range and Worksheets.Cells objects but all I found on >> google are some lame tutorials with how to write "Hello World" it is >> simply ok for beginning but I need something more (fe. how to freeze >> top row in sheet). >> >> Can any1 point a place of full documentation for excel stuff in >> win32com? I would be gratefull. >> > > There is no "full documentation". Excel is just another COM object, so > there's nothing in win32com that specifically supports Excel. It's just > like all of the other COM objects. > > Microsoft has good documentation for the Excel object model, which > describes the properties and methods that Excel offers, usually showing > C++ or VBA code. You have to translate that into Python (which is not > always easy). > > The task you have chosen is not particularly easy. To do the task you > have chosen, you need to "split" the window into two panes, then set the > size of the top pane to one row. > xl = win32com.client.Dispatch("Excel.Application") > xl.Visible = 1 > w = xl.Application.ActiveWindow > w.Split = 1 > > I'm not entirely sure how to set the size of the individual panes. > > -- > Tim Roberts, t...@probo.com > Providenza & Boekelheide, Inc. > > _______________________________________________ > python-win32 mailing list > python-win32@python.org > http://mail.python.org/mailman/listinfo/python-win32 > _______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32