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 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(): 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 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 __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 __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 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 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 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 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 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 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 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 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)
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 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 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 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 __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 output_to_excel(self): """Output the full event list to an Excel file. Author: KomorebiL Args: None Returns: None """ Excel(self).save()
def __init__(self, csv_dir, packages=[]): os.chdir(csv_dir) # 需要画曲线的csv文件名 self.summary_csf_file = { "cpuinfo.csv": { "table_name": "pid_cpu", "x_axis": "datatime", "y_axis": "%", "values": ["pid_cpu%", "total_pid_cpu%"] }, "meminfo.csv": { "table_name": "pid_pss", "x_axis": "datatime", "y_axis": "mem(MB)", "values": ["pid_pss(MB)", "total_pss(MB)"] }, "pid_change.csv": { "table_name": "pid", "x_axis": "datatime", "y_axis": "pid_num", "values": ["pid"] }, } self.packages = packages if len(self.packages) > 0: for package in self.packages: pss_detail_dic = { "table_name": "pss_detail", "x_axis": "datatime", "y_axis": "mem(MB)", "values": ["pss", "java_heap", "native_heap", "system"] } # 文件名太长会导致写excel失败 self.summary_csf_file["pss_%s.csv" % package.split(".")[-1].replace( ":", "_")] = pss_detail_dic logger.debug(self.packages) logger.debug(self.summary_csf_file) logger.info('create report for %s' % csv_dir) file_names = self.filter_file_names(csv_dir) logger.debug('%s' % file_names) if file_names: book_name = 'summary_%s.xlsx' % TimeUtils.getCurrentTimeUnderline() excel = Excel(book_name) for file_name in file_names: logger.debug('get csv %s to excel' % file_name) values = self.summary_csf_file[file_name] excel.csv_to_xlsx(file_name, values["table_name"], values["x_axis"], values["y_axis"], values["values"]) logger.info('wait to save %s' % book_name) excel.save()
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 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(): result_excel = "data/result.xlsx" brands_json = "data/brands.json" brands_done = "data/brands_done.json" excel_title = ["shop", "name", "price", "favorite", "url"] browser = Req() flux = Flux(browser) excel = Excel(file_name=result_excel) flux.load_brands(brands_json) flux.load_done_brands(brands_done) flux.get_all(brands_json, brands_done) flux.write_excel(excel, excel_title)
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(): 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]