pandas 读取excel

 

先安装包

pip install pandas
pip install openpyxl

　　

代码实现

import pandas as pd
data = pd.read_excel("test.xlsx")
print(data.values.tolist())
print(data.to_numpy())