Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Loop-help for a newbie?
#18
for row in (1, 4):
    sheet.merge_cells(start_row=row, start_column=1, end_row=row, end_column=9) # Note:

for row in (2, 3, 5):
    for scol, ecol in zip(range(2, 9, 2), range(3, 10, 2)):
        sheet.merge_cells(start_row=row, start_column=scol, end_row=row, end_column=ecol)
note that f-string is just a way to create the string. It should not interfere with openpyxl. Here is the example from post#7 with str.format method
for row in range(10, 13):
    for col1, col2 in zip('BDFH', 'CEGI'):
        print('{0}{2}:{1}{2}'.format(col1, col2, i))
if you have issue, show us what the problem is, pretty sure it's not the f-string. If openpyxl accept string as input to sheet.merge it does not matter how you construct the string or even if you just pass a variable.
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,240 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