Skip to main content
L
LisaTheDragonSlayer
Participant
February 21, 2021
Frage

Extract pages based on names on excel spreadsheet

  • February 21, 2021
  • 1 Antwort
  • 302 Ansichten

Is there a way to build basically a vlookup between a pdf and an excel lit?  I have active and terminated employees W2C documents on a very large pdf.  I only need to print the terminated employee's W2C but there are 650 of them and I don't want to look them up one at a time.  Is there an automated way to do this?  I'm also not opposed to extracting only the terminated employees and putting their documents in their own pdf file.

Dieses Thema wurde für Antworten geschlossen.

1 Antwort

try67
Community Expert
try67Community Expert
Community Expert
February 21, 2021

It is possible, but it's complicated. For starters, you can't read the data from the Excel file directly. You'll have to save it first as a plain-text file. Then it would require the development of a custom-made script to read the data from it and extract the pages from the file based on that data.

 

I've developed similar tools in the past for my clients so if you're interested in hiring someone to do it for you feel free to contact me privately via [try6767 at gmail.com] to discuss it further.

Allgemeine NutzungsbedingungenAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices