Following code snippet demonstrate setting up the printable area of an EXCEL using Apache POI.

XSSFWORKBOOK WORKBOOK = new XSSFWorkbook(); 

XSSFSheet spreadsheet = workbook

.createSheet("PRINT Area");

//set print area with indexes

workbook.setPrintArea(

0, //sheet index

0, //start column

5, //end column

0, //start ROW

5 //end row

);

//set paper size

spreadsheet.getPrintSetup().setPaperSize(

XSSFPrintSetup.A4_PAPERSIZE);

//set display grid lines or not

spreadsheet.setDisplayGridlines(true);

//set print grid lines or not

spreadsheet.setPrintGridlines(true);

Following code snippet demonstrate setting up the printable area of an excel using Apache POI.

XSSFWorkbook workbook = new XSSFWorkbook(); 

XSSFSheet spreadsheet = workbook

.createSheet("Print Area");

//set print area with indexes

workbook.setPrintArea(

0, //sheet index

0, //start column

5, //end column

0, //start row

5 //end row

);

//set paper size

spreadsheet.getPrintSetup().setPaperSize(

XSSFPrintSetup.A4_PAPERSIZE);

//set display grid lines or not

spreadsheet.setDisplayGridlines(true);

//set print grid lines or not

spreadsheet.setPrintGridlines(true);