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 ;)
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.