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

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)
```

补位吧

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')

你行列弄反了吧。。。

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")

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