Re: Hiding same level rows in xlwt

391 views
Skip to first unread message

John Machin

unread,
Mar 21, 2013, 4:04:27 PM3/21/13
to python-excel


On Mar 21, 6:04 am, rohit kumar <rohit.im...@gmail.com> wrote:
> Is there a way in xlwt to write a row, but have it hidden by
> default?

Rows are shown by default. I don't understand what you mean by having
a specific row hidden by default

If you mean "How do I hide a row?":

import xlwt
wb = xlwt.Workbook()
ws = wb.add_sheet('Sheet1')
for rowx in range(30):
ws.write(rowx, 0, rowx)
for rowx in range(20, 25):
ws.row(rowx).hidden = True
wb.save('hide_rows.xls')

rohit kumar

unread,
Mar 22, 2013, 1:12:38 AM3/22/13
to python...@googlegroups.com


On Friday, March 22, 2013 1:34:27 AM UTC+5:30, John Machin wrote:


On Mar 21, 6:04 am, rohit kumar <rohit.im...@gmail.com> wrote:
> Is there a way in xlwt to write a row, but have it hidden by
> default?

Rows are shown by default. I don't understand what you mean by having
a specific row hidden by default

[Rohit] Thanks for reply John. I wanted to know that after arranging rows in levels ( or grouping them),
is it possible to shrink the level using script only. Manually I have to click on "-" symbol to shrink the group.
 
Reply all
Reply to author
Forward
0 new messages