Hi Mark, Thank you for your reply. After writing my initial post I started looking at the use of template files, and it turns out this was the way to go. Every feature that was requested succeeded and the final report file is great :jumping:.
Thanks again, Jochen MSB wrote: > > I must admit that I would use a template file to do this because I am not > aware of any technique that will allow you to insert pictures into the > footer using POI. Simply create a new Workbook using Excel, set the > margins as you want them and save it away. All you need to do then is open > the workbook using POI and populate the sheet(s). > > Just a word of warning - possibly - pictures in headers and footers were > not supported in versions prior to 2002 - I think. Before that time, you > have to use a trick to fool Excel into placing the image into a > hearder/footer and so you risk creating files that may not - and I > emphasise the may bit - be completely compatible with older versions (e.g. > Excel 97/2000) of Excel. > > Yours > > Mark B > > > JochenP wrote: >> >> Hello, >> >> I currently trying to figure out if it is possible to set the margins of >> a workbook or excel document. >> I know there are two methods to set the footer margin and header margin >> on the PrintSetup class, on every sheet, but these don't seem to help. >> >> What I need to do is reduce the top, right, bottom and left margin to >> it's minimum, so more content can be printed on one page. >> >> I also tried the the autobreaks and fit-width 1, but then I don't have >> control over the paging which I need. >> >> One thing I also would like to know: Is it possible to add pictures to >> the footers? >> >> Or is there an other way, to start from a template excel file and dump my >> data in a new copy of the template? Has anyone had experience with this? >> >> Kind regards, >> >> Jochen Punie >> > > -- View this message in context: http://old.nabble.com/HSSF-workbook-print-setup-margins-tp26513632p26525831.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
