In my office we have about 1000 PDFs that have arbitrary title and author information. My bosses had a spreadsheet created with the PDFs filename and an appropriate title and appropriate author information.
I would like to find a programmatic way to move the data from the Excel sheet to the PDF attributes?
My preferred language is Python so I looked for a Python library to do this, each library I looked at had the author and title fields as read-only.
If Python doesn't have a library that works I am okay using VBA, VB.NET, JavaScript... I will take this as an opportunity to learn a new language.