读取Excel之后,空格转成空字符串,所有值转成字符串并且去掉前后空白字符
def read_data(filename):
data = read_excel(filename, sheet_name='Sheet1', usecols='d,e,f', header=None, keep_default_na=False).applymap(lambda x: str(x).strip())
return tuple(tuple(x) for x in data.values)