请教各位 openpyxl 模块怎样方法才能把不同长度的 list 保存 excel

[Ne]

data1 = [11, 22]

data2 = [33, 44]

data3 = [55, 66, 77, 88]

保存成下面的以列的 excel

从网上找了很多资料也没有教，openpyxl 的官网教的全是同长度的。是很少人用这模块吗。

[fbichijing]

Pandas 倒省事一些，openpyxl 思路应该也大同小异吧。

```python
import pandas as pd

data1 = [11, 22]
data2 = [33, 44]
data3 = [55, 66, 77, 88]

df = pd.DataFrame([data1, data2, data3])
df = df.T
df.to_excel('test.xlsx', index=False, header=False)
```

[kkeep]

补位吧

[mieq]

import openpyxl
import itertools

data1 = [11, 22]
data2 = [33, 44]
data3 = [55, 66, 77, 88]

wb = openpyxl.Workbook()
ws = wb.active

data = itertools.zip_longest(data1, data2, data3)

for row in data:
ws.append(list(row))

wb.save('test.xlsx')

[kkbblzq]

你行列弄反了吧。。。

from openpyxl import Workbook

if __name__ == "__main__":
data = [
[11,22],
[33,44],
[55,66,77,88]
]

wb = Workbook()
sheet = wb.active
for x in data:
sheet.append(x)
wb.save("test.xlsx")

[Ne]

@mieq 感谢，按你的方法可行。