I want to run a script on a series of Excel files (xlsx) to basically copy 1 sheet into a new workbook, sort from Z to A and get rid of unwanted rows and columns... then save this new workbook under a specific name. could you advise me on the best way to do it?

Answer 1

Check it out:
https://code.sololearn.com/cGcw92Q6ZUjB/?ref=app

Answer 2

you can use openpyxl library to work with Excel file.
just 'pip install openpyxl ' and start to use it.
if you don't dispose of pip, install it and you are done