Jul-18-2021, 12:24 PM
When I delete lines through openpyxl, they are not deleted correctly. In some places they even stay. Need to delete rows completely, as excel does. Thank you.
Example:
https://drive.google.com/file/d/1KINvDVn...sp=sharing
import openpyxl this_book = openpyxl.open( "example.xlsx" ) this_book.active = 1 def result_i(): return 10 i = result_i() if i < 255: this_book.active.delete_rows(i, 255-i) this_book.save("result.xlsx") this_book.close()
Example:
https://drive.google.com/file/d/1KINvDVn...sp=sharing