OpenPyXL - Finding the Last/Max Column to Add Data in Excel Workbooks with Python | Data Automation

[@Hadya-mw6ii]

Awesome video. I have a question for my own use case that suppose I get the max column i.e. as shown in video the column BR and copy paste the contents of this column in BS. How can we modify the code to attain this functionality?

[@data_automation]

Thank you for the comment! I actually recently released a video where you can achieve this functionality - it’s on moving a column -> kzbin.info/www/bejne/oKPQqa1tYt-Mmqssi=3Q67m4oTW60QylBf In this video, I discuss a loop that moves the contents from one place to another. In that loop I talk about eliminating a cells contents by assigning its value “None”. For your use case, replicant that for loop but don’t include the line where you assign the values None. That will keep the column in its place while copying it to somewhere else.