Given that you are programmatically creating the xls, you can programmatically create your PDF also. No need to convert from xls->PDF, it may be easier to just convert to PDF from your original data. FOP is for XML-> PDF and iText is for programmatically creating PDF files.
I don't work on the Excel side of POI so I don't know if there is something for converting Excel -> XML. If there is, it *might* be easier to do FOP. But you would still have to convert this XML into the XML namespace that FOP understands, believe me this is not trivial. I believe iText would probably fit your needs better. I would just generate the PDF from the data you used to create the Excel. The thing about PDF is that it is more like a graphics format than a document format. For example, when you create a table in a PDF document, it is represented internally as a series of criss-crossing lines. iText is nice because it tries to handle a lot of the technical details for you. -Ryan ----- Original Message ----- From: "Mark Meyer" <[EMAIL PROTECTED]> To: "'POI Users List'" <[EMAIL PROTECTED]> Sent: Wednesday, January 28, 2004 1:06 PM Subject: RE: can POI create a PDF from an XLS? > > Hi, > > > > We have successfully used POI for creating simple Word > > Documents and FOP for creating PDF documents. > > > > All the information you need on FOP can be found at: > > http://xml.apache.org/fop/ > > > > Cheers, > > Simon. > > hello simon, > > thank you for the response. i reviewed the FOP site and also found a link > to something called iText. > > i am new to this area - so i am still grappling with all of the options and > lib's out there. maybe i need to restate my problem statement. > > Problem statement: > > given the fact that i am programmatically creating XLS files, using POI, out > on the unix file system - how would i then programmatically take each of the > generated XLS files and translate them to PDF format? > > Can POI programmatically read in an XLS file and "save as" a PDF document? > > Can FOP read in an XLS file and translate it to PDF? > > Can iText read in an XLS file and translate it to PDF? > > thank you > mark > > > > > > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
