def init(self): self.excel = Excel() path = 'C:/Users/yyw/Desktop/study/환시스/lottesuper.xlsx' self.excel.get_execel(path) self.excel.get_sheet('Sheet1') self.total = 0.0 self.i = 1
def test_read_header(self): """Lectura de encabezados de archivo excel""" xl = Excel() data = xl.read_file("samplexl.xlsx", "datosm") headers = ("Nombre", "App", "Apm") self.assertEqual(xl.get_headers(), headers)
def goto_find(self): print('++++++++++++++++++++\n', 'debug', '\n') self.tableWidget.setColumnCount(3) self.tableWidget.setRowCount(2) # j = 0 # 第几行(从0开始) # i = 0 # 第几列(从0开始) # Value = "test" # 内容 #self.tableWidget.setItem(i, j, QTableWidgetItem(Value)) # 设置j行i列的内容为Value #excel.py处理单个sheet有内存溢出bug,暂时直接用 str = self.find_text.toPlainText() #获取text的文本内容 print(str) excel = Excel(file_path) excel.read_sheet_data(str) #print(list) #self.log_text.setPlainText(list) #self.log_text.setPlainText(content) #print(list) #self.log_text.append(self,list) #for i in range(list): #self.tableWidget.setItem(i,0,QTableWidgetItem(list[i])) #self.log_text.append(self,ord_list) # for i in range(len(list)): # for j in range(len(list)): # self.tableWidget.setColumnWidth(j, 80) # 设置j列的宽度 #self.tableWidget.setRowHeight(i, 50) # 设置i行的高度 # self.tableWidget.verticalHeader().setVisible(False) # 隐藏垂直表头 # self.tableWidget.horizontalHeader().setVisible(False) # 隐藏水平表头 print('\n', 'end', '\n++++++++++++++++++++')
def __init__(self, log_dir, process_names=[]): os.chdir(log_dir) if process_names is None: process_names = [] self.process_names = process_names for device_dir in self.list_device_dirs(): logger.info('create report for %s' % device_dir) core_num = 1 try: with open(os.path.join(device_dir, 'corenum.txt'), 'r') as f: core_num = int(f.read()) except: pass file_names = self.filter_file_names(device_dir) logger.debug('%s' % file_names) if file_names: book_name = '%s-%s.xlsx' % (device_dir, datetime.now().strftime('%Y.%m.%d-%H.%M.%S')) excel = Excel(book_name) for file_name in file_names: name = file_name.split('.')[0] info = INFO_CONFIG.get(name)(device_dir, file_name, process_names, core_num) for sheet in info.get_sheet_list(): logger.info('add sheet %s' % sheet[0]) excel.add_sheet(*sheet) logger.info('wait to save %s' % book_name) excel.save()
def on_clicked_pushButton_3(self): if self.senderList: e = Excel() if self.senderList: colnum = len(self.senderList) for i in range(len(self.senderList)): e.setRangeFormat('sheet1', 1, i + 1, colnum, i + 1, '@') if self.senderList: for i, row in enumerate(self.senderList): for j, cell in enumerate(row): e.setCell('sheet1', i + 1, j + 1, str(cell)) desktop = os.path.join(os.path.expanduser("~"), 'Desktop') savename = '发件人信息' + time.strftime('%m%d', time.localtime()) savepath = desktop + '\\' + savename fname = QFileDialog.getSaveFileName(self, '保存', savepath, '.xlxs') fpath = os.path.abspath(fname[0]) try: e.save(fpath) except Exception as e: self.showMsg('错误!', '保存时发生错误:\n {}'.format(e.args)) finally: e.close() else: self.showMsg('错误!', '请先上传表格并完成转换。')
def main(): parser = argparse.ArgumentParser(description='XPlan import/export conditions') parser.add_argument('-i', '--import-zip', action='store_true', help='Import page.zip and generate excel file.') parser.add_argument('-o', '--export-zip', action='store_true', help='Export excel to page.zip') if len(sys.argv) == 1: parser.print_help() sys.exit(1) args = parser.parse_args() if args.import_zip and args.export_zip: parser.print_help() sys.exit(1) if args.import_zip: p = XPlan() if p.load_zip(): x = Excel() p.extract_objects() p.generate_obj_file() x.generate_xls_file(p.get_xplan_object()) logging.info("[Complete]\n\n") if args.export_zip: p = XPlan() x = Excel() p.generate_zip_file(x.get_xplan_object()) logging.info("[Complete]\n\n")
def init(self): self.excel=Excel() path='C:/Users/yyw/Desktop/study/환시스/homepluscenter.xlsx' self.excel.get_execel(path) self.excel.get_sheet('Sheet1') self.n =1 self.i=0
def test_write_file(self): """Archivo de excel generado de manera correcta""" xl = Excel() data = [["No Cliente", "Nombre"], ["1948393849383", "asdfasdf"], ["853939383938293", "asasdfasdfasdf"]] xl.write_file("prueba1", "result-val", data) self.assertTrue(True)
def run(self): excel = Excel(self.xls_filename) xml = XmlData(self.func_relation_id) # xml_data = xml.get_func_xml() xml_data = xml.test() excel.write_to_xls(xml_data)
def test_read_data(self): """La información es correcta""" xl = Excel() data = xl.read_file("samplexl.xlsx", "datosm") data_expected = [("Nombre", "App", "Apm"), ("X", "T", "G"), ("E", "A", "E")] self.assertEqual(data, data_expected)
class TestExcel(unittest.TestCase): def setUp(self): q = Query() fifth_third_transactions = q.get_transactions_by_range('53',5,6) self.e = Excel(fifth_third_transactions,PATH) def test_grouped_transactions(self): self.e.grouped_transactions()
def find_item_source_fourth_step_edit_excel(self,path,sheet): self.excel=Excel() self.excel.get_execel(path) self.excel.get_sheet(sheet) for i in range(len(self.list_comp)): self.excel.edit_excel_data(i+1,1,self.list_name[i]) self.excel.edit_excel_data(i+1,2,self.list_comp[i]) self.excel.edit_excel_data(i+1,3,self.list_number[i]) self.excel.save_excel_data()
def __init__(self): self.item_name='' self.category ='' self.driver = webdriver.Chrome('C:/chromedriver/chromedriver.exe') self.num_3=0 #num_3 self.num_2=28 self.num_1=8 self.excel=Excel() self.three_division=[''] self.two_division=[''] self.one_division=['']
def init(self): self.excel = Excel() path = 'C:/Users/yyw/Desktop/study/환시스/homepluscenter.xlsx' self.excel.get_execel(path) self.excel.get_sheet('Sheet1') self.excel1 = Excel() path = 'C:/Users/yyw/Desktop/study/환시스/resulthomeplus.xlsx' self.excel1.get_execel(path) self.excel1.get_sheet('Sheet1') self.y = 1 self.z = [] self.v = [] self.map_2 = folium.Map(location=[37.509668, 126.887726], zoom_start=7)
def goto_allsheetname(self): print('++++++++++++++++++++\n', 'debug', '\n') str = "path:" + file_path + '\n' excel = Excel(file_path) # 创建实例化 print('all sheets') list = [] list = excel.read_all_sheetnames(file_path) print('sheet names:', list) print('\n', 'end', '\n++++++++++++++++++++') str += "all sheet\n" + '; '.join(list) self.log_text.setPlainText(str)
def init(self): self.excel = Excel() path = 'C:/Users/yyw/Desktop/study/환시스/emart.xlsx' self.excel.get_execel(path) self.excel.get_sheet('Sheet1') self.n = 3 self.driver = webdriver.Chrome('C:/chromedriver/chromedriver.exe') self.driver.get('https://store.emart.com/branch/list.do') self.header = { 'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/76.0.3809.132 Safari/537.36' } self.i = 405 self.i1 = 406
def main(): filename = "fatture.xlsx" if len(sys.argv) > 1: filename = sys.argv[1] if not check_file(filename): return excel = Excel(filename) openssl = OpenSSL("data/SanitelCF.cer") configurazione = excel.configurazione() try: while True: try: riga = excel.nuova_riga() except ValueError as e: print(e) continue if not riga: break if riga.get("protocollo"): # riga con già il numero di protocollo continue mapped = mapping(configurazione, riga, openssl) result = send_data(mapped) print("%s - %s" % (mapped["numDocumento"], result[1])) excel.protocollo(result[1]) finally: excel.save()
def file_open(self): # open file open dialog path, _ = QFileDialog.getOpenFileName( self, "Open file", "", "Excel documents (*.xlsx);All files (*.*)") if (not path.endswith("xlsx")): QMessageBox.about(self, "Error", "Must choose excel file (.xlsx)") return # process excel file ( excel.py ) self.xls = Excel(path) # Get all the sheet names that hold User stories and Test Cases self.comboBoxUS.addItems(self.xls.get_US_names())
def main(): base_url = "https://google.com/search?q={}&num={}" nums = 50 # desktop user-agent USER_AGENT = "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.72 Safari/537.36" # mobile user-agent MOBILE_USER_AGENT = "Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36" proxies = { "http": "http://127.0.0.1:1081", "https": "http://127.0.0.1:1081", "socks5": "socks5://127.0.0.1:1081" } browser = Driver() browser.init_dirver() excel = Excel(file_name="result.xlsx") keywords = [ "self-clarity scale", "self-clarification scale", "self-esteem scale", "自尊量表", "自我概念清晰度量表" ] results = {} for keyword in keywords: print("[+]: searching {}".format(keyword)) keyword = keyword.replace(' ', '+') url = base_url.format(keyword, nums) browser.get_html_source(url=url) soup = BeautifulSoup(browser.html, "html.parser") keyword_result = [] for g in soup.find_all('div', class_='g'): anchors = g.find_all('a') if anchors: link = anchors[0]['href'] title = g.find('h3').text item = {"title": title, "link": link} keyword_result.append(item) excel.write(sheet_name=keyword, data_array=[title, link]) results.update({keyword: keyword_result}) json.dumps(results)
def init(self): self.excel = Excel() path = 'C:/Users/yyw/Desktop/study/환시스/resultlotte.xlsx' self.excel.get_execel(path) self.excel.get_sheet('Sheet1') self.n = 2 self.m = 2 self.driver = webdriver.Chrome('C:/chromedriver/chromedriver.exe') self.header = { 'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/76.0.3809.132 Safari/537.36' } self.i = 1 self.q = 0
def init(self, item_url): self.excel = Excel() path = 'C:/Users/yyw/Desktop/study/환시스/homeplus.xlsx' self.excel.get_execel(path) self.excel.get_sheet('Sheet1') self.n = 3 self.m = 2 self.driver = webdriver.Chrome('C:/chromedriver/chromedriver.exe') self.driver.get(item_url) self.header = { 'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/76.0.3809.132 Safari/537.36' } self.i = 0 self.window_before = self.driver.window_handles[0]
def __init__(self, output: str, query: str = "") -> None: self.query: str = query self.page: int = 1 self.parsing: bool = True self.excel: Excel = Excel(output) self.session: requests.Session = requests.Session()
def on_gen_btn_clicked(self): if len(self.json) > 0: # print(os.path.join(self.targetEdit.text().strip(), "预决算.xls")) # if self.check_excel_is_open(os.path.join(self.targetEdit.text().strip().replace("/", "\\"), "预决算.xls")): # QMessageBox.information(self, "提示", ' Excel文件已经打开,请先关闭! ') # return excel_writer = Excel( os.path.join(self.targetEdit.text().strip().replace("/", "\\"), "预决算.xls"), self.sheet_name_list, self.json) try: excel_writer.write_excel() except: QMessageBox.information(self, "提示", ' 写入失败查看是否文件已经打开! ') return QMessageBox.information(self, "提示", ' Json信息写入Excel成功! ')
def excel(): """ Post an excel file and fetch it's configuration """ excel_file = request.files['file'] sheet = request.values.get('sheet') conditional_formatting = False if request.values.get( 'conditional_formatting') == 'false' else True excel = Excel(get_config(), excel_file._file, conditional_formatting=conditional_formatting) confluence = Confluence(get_config()) content = excel.parse(sheet=sheet) content['header'] = request.values.get('header') content['source'] = confluence.source_from_data( content.get('data', {}), header=content.get('header')) return json.dumps(content, default=json_serial)
class Work: def __init__(self): self.c=Crawl() self.e=Excel() def thread_it(self,func): # 创建线程 t = threading.Thread(target=func) # 守护线程 t.setDaemon(True) # 启动 t.start() def setUp(self): #pb.start() self.c.setUp() #pb.stop() def crawl(self): var.set('') start_row=int(start.get()) end_row=int(end.get()) list=self.e.get_title_list(start_row,end_row)#title_list print(list,flush=True) self.c.crawl(list) time.sleep(2) start.delete(0,tk.END) end.delete(0,tk.END) time.sleep(1) start.insert(0,end_row+1) end.insert(0,end_row+4) num=end_row-start_row+1 var.set('请输入'+str(num)+'个结果 ') #num_list=c.insert() #self.e.write_num(num_list) def insert(self): num=e.get() num_list=[int(i) for i in re.split('[,,]',num)] print(num_list,flush=True) self.e.write_num(num_list) e.delete(0,tk.END) var.set('数据已导入 ') def tearDown(self): self.c.tearDown()
def init(self): self.excel = Excel() path = 'C:/Users/yyw/Desktop/study/환시스/homepluscenter.xlsx' self.excel.get_execel(path) self.excel.get_sheet('Sheet1') self.excel1 = Excel() path = 'C:/Users/yyw/Desktop/study/환시스/homeplus.xlsx' self.excel1.get_execel(path) self.excel1.get_sheet('Sheet1') self.y = 1 self.y1 = 1 self.df = pd.DataFrame(columns=('latitude', 'longitude')) self.df1 = pd.DataFrame(columns=('latitude', 'longitude')) self.n = 0 self.n1 = 0
def main(): for path in get_xls_files(setting.work_dir()): excel = Excel(setting.work_dir() + path) data = get_data4json(excel) split_pre = path.find(SUFFIX) - 1 name = path[:split_pre] + ".json" write_json(name, data)
def init(self): self.excel=Excel() path='C:/Users/yyw/Desktop/study/환시스/homepluscenter.xlsx' self.excel.get_execel(path) self.excel.get_sheet('Sheet1') self.excel2=Excel() path='C:/Users/yyw/Desktop/study/환시스/emartcenter.xlsx' self.excel2.get_execel(path) self.excel2.get_sheet('Sheet1') self.n =1 self.m=2 self.driver = webdriver.Chrome('C:/chromedriver/chromedriver.exe') self.driver.get('https://map.naver.com/') self.header={'User-Agent':'Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/76.0.3809.132 Safari/537.36'} self.i=0 self.q=0 self.y2=5 self.y3=0
def output_to_excel(self): """Output the full event list to an excel file. Args: None Returns: None """ Excel(self).save()
def execution(type, count, item_type): sm = ScreenManager() rp = RechercheProcess() r = Item() sm.set_focus_by_window_name("Greenlamp") rp.search_multiple_item(type, count) items = r.generate_item_list(type) Excel(items, item_type)
def excelGen(): os.remove('data_dictionary/profiles.xlsx') #../../profiles.xlsx wb = Workbook() ws = wb.active ws['A1'] = '' wb.save('data_dictionary/profiles.xlsx') #../../profiles.xlsx for profile in ['community', 'collection', 'generic', 'thesis', 'oai_pmh', 'oai_etdms']: Excel(profile)
def output_to_excel(self): """Output the full event list to an Excel file. Author: KomorebiL Args: None Returns: None """ Excel(self).save()
def main(): browser = Driver() browser.init_dirver(headless=False) excel = Excel(file_name="result.xlsx") tb = Taobao(browser) keywords = ["Pico G2 4KS"] excel_title = ["名称", "价格", "月销量", "店铺", "地址", "商品链接", "店铺链接"] results = {} for keyword in keywords: print("[+]: searching {} ...".format(keyword)) keyword = keyword.replace(' ', '+') excel.write(sheet_name=keyword, data_array=excel_title) tb.login() tb.search(keyword) results = tb.get_items() for item in results: item_data = [ item.name, item.price, item.sales, item.shop, item.location, item.links, item.shop_links ] excel.write(sheet_name=keyword, data_array=item_data)
def onButton_data(self, event): """ This method is fired when its corresponding button is pressed """ openDirDialog = wx.DirDialog(self.panel1, 'Choose input directory', '.', wx.DD_DEFAULT_STYLE | wx.DD_DIR_MUST_EXIST) # if openDirDialog.ShowModal() != wx.ID_CANCEL: # ---------------------------------------- # Get all data files # ---------------------------------------- patients = {} for filename in glob.glob(openDirDialog.GetPath() + os.sep + '*.txt'): file_content = AminoacidAnalyzes_file(filename) if file_content.patient not in patients: patients[file_content.patient] = Patient() patients[file_content.patient].add_data(file_content) # # ---------------------------------------- # Create result folder # ---------------------------------------- folder = ''.join((openDirDialog.GetPath(), os.sep, '..', os.sep, 'result', os.sep)) if not os.path.isdir(folder): os.makedirs(folder) # ---------------------------------------- # Go through each patient data and create an excel file for each # ---------------------------------------- uptakes = {} for patient in patients: print patient patients[patient].calculate_average() # ---------------------------------------- # Create Excel file # ---------------------------------------- excelfile = Excel() # ---------------------------------------- # Raw data # ---------------------------------------- excelfile.add_sheet('raw data', patients[patient].raw_data()[1]) # ---------------------------------------- # Concentration # ---------------------------------------- excelfile.add_sheet('concentration', patients[patient].raw_data()[0]) # ---------------------------------------- # Mean + Std # ---------------------------------------- excelfile.add_sheet('mean', patients[patient].mean_std()) # ---------------------------------------- # Normalized to aminoacid # ---------------------------------------- for i in xrange(len(patients[patient].aa)): # new = np.array(patients[patient].normalized(-1, i)) if i == 0: a = new else: a = np.concatenate((a, new), axis = 1) # excelfile.add_sheet('normalized', a) # ---------------------------------------- # Uptake # ---------------------------------------- excelfile.add_sheet('uptake', patients[patient].normalized(0, -1)) # ---------------------------------------- # Uptake normalized # ---------------------------------------- for i in xrange(len(patients[patient].aa)): new = np.array(patients[patient].normalized(0, i)) if i == 0: a = new else: a = np.concatenate((a, new), axis = 1) # excelfile.add_sheet('uptake normalized', a) # ---------------------------------------- # Save Excel datafile # ---------------------------------------- excelfile.save_excel_file(folder + patient + '.xls') # ---------------------------------------- # Uptake is Arg # ---------------------------------------- uptakes[patient] = patients[patient].uptake(7) # ---------------------------------------- # Create a file with all results # ---------------------------------------- excelfile = Excel() groups = list(set([key.split('-')[0] for key in uptakes.keys()])) groups.sort() patient_data = [['patient'] + patients[uptakes.keys()[0]].samples] for group in groups: keys = [] group_data = [] for key in uptakes.keys(): if group in key: keys.append(key) group_data.append(uptakes[key]) group_data = np.array(group_data) mean = group_data.mean(axis = 0) std = group_data.std(axis = 0) for key in keys: patient_data.append([key] + uptakes[key]) patient_data.append(['' for _ in xrange(len(mean)+1)]) patient_data.append(['Mean'] + list(mean)) patient_data.append(['Std'] + list(std)) patient_data.append(['' for _ in xrange(len(mean)+1)]) patient_data.append(['' for _ in xrange(len(mean)+1)]) patient_data = np.array(patient_data) excelfile.add_sheet('patient_data', patient_data.T) excelfile.save_excel_file(folder + 'patients.xls') # ---------------------------------------- # Finish # ---------------------------------------- self.button_data.Label = 'Saved!' # openDirDialog.Destroy() # return None
def dlinks_from_excel(self, xls_file): """Read links between variables from an Excel file. The Excel file should have the following format: ======= ====== ======= ======= ======= ======= ======= ======= ======= . col j col j+1 col j+2 col j+3 col j+4 col j+5 col j+6 col j+7 ======= ====== ======= ======= ======= ======= ======= ======= ======= row i DLINK row i+1 row i+2 dvar c0 c ivar1 c1 ivar2 c2 ... row i+3 LP.1.1 0. 1. LS.1.1 0.4 LS.1.2 0.6 ... ======= ====== ======= ======= ======= ======= ======= ======= ======= where the relative position between the cell with `DLINK` and the others must be held. Parameters ---------- xls_file : str The full path of the Excel file. """ from excel import Excel ex = Excel(xls_file) found = False print('Reading Excel File %s...' % xls_file) for row in range(1, 101): for col in range(1, 256): rvalue = ex.get_cell(1, row, col) if 'DLINK' == rvalue: found = True break if found: break dlinks = {} count = -1 irow = row + 3 for row in range(irow, 65536): dvar_code = ex.get_cell(1, row, col) if dvar_code is None: break print(' creating DLINK for variable: %s' % dvar_code) c0 = ex.get_cell(1, row, col + 1) c = ex.get_cell(1, row, col + 2) ivar_code_1 = ex.get_cell(1, row, col + 3) c_1 = ex.get_cell(1, row, col + 4) ivar_code_2 = ex.get_cell(1, row, col + 5) c_2 = ex.get_cell(1, row, col + 6) ivar_code_3 = ex.get_cell(1, row, col + 7) c_3 = ex.get_cell(1, row, col + 8) dvar = self.dvar_codes[dvar_code] ivar_1 = self.dvar_codes[ivar_code_1] try: dvi_ci = [ivar_1.id, float(c_1)] except: dvi_ci = [ivar_1.id, str(c_1)] if ivar_code_2.__class__.__name__ <> 'NoneType': ivar_2 = self.dvar_codes[ivar_code_2] dvi_ci = dvi_ci + [ivar_2.id, float(c_2)] if ivar_code_3.__class__.__name__ <> 'NoneType': ivar_3 = self.dvar_codes[ivar_code_3] dvi_ci = dvi_ci + [ivar_3.id, float(c_3)] count += 1 self.dlinks[count] = DLINK(dvar.id, dvi_ci, c0=c0, cmult=c) ex.close()
def nodal_displ_from_excel(self, xls_file): """Create nodal displacement constraints based on an Excel file. This function reads the xls file with nodal displacement constraints and returns a dictionary with the format:: nd = {load_case_id1 : {grid_1 : {output : [minvalue, maxvalue], grid_2 : output : [minvalue, maxvalue], grid_3 : output : [minvalue, maxvalue]}} load_case_id2 : {grid_1 : {output : [minvalue, maxvalue], grid_3 : outout : [minvalue, maxvalue]}}} where `minvalue` and `maxvalue` are the minimum and maximum displacement values. Parameters ---------- xls_file : str The full path to the Excel file. Returns ------- output : str A string with one of the values: - `'Translation X'` - `'Translation Y'` - `'Translation Z'` - `'Rotation X'` - `'Rotation Y'` - `'Rotation Z'` - `'Translation Total'` - `'Absolute X'` - `'Absolute Y'` - `'Absolute Z'` """ from excel import Excel if not xls_file: return None ex = Excel(xls_file) found = False for row in range(1, 100): for col in range(1, 23): refvalue = str(ex.get_cell(1, row, col)) if refvalue.find('DISPLACEMENT CONSTRAINTS') > -1: found = True break if found: break nd = {} irow = row + 2 #TODO this try/except block is mainly to avoid Excel from being # a defunct try: for row in range(irow, 65536): load_id = ex.get_cell(1, row, col) if load_id.__class__.__name__ == 'NoneType': break # load_id = int(load_id) node_id = ex.get_cell(1, row, col + 1) node_id = int(node_id) output = ex.get_cell(1, row, col + 2) output = str(output) minvalue = ex.get_cell(1, row, col + 3) minvalue = float(minvalue) maxvalue = ex.get_cell(1, row, col + 4) maxvalue = float(maxvalue) if not load_id in nd.keys(): nd[load_id] = {} if not node_id in nd[load_id].keys(): nd[load_id][node_id] = {} nd[load_id][node_id][output] = [minvalue, maxvalue] ex.close() self.nodal_displ = nd except: ex.close() print('nodal_displ_from_excel() failed!') return None for load_id in nd.keys(): for node_id in nd[load_id].keys(): for con_name in nd[load_id][node_id].keys(): con_minvalue = nd[load_id][node_id][con_name][0] con_maxvalue = nd[load_id][node_id][con_name][1] for k, v in OUTC['DISP'].iteritems(): if v.find(con_name) > -1: code = k break if code == 7: #DRESP1 x labelx = 'x' + str(node_id) dresp1 = DRESP1(labelx, 'DISP', '', '', 1, [node_id]) self.dresps[dresp1.id] = dresp1 dresp1xid = dresp1.id #DRESP1 y labely = 'y' + str(node_id) dresp1 = DRESP1(labely, 'DISP', '', '', 2, [node_id]) self.dresps[dresp1.id] = dresp1 dresp1yid = dresp1.id #DRESP1 z labelz = 'z' + str(node_id) dresp1 = DRESP1(labelz, 'DISP', '', '', 3, [node_id]) self.dresps[dresp1.id] = dresp1 dresp1zid = dresp1.id #DEQATN eq = ('T(%s,%s,%s)=SQRT(%s**2+%s**2+%s**2)' % (labelx, labely, labelz, labelx, labely, labelz)) deqatn = DEQATN(eq) self.deqatns[deqatn.id] = deqatn #DRESP23 label = 'r' + str(node_id) dresp23 = DRESP23(label, deqatn.id) dresp23.add_dresp1(dresp1xid) dresp23.add_dresp1(dresp1yid) dresp23.add_dresp1(dresp1zid) self.dresps[dresp23.id] = dresp23 #DCONS stress_type = 'positive' lid_lb_ub = [str(load_id), con_minvalue, con_maxvalue] self.dcons[dresp23.id] = DCONS(dresp23.id, lid_lb_ub, stress_type) elif (code == 8 or code == 9 or code == 10): #DRESP1 label = 'a' + str(node_id) dresp1 = DRESP1(label, 'DISP', '', '', code, [node_id]) self.dresps[dresp1.id] = dresp1 #DEQATN eq = 'D(%s)=ABS(%s)' % (label, label) deqatn = DEQATN(eq) self.deqatns[deqatn.id] = deqatn #DRESP23 label = 'r' + str(node_id) dresp23 = DRESP23(label, deqatn.id) dresp23.add_dresp1(dresp23.id) self.dresps[dresp23.id] = dresp23 #DCONS stress_type = 'positive' lid_lb_ub = [str(load_id), con_minvalue, con_maxvalue] self.dcons[dresp23.id] = DCONS(dresp23.id, lid_lb_ub, stress_type) else: #DRESP1 label = 'r' + str(node_id) dresp1 = DRESP1(label, 'DISP', '', '', code, [node_id]) self.dresps[dresp1.id] = dresp1 #DCONS stress_type = 'both' lid_lb_ub = [str(load_id), con_minvalue, con_maxvalue] self.dcons[dresp1.id] = DCONS(dresp1.id, lid_lb_ub, stress_type)
def setUp(self): q = Query() fifth_third_transactions = q.get_transactions_by_range('53',5,6) self.e = Excel(fifth_third_transactions,PATH)
# -*- coding: utf-8 -*- # authors 13077/13130 # data: 05 de outubro de 2014 # from excel import Excel from db import Database # x = Excel("../Data/IPC_Portugal_1977_2013.xls") x = Excel("C:/Users/Diogo/Dropbox/ESTIG/2/S1/LP/LP-1415/IPC_Portugal_1977_2013.xls") #x.readFile() #lista = x.lista x.read_data() lista2 = x.lista2 d = Database(lista2) d.drop_table() d.create_table() d.insert_data() d.test() # test test tes tes testest se es test es te te s