Printing large excel sheets using POI

[Babu Rajendra Prasath Haridass]

Here is the sample code for printing large excel sheets using POI.

   
                sheet.setHorizontallyCenter(true);
                sheet.setAutobreaks(true);
                sheet.setFitToPage(true);

                PrintSetup printSetup = sheet.getPrintSetup();
                printSetup.setLandscape(true);
                printSetup.setPaperSize(PrintSetup.A4_PAPERSIZE);

                short numberOfPagesDataSpans = (short)(totalNumberOfRows/ 27);
                printSetup.setFitHeight( numberOfPagesDataSpans );
                printSetup.setFitWidth((short) 1);

[Paul Clapham]

And your question is?