在使用Selenium的测试中使用python删除Google Sheet中的列

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

# 启动Chrome浏览器
driver = webdriver.Chrome('path/to/chromedriver')
driver.get('https://docs.google.com/spreadsheets/')

# 定位登录按钮并点击
login_button = driver.find_element_by_xpath('//button[@id="gb_70"]')
login_button.click()

# 输入账号和密码
email_input = driver.find_element_by_xpath('//input[@type="email"]')
email_input.send_keys('your_email@example.com')

next_button = driver.find_element_by_xpath('//div[@id="identifierNext"]')
next_button.click()

password_input = driver.find_element_by_xpath('//input[@type="password"]')
password_input.send_keys('your_password')

# 定位密码输入框并回车
password_input.send_keys(Keys.RETURN)

# 定位需要删除的列
column_to_delete = driver.find_element_by_xpath('//div[@class="col-header-wrapper"]/div[text()="Column Name"]')

# 执行删除操作
column_to_delete.click()
delete_button = driver.find_element_by_xpath('//div[@class="menu-item" and text()="Delete column"]')
delete_button.click()

driver.quit()