top of page

Improving Excel with Python (Day 3 of 5)

My starter scripts in January 2021:

List Excel file attributes in Excel



File attributes of Excel files (the file properties accessible on right-click) are seldom used to their full potential, in my experience. I suspect one reason for this is that there’s no quick way to see what details have been entered for multiple files.


Here’s a snippet that allows you to see the title, description, subject and other details (like date last modified) for multiple Excel files held in a single folder, all in one spreadsheet.


Check out tomorrow’s post for an easy way to update all file attributes for all Excel files in a folder, in a single click.


Any thoughts or questions, get in touch



 

Have a look at the code I used, here:




Recent Posts

See All

Commenti


Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page