how to delete all the data in a sheet in excel?

Question

from openpyxl import load_workbook
wb = load_workbook("C:\op.xlsx")
ws = wb.active

This is the code I have so far as I don't know what to do next so pls help me.

Why not simply create a new file instead and overwrite the existing one? — Thomas, Jul 12 '22 at 07:32
We wrote a program to remove all the files in a directory structure and it took about 2 hours to run. Then we realized removing the parent directory and creating a new directory structure was much quicker - like 5 seconds... — Solar Mike, Jul 12 '22 at 07:40

score 2 · Accepted Answer · answered Jul 12 '22 at 07:44

Try:

ws.delete_rows(1, ws.max_row)

You could also delete the sheet and create another one:

del wb[wb.active.title]
wb.create_sheet()

See

1 Answers1