python 直接存入Excel表格

1     def write_excels(self, document):
2         outwb = openpyxl.Workbook()
3         outws = outwb.create_sheet(index=0)
4         for y, docs in enumerate(document):
5             key = [doc for doc in docs]
6             for x, ky in enumerate(key):
7                 outws.cell(y + 1, x + 1).value = docs[ky]
8         outwb.save("xxx.xlsx")

1 docment = [{"a":1,"b":2},{"a":3,"b":4}]