Zoom in xlwt + auto-adjusting width for columns.
Dargoan
I'm new here. I'm new in Python, and I'm new in xlwt.
I'm using Python 2.5 on a windows OS (XP) for work. I'm using xlwt
0.7.2.
I looked in the source code but found nothing related to my questions,
and also in the examples. So I'm asking here.
Q1:
I want to create a Excel file. I manage to do it, but I'd like to
create a file with 85% of the Zoom property for the Spreadsheet.
Does xlwt permit that and how?
Q2:
I'd like some of my columns to adjust their width automatically. Same
question: does xlwt permit that and how?
Many thanks !
John Machin
> Hey everyone,
>
> I'm new here. I'm new in Python, and I'm new in xlwt.
Welcome ...
> I'm using Python 2.5 on a windows OS (XP) for work. I'm using xlwt
> 0.7.2.
>
> I looked in the source code but found nothing related to my questions,
> and also in the examples. So I'm asking here.
>
> Q1:
> I want to create a Excel file. I manage to do it, but I'd like to
> create a file with 85% of the Zoom property for the Spreadsheet.
> Does xlwt permit that and how?
(2) Search for messages in this group with "zoom" in the subject, dates
in December 2008.
>
> Q2:
> I'd like some of my columns to adjust their width automatically. Same
> question: does xlwt permit that and how?
autofit is done when the file is opened. Doing that requires a UI
rendering engine, which is unlikely ever to be found in xlwt.
Cheers,
John
>
> Many thanks !
>
> >
>
>
Dargoan
I looked for keyword "zoom" in this google group, and actually, I
managed to put some zoom in my file, for all worksheets!
I used :
wb = Workbook(encoding="utf-8")
ws = wb.add_sheet(mySheetName)
ws.normal_magn=85
to obtain a 85% zoom in my worksheet.
Note that, for some reason, I don't have the file
zoom_magnification.py in the examples folder.
Best regards
John Machin
>
> Note that, for some reason, I don't have the file
> zoom_magnification.py in the examples folder.
How did you install xlwt, and where did you install xlwt?
John Yeung
>
> Q2:
> I'd like some of my columns to adjust their width automatically. Same
> question: does xlwt permit that and how?
I think John Machin probably hates that I've done this, and hates more
that I mention it when people ask, but I've gathered approximate
widths for common characters in Arial 10 (most people's default Excel
font) and provided it in the arial10.py file in the files section of
this group, so you can build your own autofit routines. (I included a
very rudimentary one in arial10.py.) The process is quite ugly and
slow: You have to calculate the width of each cell as you're writing
it, keeping track of the maximum width and using that to set the
column width after you have finished writing all the cells in that
column.
Depending on the data being fitted and the formatting you're using, it
can be much trickier and more error-prone than it sounds. If your
needs are complex (using formulas, for example) then it becomes
impossible or close to it. At some point, it's simpler, easier, and
faster to just use Excel itself to do this task (it can be controlled
programmatically by various means, including Python using COM).
John Y.
John Machin
> On Fri, Nov 13, 2009 at 7:27 AM, Dargoan <johan.c...@gmail.com> wrote:
>> Q2:
>> I'd like some of my columns to adjust their width automatically. Same
>> question: does xlwt permit that and how?
>
> I think John Machin probably hates that I've done this,
You think incorrectly. It's a brave, noble, heroic effort. But
misdirected IMHO. "C'est magnifique, mais ce n'est pas la guerre."
> and hates more
> that I mention it when people ask,
Not at all. I do regret that people don't search for previous discussion.
> but I've gathered approximate
> widths for common characters in Arial 10 (most people's default Excel
> font) and provided it in the arial10.py file in the files section of
> this group, so you can build your own autofit routines. (I included a
> very rudimentary one in arial10.py.) The process is quite ugly and
> slow: You have to calculate the width of each cell as you're writing
> it, keeping track of the maximum width and using that to set the
> column width after you have finished writing all the cells in that
> column.
>
> Depending on the data being fitted and the formatting you're using, it
> can be much trickier and more error-prone than it sounds. If your
> needs are complex (using formulas, for example) then it becomes
> impossible or close to it. At some point, it's simpler, easier, and
> faster to just use Excel itself to do this task (it can be controlled
> programmatically by various means, including Python using COM).
Or Python using pyuno to drive OpenOffice ...
Cheers,
John