import openpyxl
def get_book_values(path):
"""获取excel表数据"""
wb = openpyxl.load_workbook(path)
ws = wb[wb.sheetnames[0]]
return [list(i) for i in ws.values][1:]
python获取excel表格的数据
最新推荐文章于 2024-04-12 11:38:35 发布
import openpyxl
def get_book_values(path):
"""获取excel表数据"""
wb = openpyxl.load_workbook(path)
ws = wb[wb.sheetnames[0]]
return [list(i) for i in ws.values][1:]