Hello Lior, HSSFWorkbook wb = new HSSFWorkbook(); HSSFPrintSetup ps = wb.getPrintSetup(); To make page layout landscape: ps.setLandscape(true); To set print area to one page: ps.setFitHeight((short)1); ps.setFitWidth((short)1); You should occasionally look into Busy Developer's Guide. It answers many of questions to HSSF. And here is the link http://jakarta.apache.org/poi/hssf/quick-guide.html Regards, Andrew --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
