Insert Image to Excel Footer

[tonys123]

Hi

We are doing an inhouse java development. We are invoking Excel and are trying to insert an image into the footer. We have tried various libraries and have considered using .NET code adapted to VB Script but have not had any luck. Has anyone else encountered this problem and is their a solution?

Thanks

 

[Diancecht]

You could use http://poi.apache.org/&sa=U&ei=G15DT-2XPKK90QX9uLGPDw&ved=0CB4QFjAB&usg=AFQjCNHHtSb2UUXZNGQFlB1a_Oz5_xo1rA]Apache POI[/url] as shown here but I really wonder if Java is the best option for you

Cheers,
Dian

 

[tonys123]

Thanks for the reply. We had already tried this but unfortunately it doesn't work as the HeaderFooter class and Footer interface only allow strings to be added; they do not allow images/pictures... or are we missing a trick here?

 

[Diancecht]

Hum, looks like there's no direct way to do it. Maybe this helps.

Did you consider using a template?

Cheers,
Dian