2 Replies Latest reply on Oct 12, 2016 12:48 PM by txgal72

    How to update PDF Title with value from Excel

    txgal72

      I have searched and found information on importing excel data into a single PDF but that is not quite what I need.  I need to loop through a directory of PDF's and if the pdf document name matchs the field PDF in my excel file then update the PDF Title field with the Title from the spreadsheet. 

       

      So basically loop through c:\pdfs and if PDF Name = Excel spreadsheet PDF column value then update the actual PDF Title with the value from the excel spreadsheet column Title.  I guess I would have to scan every row of the spreadsheet to see if that PDF existed or not.  Is this possible?

       

      Thanks!

       

      Excel:

      PDFTITLE
      CL01000399.pdfCOMMON POLICY CONDITIONS