import pandas as pd
# 读取excel数据
df = pd.read_excel('D:\pythonp\z_9columns.xlsx')
# 输出列标题
rownames = df.columns.values
# 输出全部数据(不包含行标题,列标题)
data = df.values
参考:
https://www.cnblogs.com/liulinghua90/p/9935642.html
import pandas as pd
# 读取excel数据
df = pd.read_excel('D:\pythonp\z_9columns.xlsx')
# 输出列标题
rownames = df.columns.values
# 输出全部数据(不包含行标题,列标题)
data = df.values
参考:
https://www.cnblogs.com/liulinghua90/p/9935642.html