python 读取excel 数据，并转为dict

2021-03-21 00:25

阅读：551

标签：col 转换 excel img values device ret strftime 实例化

代码如下

# -*- coding:utf-8 -*-
import xlrd
from datetime import datetime
from xlrd import xldate_as_tuple

class XlrdOp:
    def __init__(self, fileName=None):
        if fileName is None:
            return
        self.readbook = xlrd.open_workbook(fileName) #打开Excel文件，实例化为readbook

    def get_sheet_names(self):
        return self.readbook.sheet_names()

    def get_dict(self):
        data = {}
        for i in self.get_sheet_names():
            table = self.readbook.sheet_by_name(i)
            row_num = table.nrows
            col_num = table.ncols
            s = []
            key = table.row_values(0)  # 这是第一行数据，作为字典的key值
            if row_num