Hi Mark! I am using the XSSF-API to Create Excel2007-Workbooks.
Jochen -----Ursprüngliche Nachricht----- Von: MSB [mailto:[email protected]] Gesendet: Freitag, 12. Februar 2010 17:09 An: [email protected] Betreff: Re: Landscape format and Upright format Can I ask please which API you are using; HWPF, XWPF, HSSF or XSSF? That way, we will know which methods to reccommed you use. Just in case you are trying to create a binary Excel workbook using HSSF, try to call the getPrintSetup() method from an instance of the HSSFSheet class and then call the setLandscape(boolean) method defined on that HSSFPrintSetup object the former method will return. Pass true to that method to set the pages' orientation to landscape or false to set it to portrait. Yours Mark B PS The same methods are defined on the XSSFSheet class so you can do something similar there also. Rinck Jochen wrote: > > Hello, > > > > how can I set the format of a sheet in a workbook to landscape format or > to upright format? > > > > Thanks, > > Jochen Rinck > > > > > > > -- View this message in context: http://old.nabble.com/Landscape-format-and-Upright-format-tp27559791p27565763.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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
