import os from ConfigHelper import ConfigHelper import xlrd import json import time import re configData = ConfigHelper.load() DMS_data_path = configData["path"] OutPath = configData["OutPath"] filelist = os.listdir(DMS_data_path) names = [] col_data = [] returnData = {} for file in filelist: workbook = xlrd.open_workbook(DMS_data_path + '/' + file) names = workbook.sheet_names() for name in names: if name == '330_340': worksheet = workbook.sheet_by_name(name) nrows = worksheet.nrows ncols = worksheet.ncols for i in range(16): col_values = worksheet.col_values(i) col_value = col_values[2:] # print(col_value) col_data.append(col_value) newdatas = [] for data in col_data[8:16]: