python嵌套列表

 

从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()