On 7/09/2012 18:04, Kevin Penrose wrote:
*Hopefully I can explain this well enough to solicit an answer:*
I've seen the same question on Stackoverflow, but I didn't answer it,
because I didn't understand why it was tagged with 'itext'.
*I have started automating an job process which involves printing
filled out forms. These forms currently exist as excel spreadsheets,
into which the user types the relevant data before printing.*
OK. So the users stores them as XLS(X) or as CSV?
*I have used Open Office to create an xml form which I can then
programatically fill out and print using iText.
*
That's probably an interactive PDF form based on AcroForm technology.
You can fill these forms out, provided you have the data. That's not a
problem.
*Due to the number of excel spreadsheets in the library of forms that
may have to be used, it would be a monumental task to rebuild them all
in openoffice. *
OK, so you're using excel spreadsheets in an improper way: they serve as
fillable forms. You want to keep it that way.
* Can someone suggest a way (using iText of course) that I can take
those excel spreadsheets (exported to pdf if necessary) and merge in
the data that needs to be added programatically, and print the
resulting PDF.*
So you want to:
(1) convert filled out XLS(X) files to PDF? iText doesn't do that.
(2) extract filled out data from XLS(X) files? iText doesn't do that.
(3) merge data into an AcroForm? That you've already done. That works.
*If I'm not clear on any of the points, please feel free to ask me for
more information. This is a critical business need for the project
I'm working on, and I've already spent a great deal of time on it (in
the way of trying to learn iText - first exposure). Also, if there is
a better solution than iText, I'm open to that as well.*
Sounds that you need something like http://poi.apache.org/ to deal with
the XLS side first (unless you're talking about CSV, then it's simple:
it's just a matter of processing the data line by line). iText doesn't
interpret XLS.
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
iText-questions mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/itext-questions
iText(R) is a registered trademark of 1T3XT BVBA.
Many questions posted to this list can (and will) be answered with a reference
to the iText book: http://www.itextpdf.com/book/
Please check the keywords list before you ask for examples:
http://itextpdf.com/themes/keywords.php
