Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # created by python bits.Check out my channel: https://www.youtube.com/@python-bits
- import openpyxl
- from datetime import datetime
- wb = openpyxl.load_workbook('Sample_data.xlsx')
- ws = wb.active
- excel_data = []
- for row in ws.iter_rows(min_row=2, values_only=True):
- excel_data.append(row)
- #print(excel_data[0:5])
- excel_data.sort(key=lambda row: datetime.strptime(row[2], '%m/%d/%Y'))
- print(excel_data[0:5])
- ws.delete_rows(2, ws.max_row-1)
- for row in excel_data:
- ws.append(row)
- wb.save('final_output.xlsx')
Advertisement
Add Comment
Please, Sign In to add comment