Sunday, January 29, 2023

Excel read and write in Python

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