@Hemanth A try this code.

import openpyxl

wb = openpyxl.load_workbook('/dbfs/PATH/test.xlsx')

ws = wb.active

for row in ws.iter_rows():

print([col.value for col in row])

ws['A1']='A1'

wb.save('/dbfs/PATH/test.xlsx')

​

# Load its modified version and print values

wb = openpyxl.load_workbook('/dbfs/PATH/test.xlsx')

ws = wb.active

for row in ws.iter_rows():

print([col.value for col in row])

​

​