[python-win32] Documentation for win32com for Worksheets Worksheets.Range and Worksheets.Cells

[Błażej Kaczorowski]

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 <timr at 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, timr at probo.com
> Providenza & Boekelheide, Inc.
>
> _______________________________________________
> python-win32 mailing list
> python-win32 at python.org
> http://mail.python.org/mailman/listinfo/python-win32
>