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]:
