How To: Picture in HSSFHeader or HSSFFooter

Sep 27, 2009 at 6:15 PM

I can see how to insert an image in a sheet by anchoring to cells, but how can I use an image added to a  workbook in a header/footer?

Sep 28, 2009 at 10:03 PM
Edited Sep 28, 2009 at 10:04 PM

This is out of the support boundary of POI and NPOI. To support images in header and footer, we have to teach NPOI identify another record called HFPicture (sid=2150). It's suggested that you create a xls with pictures in header as a template. Then read it using NPOI.

Anyway, I'll consider implementing it in a future release.

Sep 28, 2009 at 10:04 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Sep 28, 2009 at 11:05 PM

Hi Tony,

Googling for HFPicture has yeilded the results I need to modify the source to include this capability. If I figure it out, I'll post back with the code.

Many thanks!