Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2025 12:56 AM
As shared above I tested it and worked fine for loading and updating and saving
import openpyxl
wb = openpyxl.load_workbook('Test.xlsx')
ws = wb.active
for row in ws.iter_rows():
print([col.value for col in row]) #show all data
ws['A1']='Data'
wb.save('Test.xlsx')
