Thanks so much Darren ! The same code worked for me using HSSF.
HSSFPrintSetup ps = (HSSFPrintSetup) sheet.getPrintSetup(); sheet.setAutobreaks(true); sheet.setFitToPage(true); ps.setFitWidth((short)1); ps.setFitHeight(0) Thanks again. Regards, Rajesh -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Fwd-Need-to-setup-Print-option-Fit-All-Columns-on-One-Page-in-poi-java-code-tp5713518p5713533.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]
