![]() ![]() But the best way to do that probably depends on the details and hopefully this would give you a starting point if you end up using something like this workflow. It can also be made more efficient, especially, I think, for the renaming. Obviously, this process can be tweaked in various ways and you can combine things in scripts etc. ![]() Name1.pdf corresponds to the first data row: This gives me three pdfs named Name.pdf, Name1.pdf and Name2.pdf. Drag and drop the file from your device or import it from other services, like Google Drive, OneDrive, Dropbox, or an external link. paste -d ' ' pdf.list name.list | sed -e 's/^/mv /' -e 's/$/.pdf/' > cmds.list This way, each data entry gets its own command. This page teaches you how to convert an Excel file to a PDF file. I'm doing it this way because if you have a lot of data, storing all the names as arguments is likely to exceed the capacity of your shell. ![]() For example, you might need to remove spaces: sed -i 's/ //g' name.list The columns need to be named the same way as the field names in the PDF form. If you need to clean up the name list, do it now. To import data from an Excel spreadsheet to a fillable PDF Form, there are two things you need to do in Excel for this to work. Assuming nothing deviates too far from what your system will accept: ls pg_000* > pdf.list This might be problematic if you have names with accented characters etc. The remaining problem is therefore to rename them using the names from the original file. To separate the pages into separate pdfs, I used pdftk as follows: pdftk question.pdf burst csv file which I saved as question.csv: Name Question1 Question2 Question3 ![]() (This is in calc but I assume other software offers similar functionality.) csv and choose as field separator and nothing to surround text. If I start with a spreadsheet which looks like yours, I then save as, pick. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |