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]
