Behind-the-scenes export excel merge cells, serial number column on the solution

CodePudding user response:

Don't define the serial number column i++

CodePudding user response:

Normally use i++ is no problem, but the cell merge it merged several columns order wrong this kind of situation

CodePudding user response:

Program automatic merge cells?
Two schemes, one is, in the process of the merger, each generated a merge cells, counter variable since a, the counter variable is the serial number,
Another is that when all cells are merger is completed, unified traverse again after the merger of a cell, as the traversal process, the serial number is the access to this a list of the number of cells,

CodePudding user response:

The number of traverse cell

CodePudding user response:

I use the first way of three grams of oil