Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Loop-help for a newbie?
#25
the way you did it you don't need the first 2 lines. However better do

for row in (1, 4):
    sheet.merge_cells(start_row=row, start_column=1, end_row=row, end_column=9)

columns = [(col, col+1) for col in range(2, 9, 2)]
for row in [2, 3, 5, 8, 11, 12, 13, 17, 18, 23, 25, 29, 30, 31, 32, 40, 101]:
    for col1, col2 in columns:
        sheet.merge_cells(start_row=row, start_column=col1, end_row=row, end_column=col2)

for row in (1, 4):
    sheet.merge_cells(start_row=row, start_column=2, end_row=row, end_column=3)
    sheet.merge_cells(start_row=row, start_column=6, end_row=row, end_column=9)
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Messages In This Thread
Loop-help for a newbie? - by pcsailor - Aug-29-2018, 04:14 AM
RE: Loop-help for a newbie? - by perfringo - Aug-29-2018, 04:59 AM
RE: Loop-help for a newbie? - by pcsailor - Aug-29-2018, 05:09 AM
RE: Loop-help for a newbie? - by perfringo - Aug-29-2018, 05:45 AM
RE: Loop-help for a newbie? - by buran - Aug-29-2018, 05:48 AM
RE: Loop-help for a newbie? - by perfringo - Aug-29-2018, 06:05 AM
RE: Loop-help for a newbie? - by buran - Aug-29-2018, 06:20 AM
RE: Loop-help for a newbie? - by perfringo - Aug-29-2018, 07:26 AM
RE: Loop-help for a newbie? - by pcsailor - Aug-30-2018, 04:04 AM
RE: Loop-help for a newbie? - by pcsailor - Aug-31-2018, 04:09 AM
RE: Loop-help for a newbie? - by buran - Aug-31-2018, 04:11 AM
RE: Loop-help for a newbie? - by pcsailor - Aug-31-2018, 04:44 AM
RE: Loop-help for a newbie? - by buran - Aug-31-2018, 04:54 AM
RE: Loop-help for a newbie? - by pcsailor - Aug-31-2018, 05:17 AM
RE: Loop-help for a newbie? - by pcsailor - Aug-31-2018, 10:03 AM
RE: Loop-help for a newbie? - by buran - Aug-31-2018, 11:32 AM
RE: Loop-help for a newbie? - by pcsailor - Sep-01-2018, 04:32 AM
RE: Loop-help for a newbie? - by buran - Sep-01-2018, 05:18 AM
RE: Loop-help for a newbie? - by perfringo - Sep-01-2018, 05:25 AM
RE: Loop-help for a newbie? - by buran - Sep-01-2018, 05:34 AM
RE: Loop-help for a newbie? - by pcsailor - Sep-01-2018, 07:28 AM
RE: Loop-help for a newbie? - by pcsailor - Sep-02-2018, 02:42 AM
RE: Loop-help for a newbie? - by buran - Sep-02-2018, 05:46 AM
RE: Loop-help for a newbie? - by perfringo - Sep-02-2018, 07:39 AM
RE: Loop-help for a newbie? - by pcsailor - Sep-02-2018, 07:00 AM
RE: Loop-help for a newbie? - by buran - Sep-02-2018, 07:06 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  newbie while loop error: IndexError: list assignment index out of range msa969 3 75,111 Mar-31-2017, 12:24 PM
Last Post: msa969

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020