Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Loop-help for a newbie?
#20
openpyxl except both ways to define the range to merge
, i.e. string or explicit start/erd row/col as integers

from the docs
>>> from openpyxl.workbook import Workbook
>>>
>>> wb = Workbook()
>>> ws = wb.active
>>>
>>> ws.merge_cells('A2:D2')
>>> ws.unmerge_cells('A2:D2')
>>>
>>> # or equivalently
>>> ws.merge_cells(start_row=2, start_column=1, end_row=4, end_column=4)
>>> ws.unmerge_cells(start_row=2, start_column=1, end_row=4, end_column=4)
so if you face problem, it's somewhere else, not the way merge cells are defined
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