@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])
โ
โ