5.6 Split by row - split multiple cards to make one card generate one file
There is a multi-card style table Cards.xlsx as follows:
Now we need to split it to make one card generate one file, with person’s name as the file name. The splitting results are as follows:
1 . Create an empty card-style file Card.xlsx, as the initial file format:
2 . Script:
A1: Open the empty card-style template Card.xlsx.
A2: Open the multi-card style table Cards.xlsx.
A3: List the column number of the cells to be read.
B3: List the row number of the cells to be read.
A4: Piece together the cell names of the first card.
B5: Piece together the cell names of the current card, and read the data in it.
B6: Exit loop if cards have been read.
B7: Loop through A4 and write the data in B5 into A1 one by one.
B8: Write A1 to the file named after the current card.
B9: Plus 8 after row number, because one card has 8 rows.