Answers for "delete all the blank rows in excel using python"

4

how to delete every row in excel using openpyxl

import openpyxl as xl
wb = xl.load_workbook()
ws = wb.active
ws.delete_rows(firstrow, numberofrows) #for multiple row deletion
ws.delete_rows(1, ws.max_row+1) # for entire sheet
ws.delete_rows(rownum) #for single row
Posted by: Guest on September-06-2020

Code answers related to "delete all the blank rows in excel using python"

Python Answers by Framework

Browse Popular Code Answers by Language