我正在使用此代码加载 xslx 文件,并且收到超过 1k 的 1 行。有谁知道如何处理?
import openpyxl
import pandas as pd
wb= openpyxl.load_workbook(r'path')
df = pd.DataFrame(wb)
print(df)
结果: 0 (, , , ,
[1 行 x 1452 列]
直接从这里获取代码:
https://www.soudegesu.com/en/post/python/pandas-with-openpyxl/
import openpyxl
import pandas as pd
wb = openpyxl.load_workbook(r'path.xlsx')
ws = wb["Sheet1"]
data = ws.values
columns = next(data)[0:]
df = pd.DataFrame(data, columns=columns)
print(df)
输出:
Column_A Column_B
0 100 Abc
1 200 Def
2 300 Ghj
3 400 Ijk
如果你想遍历多个工作表,你可以像这样修改它:
import openpyxl
import pandas as pd
wb = openpyxl.load_workbook(r'path.xlsx')
for ws in wb.sheetnames:
print("Name of sheet: ", ws)
ws = wb[ws]
data = ws.values
columns = next(data)[0:]
df = pd.DataFrame(data, columns=columns)
print(df)
输出:
Name of sheet: Sheet1
Column_A Column_B
0 100 Abc
1 200 Def
2 300 Ghj
3 400 Ijk
Name of sheet: Sheet2
Column_A Column_B
0 500 lmn
1 600 opq
2 700 rst
3 800 uvw
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句