设置打印属性
//边距0.05为0.1 1边距=1/2-0.1
WritableSheet sheet=work.createSheet("sheelt1",0);
//param 1打印方向方向 2纸张大小 3页眉 4页脚
sheet.setPageSetup(PageOrientation.PORTRAIT, PaperSize.A4,1.0,1.0);
SheetSettings sheetS= sheet.getSettings();
sheetS.setTopMargin(0.4);
sheetS.setLeftMargin(0.2);
sheetS.setRightMargin(0.2);
sheetS.setBottomMargin(0.4);
outSheet.mergeCells(1, 1, 1, 5); //合并单元格,参数格式(开始列,开始行,结束列,结束行)
//边距0.05为0.1 1边距=1/2-0.1
WritableSheet sheet=work.createSheet("sheelt1",0);
//param 1打印方向方向 2纸张大小 3页眉 4页脚
sheet.setPageSetup(PageOrientation.PORTRAIT, PaperSize.A4,1.0,1.0);
SheetSettings sheetS= sheet.getSettings();
sheetS.setTopMargin(0.4);
sheetS.setLeftMargin(0.2);
sheetS.setRightMargin(0.2);
sheetS.setBottomMargin(0.4);
outSheet.mergeCells(1, 1, 1, 5); //合并单元格,参数格式(开始列,开始行,结束列,结束行)