These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

fill pdf from excel worksheets data

shara
Registered: Jan 28 2011
Posts: 3

hi
I want to know how can I create a PDF file with excel worksheets data?
I saw some thing in this site :
http://www.aspose.com/doctest/.net-components/aspose.pdf.kit-for-.net/export-excel-worksheet-data-to-fill-pdf-form.php
 
I want to extracting the data from the excel sheets and automatically create a pdf file with this data.
 
for example: I have an excel file with three filed and 4 rows of data
now
I want to know how can I create a PDF with 4 page that in everyone of this page printed the each rows of this excel file .
 
image of this link is my wanted:
http://www.aspose.com/doctest/.net-components/aspose.pdf.kit-for-.net/export-excel-worksheet-data-to-fill-pdf-form.php
 
I'm so sorry for my english, my english is bad ;)
 

My Product Information:
Acrobat Pro 10.0, Windows
George_Johnson
Expert
Registered: Jul 6 2008
Posts: 1875
One way is to use JavaScript and take advantage of the page templates feature. The data can be exported from Excel to a tab-delimited text file. The first row of the file has to be the field names. The subsequent lines would be the corresponding rows of data.

A script could import each row of data (doc.importTextData) from the data file into text fields that have the same name as the fields in the data file. You could then spawn (template.spawn) a new page based on a template and copy the data that was imported to the fields on the newly spawned page. When you spawn a new page, be sure to have it rename the fields. Since the fields get renamed according to a known naming convention, the script can be written to copy the data to the proper fields. Once you've imported all of the data, the script could then delete the page (doc.deletePages) that has the fields that each record was imported into. This will leave you with a PDF that contains as many pages as there are rows of data, with each page showing the corresponding data. You can also flatten the resulting pages (doc.flattenPages) to convert the fields to regular page contents.

More information on all of this is in the Acrobat JavaScript documentation.
shara
Registered: Jan 28 2011
Posts: 3
thanks george

can you or anybody help me step by step.
I dont understand about your answer.
in this link :
http://www.aspose.com/doctest/.net-components/aspose.pdf.kit-for-.net/export-excel-worksheet-data-to-fill-pdf-form.php
there was an excel file with rows.
and now I want to have PDF files with content of this excel file rows.

if I should be using javascript or other scripts please tell me step by step to I do theme.

please help me
pleaseeee
George_Johnson
Expert
Registered: Jul 6 2008
Posts: 1875
I could, but then I'd have to charge you.

This requires a bit more than a few lines of code, so it involves a good amount of programming, though it is straightforward. Here is another recent discussion about this that has a little more information: http://forums.adobe.com/message/3397600#3397600

If you don't want to do the programming or find someone who can, I seem to recall that there is commercial software available that can do this, but I don't remember them at the moment.
shara
Registered: Jan 28 2011
Posts: 3
thanks George
I don't know any thing about programming.
but I can buy any commercial software.
can you give me this software link?
George_Johnson
Expert
Registered: Jul 6 2008
Posts: 1875
I was thinking of ARTS Variform: http://www.artspdf.com/arts_pdf_variform_lite.asp
brendanC
Registered: Apr 18 2011
Posts: 1
One other way to "print" to PDF is with a service called OneClick Commissions (meant for people who manage and issue Commissions Earnings Statements). They have a free trial here: http://www.oneclickcommissions.com/excel-worksheets.php
klwalsh611
Registered: Sep 10 2009
Posts: 28
Is there a way to import a tab delimited file that can be referenced from within the form once a specific field selection is made? I need to pull a user name and email address from the file based upon a market center # that is selected from a drop-down.