File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes Converting Excel Workbook to PDF Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Reply locked New topic

Converting Excel Workbook to PDF

Joe Harry
Ranch Hand

Joined: Sep 26, 2006
Posts: 10032

I have done the following, but wondering how to get the layout in my pdf files? I mean the bordering, tables and so on...

OfCourse, this is not the final thing that I will end up...this is just a there might be some stupid code standards followed. Once I get my target perfect and it is after that I will try to model the components accordingly. But for a test run, the below one should do.

@Rob Prime: Can you try the above example?? I used JExcel API, JDOConverter API's which inturn refers to the OpenOffice API's. Can you give me some more inputs to the above one especially on the following points
(1) How to get the contents in the final pdf pages formatted as tables with borders?
(2) How to size the PDF documents?? Do I have to use iText after that?? Any ideas?

Thanks in advance!

SCJP 1.4, SCWCD 1.4 - Hints for you, Certified Scrum Master
Did a rm -R / to find out that I lost my entire Linux installation!
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46375
One thread per question please. I presume Rob or Steve or Jesper will lock this thread.
I agree. Here's the link:
subject: Converting Excel Workbook to PDF
It's not a secret anymore!