XLS to PDF conversion

**nitin2k2k** · 12-26-2008, 10:39 PM

Hi,

I have an MS-EXCEL file. I want to convert it into PDF file.
Please help me. Is there any java API available for the same?

Regards
Nitin

**CJSLMAN** · 12-27-2008, 01:52 AM

Just Google "excel to pdf" ... plenty of options. As for a Java API that does this directly, I don't know of any (I'm sure there isn't anything). What you can do is execute the application that does the convertion from a Java program.

Luck,
CJSL

**Eranga** · 12-27-2008, 03:43 AM

Nitin, please don't post the same question multiple times in the forum. That's not good. Please read our FAQ page before posting again. Select the correct sub-forum next time before posting your question.

**zett** · 01-27-2009, 05:07 PM

import officetools.OfficeFile;
...
FileInputStream fis = new FileInputStream(new File("test.xls"));
FileOutputStream fos = new FileOutputStream(new File("test.pdf"));
OfficeFile f = new OfficeFile(fis,"localhost","8100", true);
f.convert(fos,"pdf");

**Eranga** · 01-28-2009, 04:58 AM

This is not a standard API in JDK. So better to send any download link or something here, it can be really helpful to all members who are looking at your replay zett.

**Thennarasu** · 01-28-2009, 05:24 AM

From where can i download officetools.jar?

**Eranga** · 01-28-2009, 05:27 AM

Search on the Google. Or else you have to wait until zett commenting on my previous post.

**Thennarasu** · 01-28-2009, 05:36 AM

okay thanks

**zett** · 01-28-2009, 08:34 AM

This guy is providing it on its page: dancrintea.ro/html-to-pdf/
check middle page at the section "HTML to PDF with Java".

A team in my company has used it for a project.

**Eranga** · 01-28-2009, 09:57 AM

That's pretty cool.

**zett** · 07-02-2009, 03:30 PM

Originally Posted by zett

This guy is providing it on its page: dancrintea.ro/html-to-pdf/
check middle page at the section "HTML to PDF with Java".

A team in my company has used it for a project.

In fact the real url is this one: dancrintea.ro/xls-to-pdf/

Besides converting XLS to PDF it is also possible to:
- convert DOC+PPT to PDF
- replace strings in DOC files
- read/write Excel files using simplified aAPI like getCell and setCell
- hide sheets in Excel files(hide secondary calculations for example)

The only downside is that it needs OpenOffice,

but hey..... a lot of nice things things are possible this way, so...

**RocoStar** · 02-18-2011, 09:07 PM

Nice, exactly what I was looking for.

**ultimaterinks2006** · 02-22-2011, 09:50 AM

open office has an option to save any file as pdf.We can use it for writing bulk operation code but for single file i don't think its worth writing.

**Eranga** · 03-01-2011, 04:03 PM

Originally Posted by ultimaterinks2006

open office has an option to save any file as pdf.We can use it for writing bulk operation code but for single file i don't think its worth writing.

It's worth when you want to customize applications.

**Vipinbisen** · 09-08-2011, 12:39 PM

Is there any free site to get Officetools.jar........

I went to suggested site i.e. 4shared.com, but it has Office Tools which is something else...

Please help........

**Vipinbisen** · 09-08-2011, 01:02 PM

But in this site they charge for it.
Is there any free site.........

**Eranga** · 09-13-2011, 07:26 AM

Did you search on Google?

**Vipinbisen** · 09-20-2011, 08:41 AM

Yes.......I did searching everywhere............
Now I am trying it manually..........
I am using apache POI API to read excel file and iText API to write contents to pdf file......
But problem here is that the exact formatting of excel file is not coming in pdf file.........
Please suggest if you have any better ideas............