Hi Mark! It works fine!
Thank you! Jochen -----Ursprüngliche Nachricht----- Von: MSB [mailto:[email protected]] Gesendet: Montag, 15. Februar 2010 08:34 An: [email protected] Betreff: Re: AW: Landscape format and Upright format Ah good, you should stil be able to get the print setup object from the sheet and set the page orientation on that with XWPF; must admit that I have not done this with XWPF yet but remain confident that it will work successfully. Yours Mark B Rinck Jochen wrote: > > 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] > > > -- View this message in context: http://old.nabble.com/Landscape-format-and-Upright-format-tp27559791p27590342.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]
