下载:
pip install openpyxl
workbokk :工作薄
sheetname :工作表
cell :单元格
步骤:
from openpyxl import load_workbook
wb = load_workbook('excel文件的路径')
sh = list(wb.sheetnames)
sh = wb.active
sh = wb['工作表名称']
all_data = list(sh.value)
print("获取第2行,第1列的值:",sh.cell(2,1).value)
print('获取第2行,第1列的值'.sh.cell('A2').value)
wb.save("excel的路径")
from openpyxl import load_workbook
class DataFromExcel:
def __init__(self,excel_path,sheetname):
"""初始化excel的路径,工作表的名字"""
try:
wb = load_workbook(excel_path)
self.sh = wb[sheetname]
except:
print("您提供的excel的路径无效 或 工作表的名称有误")
raise
def read_all_data(self):
"""获取excel中所有的数据,处理为列表嵌套 字典的格式"""
all_data = list(self.sh.values)
keys = all_data[0]
data_list = []
for row_value in all_data[1:]:
new_dict = dict(zip(keys,row_value))
data_list.append(new_dict)
return data_list
if __name__ == '__main__':
D = DataFromExcel("excel的路径","excel的工作表名称")
all_data = D.read_all_data()
print(all_data)