HSSFPrintSetup ps = sheet.getPrintSetup();
ps.setLandscape(false); //打印方向,true:横向,false:纵向
ps.setPaperSize(HSSFPrintSetup.A4_PAPERSIZE); //纸张
sheet.setHorizontallyCenter(true);//设置打印页水平居中
//sheet.setVerticallyCenter(true); //设置打印页面为垂直居中
sheet.setMargin(HSSFSheet.BottomMargin, (double)1.0); //下
sheet.setMargin(HSSFSheet.LeftMargin, (double)0.7);//左
sheet.setMargin(HSSFSheet.RightMargin, (double)0.7); //右
sheet.setMargin(HSSFSheet.TopMargin, (double)1.0); //上
HSSFFooter footer =sheet.getFooter();
ps.setLandscape(false); //打印方向,true:横向,false:纵向
ps.setPaperSize(HSSFPrintSetup.A4_PAPERSIZE); //纸张
sheet.setHorizontallyCenter(true);//设置打印页水平居中
//sheet.setVerticallyCenter(true); //设置打印页面为垂直居中
sheet.setMargin(HSSFSheet.BottomMargin, (double)1.0); //下
sheet.setMargin(HSSFSheet.LeftMargin, (double)0.7);//左
sheet.setMargin(HSSFSheet.RightMargin, (double)0.7); //右
sheet.setMargin(HSSFSheet.TopMargin, (double)1.0); //上
HSSFFooter footer =sheet.getFooter();
footer.setCenter(footer.page()+"/"+footer.numPages());//设置页脚
book.setRepeatingRowsAndColumns(0, -1, -1, 0, 3); //设置标题行说明参数的意思分别是sheetIndex,startColumn,endColumn,startRow,endRow
sheet.addMergedRegion(new CellRangeAddress(2,2,0,4));//合并单元格
sheet.setColumnWidth(0, 2000);/设置列宽度