def readTable(self,tablename): data = xlrd.open_workbook(self.excelpath) table = data.sheet_by_name(tablename) nrows = table.nrows ncols = table.ncols header = table.row_values(0) tabledata = [] i = 1 while i < nrows: rdata = table.row_values(i) if rdata[0]: if isinstance(rdata[0],float): rdata[0] = int(rdata[0]) j = 0 row = {} while j <len(header): row.setdefault(header[j],rdata[j]) j = j+1 tabledata.append(row) i=i+1 return tabledata
def readTable(self, tablename): data = xlrd.open_workbook(self.excelpath) table = data.sheet_by_name(tablename) nrows = table.nrows ncols = table.ncols header = table.row_values(0) tabledata = [] i = 1 while i < nrows: rdata = table.row_values(i) if rdata[0]: if isinstance(rdata[0], float): rdata[0] = int(rdata[0]) j = 0 row = {} while j < len(header): row.setdefault(header[j], rdata[j]) j = j + 1 tabledata.append(row) i = i + 1 return tabledata
def readTables(self,tablesname): tablesdata = {} for tablename in tablesname: table = self.data.sheet_by_name(tablename) nrows = table.nrows ncols = table.ncols header = table.row_values(0) tabledata = [] i = 1 while i < nrows: rdata = table.row_values(i) if rdata[0]: if isinstance(rdata[0],float): rdata[0] = int(rdata[0]) j = 0 row = {} while j <len(header): row.setdefault(header[j],rdata[j]) j = j+1 tabledata.append(row) i=i+1 tablesdata.setdefault(tablename,tabledata) return tablesdata