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 &