tags:

views:

393

answers:

1
Q: 

Java Excel API: Add images to the footer of excel files

I've got a bunch of huge excel reports created by JExcel. Now the company's styleguide has changed and somebody had the great idea to add some logos to the footer. Unfortunately, adding images to the header or footer is not possible with JExcel. As a workaround, I am currently modifying the PDF files created from the Excel files with iText and adding images to each page. The problem still remains: There is no image in the footer of the Excel file, only in the PDF file.

Has anybody an idea how to get rid of this problem? Is there any other free (?) Java Excel API that might help? I've tried Apache POI but without success.

Thanks in advance!

A: 

As you can modify excel files with both Apache POI and JExcel why don't you use a template file already containing the logo in the footer ?

pgras  2009-09-08 16:37:33
I've already tried to use a template with an image inside the footer. unfortunately, the image inside the footer (not any footer text) gets lost after writing the excel file.
Willy  2009-09-09 07:04:28
I've just tried to add an image inside a footer but it isn't possible with my version of Excel (2000). What version of excel are you using ? If it's 2007 have you tried the template file method with POI and the XSSF API ? It's the only one that support excel 2007.
pgras  2009-09-09 10:36:25
I'm using Excel 2003 and templates created with Excel 2003.The problem is that JExcel and POI as well don't even allow to add anything except text to footer objects.
Willy  2009-09-12 10:41:52

related questions

Java Time Zone is messed up
Eclipse on win64
Automate builds for Java RCP for deployment with JNLP
Why are professors or schools picking Java over C++ to teach to students?
Is there a real benefit of using J#?
Public/Popular Websites using JavaServer Faces
Why can't I use a try block around my super() call?
Accessing post variables using Java Servlets
Personal Linux web server
Is this really widening vs autoboxing?
How can I Java webstart multiple, dependent, native libraries?
Why can't I call toString() on a Java primitive?
How do I use Java to read from a file that is actively being written?
What code analysis tools do you use for your Java projects?
IllegalArgumentException or NullPointerException for a null parameter?
How do I configure and communicate with a serial port?
What is the best way to parse strings in Java
Getting started with a custom JXTA PeerGroup
Creating a custom button in Java
How to get started "writing" a code coverage tool?
Which Build-/Configuration Management Tool?
What is the difference between an int and an Integer in Java/C#?
What is the meaning of the type safety warning in certain Java generics casts?
How would you access Object properties from within an object method?
Converting CSV File to XML in Java