python 读取xlsx

使用openpyxl

import openpyxl as opl
import numpy as np
#from openpyxl import load_workbook
#import openpyxl
#import os
import xlwings

data = opl.load_workbook('wind(月度).xlsx')#当前文件夹
table=data.get_sheet_by_name('国内生产总值(季)')
sr_incre=table.cell(597,1)
sr_incre.value

参考

https://www.cnblogs.com/crazymagic/articles/9752287.html

pandas库读取

参考

https://www.cnblogs.com/huny/p/13054389.html

https://www.gxlcms.com/python-364959.html

8、查看数据表的值(array 行-2，列-1)：

1. df.values

Python之Array数组切片

https://blog.youkuaiyun.com/yangwangnndd/article/details/89636128