擅长:python、mysql、java
<p>此代码将读取工作表,如同它是csv一样,并使用第一行作为列标题在<code>result</code>中填充字典列表。</p>
<pre><code> from openpyxl import load_workbook
result = []
wb = load_workbook(filename=file_name)
sheet = wb.active
col_count = sheet.max_column
column_names = {}
for c in range(1, col_count):
heading = sheet.cell(row=1, column=c).value
if not heading:
col_count = c
break
column_names[c] = heading
for r, row_cells in enumerate(sheet.iter_rows(2), 2):
row = {}
for c in range(1, col_count):
value = sheet.cell(row=r, column=c).value
if type(value) == datetime:
value = value.strftime('%Y-%m-%d')
row[column_names[c]] = value
result.append(row)
</code></pre>