python 直接存入Excel表格

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

docment 为list对象 大致格式如下

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

存入Excel的样式如下：

1 , 2

3, 4