Re: [python-win32] Documentation for win32com for Worksheets Worksheets.Range and Worksheets.Cells
xlwt - yes, but I have python 3.1 in my company and cant downgrade it :(
Blazej
2010/1/28 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 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
Re: [python-win32] Documentation for win32com for Worksheets Worksheets.Range and Worksheets.Cells
o 0.7.2 looks like working, I will give a try thx
Blazej
2010/1/29 Błażej Kaczorowski :
> xlwt - yes, but I have python 3.1 in my company and cant downgrade it :(
>
> Blazej
>
> 2010/1/28 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 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
Re: [python-win32] Documentation for win32com for Worksheets Worksheets.Range and Worksheets.Cells
Not working, cant import library ... :( there is a way to run xlwt or
similar on python 3.1?
Blazej
2010/1/29 Błażej Kaczorowski :
> o 0.7.2 looks like working, I will give a try thx
>
> Blazej
>
> 2010/1/29 Błażej Kaczorowski :
>> xlwt - yes, but I have python 3.1 in my company and cant downgrade it :(
>>
>> Blazej
>>
>> 2010/1/28 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 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
Re: [python-win32] Documentation for win32com for Worksheets Worksheets.Range and Worksheets.Cells
On 29/01/2010 08:46, Błażej Kaczorowski wrote: Not working, cant import library ... :( there is a way to run xlwt or similar on python 3.1? If you haven't already, you really want to look over here: http://www.python-excel.org/ and in particular at the mailing list referred to at the bottom of the page. TJG ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
Re: [python-win32] Documentation for win32com for Worksheets Worksheets.Range and Worksheets.Cells
non works in 3.1 :/ Blazej 2010/1/29 Tim Golden : > On 29/01/2010 08:46, Błażej Kaczorowski wrote: >> >> Not working, cant import library ... :( there is a way to run xlwt or >> similar on python 3.1? > > If you haven't already, you really want to look over here: > > http://www.python-excel.org/ > > and in particular at the mailing list referred to at the bottom > of the page. > > TJG > ___ > 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
Re: [python-win32] Documentation for win32com for Worksheets Worksheets.Range and Worksheets.Cells
2010/1/29 Błażej Kaczorowski : > non works in 3.1 :/ > The maintainer of xlwt, John Machin is thinking about the port to python 3.x http://groups.google.com/group/python-excel/browse_thread/thread/e3fe92bd08aa1cdd# but I do not think he is in a rush. ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
Re: [python-win32] Documentation for win32com for Worksheets Worksheets.Range and Worksheets.Cells
Błażej Kaczorowski wrote: > xlwt - yes, but I have python 3.1 in my company and cant downgrade it :( > That is an amazing statement. I can't imagine any company going mission-critical with Python 3 yet. There are just too many third-party modules that have not been ported. However, you don't have to downgrade. Python 2 and Python 3 are able to coexist on a single computer without any problems. Just install them both. -- Tim Roberts, t...@probo.com Providenza & Boekelheide, Inc. ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
Re: [python-win32] Documentation for win32com for Worksheets Worksheets.Range and Worksheets.Cells
Błażej Kaczorowski wrote: > I know, but I have app that runs with python3 .. and I would need to > rewrite it to python2 to use xlwt and still win32com works ok (but > slower) I probably wait for port ... > OK, that's fine. Just for your information, with appropriate use of "from __future__" statements, most Python 3 code will run in Python 2.6 (or later). -- Tim Roberts, t...@probo.com Providenza & Boekelheide, Inc. ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
Re: [python-win32] Documentation for win32com for Worksheets Worksheets.Range and Worksheets.Cells
probably yes, maybe I will check that in monday :) thx Blazej 2010/1/29 Tim Roberts : > Błażej Kaczorowski wrote: >> I know, but I have app that runs with python3 .. and I would need to >> rewrite it to python2 to use xlwt and still win32com works ok (but >> slower) I probably wait for port ... >> > > OK, that's fine. Just for your information, with appropriate use of > "from __future__" statements, most Python 3 code will run in Python 2.6 > (or later). > > -- > 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
