自动化办公第一个脚本（Excel统计数据）xlrd and copy

1.我的思路

有一个可以汇总的表格---->在表格基础上先复制一份文件---->数据填写，汇总笔记，并且在写一个sheet，叫价钱汇总表格---->保存文件

2.执行文件

（1）自制一个简单表格

 （2）遇到问题

xlrd.biffh.XLRDError: Excel xlsx file; not supported

版本问题 ：pip uninstall xlrd,pip install xlrd==1.2.0

AttributeError: 'ElementTree' object has no attribute 'getiterator'

还未解决

import xlrd
from xlutils.copy import copy


def read_data():
  wb = xlrd.open_workbook('./xl/sum_data.xlsx')
  sh = wb.sheet_by_index(0)
  fen_type = {}    # {a:110,b:300}
  count_price = []  # [1,2,3,4,5,6]


  for r in range(sh.nrows):
    count = sh.cell_value(r,3) * sh.cell_value(r,4)
    count_price.append(count)
    key = sh.cell_value(r,0)
    if fen_type.get(key):
      fen_type[key] += count
    else:
      fen_type[key] = count
  return fen_type,count_price # 各分类的总价值, 每个单品的总价值


def save(fen,count):
  wb = xlrd.open_workbook('./base_data/data01.xlsx')
  sh_t = wb.sheet_by_index(0)
  wb2 = copy(wb)
  sh = wb2.get_sheet(0)
  for r in range(sh_t.nrows):
    sh.write(r,sh_t.ncols,count[r])
  
  sh2 = wb2.add_sheet('汇总的数据')
  for i,key in enumerate(fen.keys()):
    sh2.write(i,0,key)
    sh2.write(i,1,fen.get(key))
  wb2.save('./create_data/05_汇总数据.xlsx')


if __name__ == "__main__":
  f,c = read_data()
  save(f,c)