import openpyxl
from selenium import webdriver
def test_excel_data_read_write():
driver = webdriver.Chrome()
file_path = r"C:\example.xlsx"
workbook = openpyxl.load_workbook(file_path)
sheet = workbook.get_sheet_by_name("Sheet1")
# Read data from Excel
for row in sheet.iter_rows():
print(row[0].value, row[1].value)
# Write data to Excel
sheet.append(["Data1", "Data2"])
workbook.save(file_path)
driver.quit()
if __name__ == '__main__':
test_excel_data_read_write()
No comments:
Post a Comment