【python 将cookie写入excel并读取】# -- coding: utf-8 --# @Time : 2022/6/20 11:05import xlrd, xlwt, osExcel_path = os.path.join(os.path.abspath(__file__), "../data/zentao_login_cookies.xlsx")class ExcelUtils:def __init__(self, excel_path=excel_path):self.excel_path = excel_pathdef write_excel(self):wb = xlwt.Workbook()sheet = wb.add_sheet('zentao_cookies')row_list = [["name", "value", "Domain", "path"],['zentaosid', 'l97vmm6ovptiq8c47s6unb2e31', 'xx.107.178.45', '/'],['theme', 'default', 'xx.107.178.45', '/zentao/www/'],['device', 'desktop', 'xx.107.178.45', '/zentao/www/'],['lang', 'zh-cn', 'xx.107.178.45', '/zentao/www/']]for i in range(0, len(row_list)):data = https://www.isolves.com/it/cxkf/yy/Python/2022-06-21/row_list[i]for j in range(0, len(data)):sheet.write(i, j, data[j])wb.save(self.excel_path)def read_excel(self):wk = xlrd.open_workbook(self.excel_path)sheet = wk.sheet_by_name("zentao_cookies")rows = sheet.nrowscols = sheet.ncolscookies_list = []for i in range(cols + 1):cookie_list = []for j in range(rows - 1):cookie_list.Append(sheet.cell_value(i, j))cookies_list.append(cookie_list)return cookies_listdef list_to_change_dic(self):c= []for i in range(0, 4):b = []for j in range (1,5):a = {self.read_excel()[0][j-1]: self.read_excel()[i+1][j-1]}b.append(a)c.append(b)return cif __name__ == '__main__':ecl_util = ExcelUtils()#ecl_util.write_excel()# ecl_util.read_excel()# for i in range(0,4):# print(ecl_util.list_to_change_dic()[0])
推荐阅读
- virtualenv python的虚拟环境
- 如何用python获取收益
- 水浒传 的三位女将是谁,水浒传中上梁山的女将是谁-
- 车祸|保镖闯下大祸 将C罗布加迪威龙撞墙严重损毁
- 正月剃头死舅舅的由来女孩没有将就,正月剃头死舅舅的由来哪首诗-
- 太阳|今日夏至 多地炎热升级：这些地方高温日数全年最多 南方将迎初台风
- 民间故事|民间故事：男子捕鱼给病妻，儿子将其放生，鲤鱼托梦说多喝水
- 朱棣手下有哪些名将,朱棣手下的名将张玉-
- 我觉得吕布已经天下无敌了 不知竟有如此猛将,吕布为什么公认三国第一猛将-
- 联想|陈劲暗示摩托罗拉新机将至：业内首款两亿像素骁龙8+旗舰！