<p>给你:</p>
<p>=^….^=</p>
<pre><code>import openpyxl
from openpyxl import Workbook
# load data
raw_data = openpyxl.load_workbook('data.xlsx')
select_sheet = raw_data['Sheet1']
# collect data from rows
valid_row = []
data = []
for row in select_sheet.iter_rows(max_row=select_sheet.max_row, max_col=select_sheet.max_column):
# get cell values
row_data = [cell.value for cell in row]
# handle merged cells
new_row_data = [0]*select_sheet.max_column
if None in row_data:
new_row_data[0] = valid_row[0]
new_row_data[1] = valid_row[1]
new_row_data[2] = row_data[2]
new_row_data[3] = row_data[3]
data.append(new_row_data)
else:
data.append(row_data)
# storage valid row
if None not in row_data:
valid_row = row_data
# save data
book = Workbook()
new_sheet = book.active
for row in data:
new_sheet.append(row)
book.save('new_data.xlsx')
</code></pre>
<p>输入:</p>
^{pr2}$
<p>输出:</p>
<pre><code> 0 1 2 3
0 B 212 80 1.2
1 C 212 80 1.3
2 D B60 60 1.4
3 D B60 60 1.5
4 E 212 80 1.6
5 E 212 60 1.7
6 E 212 60 1.8
</code></pre>