python操作excel并封装成exe文件_python excel和yaml文件的读取封装

excel

import os

import xlrd

PATH = lambda p: os.path.abspath(

os.path.join(os.path.dirname(__file__), p)

)

class ExcelData:

def __init__(self, file, sheet="sheet1", title=True):

# 判断文件存在不存在

if os.path.isfile(PATH(file)):

self.file = PATH(file)

self.sheet = sheet

self.title = title

self.data = list()

self.workbook = xlrd.open_workbook(self.file)

else:

raise FileNotFoundError("文件不存在")

@property

def get_data(self):

"""获取表格数据"""

if not self.data:

# 判断表单名称

if type(self.sheet) not in [int, str]:

raise Exception("表单名称类型错误")

else:

if type(self.sheet) == int:

book = self.workbook.sheet_by_index(self.sheet)

else:

book &