Python openpyxl Insert, Delete, Move Rows and Columns

[@leandroaugusto1195]

Amazing video, great value, thank you it was a lot of use to me. Finallyy someone!!!

[@RyanNoonan]

Great to hear!

[@MrFruityDJ]

THe move_range actually doubles the valuse, when I write 1 it move cell by 2

[@philtoa334]

Nice.

[@RyanNoonan]

Thanks!

[@riquezinho8440]

how to delete a one single row and append for remove blank spaces

[@nguyeninhhung411]

How can we move with formating?

[@Lexcepcion]

How can you delete rows that have all NaN values?

[@RyanNoonan]

An easy way that might work using openpyxl and pandas: 1. convert spreadsheet to dataframe 2. drop None, NaN, etc. from dataframe using df.dropna() 3. convert dataframe back to spreadsheet

[@Lexcepcion]

@@RyanNoonan thank you