从excel读取一行信息添加到一个临时列表,最后将所有行的列表添加到一个大列表。
源码:
import xlrd,reclass Info(): def read_info(self): data = xlrd.open_workbook('tmp_info.xlsx') table = data.sheets()[0] # row_val = table.row_values(0) info_list = [] tmp_list = [] for i in range(1,table.nrows): tmp = table.row_values(i) for j in range(3): val = re.sub(' ','',tmp[j].encode('utf-8')) val = re.sub('#','',val) if len(tmp[2]) > 50: val = re.sub('_','',val) tmp_list.append(val) info_list.append(tmp_list) tmp_list = [] # must clear it return info_listt = Info()print t.read_info()