通过python操作excel

• 所依赖的库：
  openpyxl主要是这个、xlrd、xlwt
  
• 测试
  excel_test2.py

import os
from openpyxl import load_workbook

file_path = os.path.join("data.xlsx")
wb = load_workbook(file_path)
for name in wb.sheetnames:
    sheet = wb[name]
    total = 0
    for row in sheet.iter_rows(min_row=2):
        cell = row[1]
        total = total + cell._value
    print(sheet.title,total)

• 运行