Skip to main content
March 8, 2016
Question

Is there a way of combining files automatically into pdfs according to excel data storing recipes for the file combinations?

  • March 8, 2016
  • 0 replies
  • 265 views

I would like to be able to merge and/or print different combinations of files together according to specifications which are stored in an Excel spreadsheet(Recipe Sheet) which itself references another sheet(Tag Sheet) that acts to store filenames according to tags, and create print ready PDF files.

Example:

Recipe Sheet

Row/Col.....................A.......................B............C............D............E............F...........G........

1............./filename1.pdf.../filename2.pdf..........................5...........3...........................1.........

2............./filename3.pdf.../filename1.pdf............2............2...........2..............1......................

3............./filename1.pdf.../filename2.pdf............2.........................2..............1......................

4............./filename1.pdf.../filename3.pdf...........................1...........2.....................................

5............./filename1.pdf.../filename2.pdf............4.............2...........2...........................1........

etc.

etc.

Where in Columns C--G(Subject to Change) 1,2,3,etc. stand as tags for other files which are stored in another excel sheet

Tag Sheet

Row/Col................................A...

1............./taggedfilename1.pdf...

2............./taggedfilename2.pdf....

3............./taggedfilename3.pdf...

4............./taggedfilename4.pdf...

5............./taggedfilename5.pdf...

etc.

etc.

And output should be (and optionally printed out in order.)

pdf1 : filename1.pdf  + filename2.pdf +  taggedfilename5.pdf + taggedfilename3.pdf + taggedfilename1.pdf

pdf2 : filename3.pdf  + filename1.pdf +  taggedfilename2.pdf + taggedfilename2.pdf + taggedfilename2.pdf + taggedfilename1.pdf

pdf3 : filename1.pdf  + filename2.pdf +  taggedfilename2.pdf + taggedfilename2.pdf + taggedfilename1.pdf

pdf4 : filename1.pdf  + filename3.pdf +  taggedfilename1.pdf + taggedfilename2.pdf

pdf5 : filename1.pdf  + filename2.pdf +  taggedfilename4.pdf + taggedfilename2.pdf + taggedfilename2.pdf + taggedfilename1.pdf

etc.

etc.

Thank you for any suggested solutions.

This topic has been closed for replies.