import openpyxl

def write_excel_xlsx(path, sheet_name, data): # 打开Excel文件 workbook = openpyxl.load_workbook(path) # 获取指定工作表 worksheet = workbook[sheet_name] # 写入数据 for row in range(1, len(data) + 1): for col in range(1, len(data[row - 1]) + 1): worksheet.cell(row=row, column=col, value=data[row - 1][col - 1]) # 保存文件 workbook.save(path)

低版本或火狐的WebDriver

from selenium import webdriver from selenium.webdriver.common.keys import Keys

def paste(): driver.find_element_by_xpath("//body").send_keys(Keys.CONTROL + "v")

def selectAll(): driver.find_element_by_xpath("//body").send_keys(Keys.CONTROL + "a")

def cNum(start, end): # 生成随机数，浮点类型 a = random.uniform(start, end) # 控制随机数的精度round(数值，精度) return round(a, 2)

向表格写入数据

def write_excel_xlsx(path, sheet_name, data): # 打开Excel文件 workbook = openpyxl.load_workbook(path) # 获取指定工作表 worksheet = workbook.get_sheet_by_name(sheet_name) # 写入数据 for row in range(1, len(data) + 1): for col in range(1, len(data[row - 1]) + 1): worksheet.cell(row=row, column=col, value=data[row - 1][col - 1]) # 保存文件 workbook.save(path)