def load_all_lines(): # 读取txt # 返回所有曲线的数据 # 数据类型为np.array类型 all_tds = Td.all() lines = [] for i in range(len(all_tds)): line = [] arr_rd = [] arr_td = [] td = all_tds[i] td = td.json() title = td.get('td', '') list_rD = td.get('list_rD', '') list_TD = td.get('list_TD', '') arr_rd = str_to_float_arr(list_rD) arr_td = str_to_float_arr(list_TD) # return arr_rd, arr_td # 将曲线数据转化为np.array类型 arr_rd = np.array(arr_rd) arr_td = np.array(arr_td) # 将曲线 td list_rD list_TD 数据放到line中 line.append(title) line.append(arr_rd) line.append(arr_td) lines.append(line) return lines
def delete_all(): # 删除所有的td信息 # 1.返回所有的td类 # 2.根据td类的id 删除td类(id是不重复的) tds = Td.all() rs = [] for t in tds: d = Td.delete(t.id) rs.append(d) log("删除了({})个td, 所有的td= ({})".format(len(tds), rs)) return "删除了({})个td, 所有的td= ({})".format(len(tds), rs) pass
def write_xlsx(): # 1. 加载json文件 # 2. 将json文件写入到.xlsx中 # 创建一个新的工作表簿 all_tds = Td.all() # log('all_td ({})'.format(all_tds)) workbook = openpyxl.Workbook() # 获取表格的默认工作表 sheet = workbook.active # 设置工作表的凑题 sheet.title = '三条tD曲线数据' # 写入表头与内容 column = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' j = 0 for i in range(len(all_tds)): arr_rd = [] arr_td = [] td = all_tds[i] td = td.json() tp = column[j] + str(1) rdp = column[j] + str(2) tdp = column[j + 1] + str(2) title = td.get('td', '') title = 'td =' + title list_rD = td.get('list_rD', '') list_TD = td.get('list_TD', '') arr_rd = str_to_float_arr(list_rD) arr_td = str_to_float_arr(list_TD) # 将数据写入sheet write_one_td(wb=sheet, rd=arr_rd, td=arr_td, col=j + 1, titl=title) j += 2 # log('arr_rd({}) arr_td({})'.format(arr_rd, arr_td), i) # 保存到 .xlsx 文件中 workbook.save('({})条曲线数据 .xlsx'.format(len(all_tds)))