*Thanks for the replies thus far. I guess I have more to explain. *
*The workflow isn't really relative. There a hundreds of excel
spreadsheets which contain forms that have to be filled out by a user and
then emailed/smailed or packaged with merchandise. What I was hoping for
was a solution where I could export all of these excel spreadsheets to pdf,
and then add the relevant data programmatically using iText.*
*I'm aware of the apache POI api, and that really doesn't help because the
parts of the form that need to be filled in could be anywhere in the
spreadsheet.*
*As I said, I know how to create fillable forms with open/libre office and
then fill those forms, but the number and variety of the excel forms, which
have been created over many years, would be very difficult to manually
recreate in a open office document.*
*Thanks.
*
On Fri, Sep 7, 2012 at 12:53 PM, <
[email protected]> wrote:
> Send iText-questions mailing list submissions to
> [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/itext-questions
> or, via email, send a message with subject or body 'help' to
> [email protected]
>
> You can reach the person managing the list at
> [email protected]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of iText-questions digest..."
>
>
> Today's Topics:
>
> 1. Re: ECDSA and Adobe Reader (Leonard Rosenthol)
> 2. Excel formatted text -> pdf form (Kevin Penrose)
> 3. Re: Excel formatted text -> pdf form (1T3XT BVBA)
> 4. Re: Excel formatted text -> pdf form (Dean Johnson)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 7 Sep 2012 04:37:04 -0700
> From: Leonard Rosenthol <[email protected]>
> Subject: Re: [iText-questions] ECDSA and Adobe Reader
> To: Post all your questions about iText here
> <[email protected]>
> Message-ID:
> <d23d6b9e57d654429a9ab6918caceaa9c56449d...@nambx02.corp.adobe.com
> >
> Content-Type: text/plain; charset="us-ascii"
>
> Elliptic Curves are not supported by Adobe Reader X, as they are not
> documented to be supported in ISO 32000-1:2008.
>
> Leonard
>
> -----Original Message-----
> From: iText Info [mailto:[email protected]]
> Sent: Friday, September 07, 2012 3:11 AM
> To: Post all your questions about iText here
> Subject: [iText-questions] ECDSA and Adobe Reader
>
> Hello,
> yesterday I signed a document using SHA256withECDSA.
> It opens in Adobe Reader X, but the signature couldn't be verified.
> Before I dive into my code to see what I did wrong, I'd like to ask:
> Is ECDSA already supported in Adobe Reader X?
> best regards,
> Bruno
>
>
> ------------------------------------------------------------------------------
> 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
>
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 7 Sep 2012 12:04:18 -0400
> From: Kevin Penrose <[email protected]>
> Subject: [iText-questions] Excel formatted text -> pdf form
> To: [email protected]
> Message-ID:
> <CAF44m3u5=p1UYQ=+
> [email protected]>
> Content-Type: text/plain; charset="iso-8859-1"
>
> *Hopefully I can explain this well enough to solicit an answer:*
> *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. I have used Open Office
> to create an xml form which I can then programatically fill out and print
> using iText. 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. 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.*
> *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.*
> *
> *
> *Thanks.*
> *
> *
> *-- Kevin*
> *
> *
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 3
> Date: Fri, 07 Sep 2012 18:18:41 +0200
> From: 1T3XT BVBA <[email protected]>
> Subject: Re: [iText-questions] Excel formatted text -> pdf form
> To: Post all your questions about iText here
> <[email protected]>
> Message-ID: <[email protected]>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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.
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 4
> Date: Fri, 7 Sep 2012 11:24:27 -0500
> From: Dean Johnson <[email protected]>
> Subject: Re: [iText-questions] Excel formatted text -> pdf form
> To: Post all your questions about iText here
> <[email protected]>
> Message-ID:
> <CALXVkTvXPa6=
> [email protected]>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Kevin
> Not sure I understand the workflow -- are the users completing the Excel
> files and sending to you for conversion to PDF?
>
> Dean
>
>
> On Fri, Sep 7, 2012 at 11:04 AM, Kevin Penrose <[email protected]
> >wrote:
>
> > *Hopefully I can explain this well enough to solicit an answer:*
> > *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. I have used Open
> Office
> > to create an xml form which I can then programatically fill out and
> print
> > using iText. 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. 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.*
> > *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.*
> > *
> > *
> > *Thanks.*
> > *
> > *
> > *-- Kevin*
> > *
> > *
> >
> >
> >
> ------------------------------------------------------------------------------
> > 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
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
>
> ------------------------------------------------------------------------------
> 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
>
> End of iText-questions Digest, Vol 76, Issue 23
> ***********************************************
>
------------------------------------------------------------------------------
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
