SXSSWorkbook下载
1.创建SXXWorkbook对象
//创建工作簿
SXSSFWorkbook workBook = new SXSSFWorkbook();
2.创建sheet对象
//创建工作表
Sheet sheet = workBook.createSheet("账单");
PrintSetup printSetup = sheet.getPrintSetup();
printSetup.setFitWidth((short)1);
printSetup.setPaperSize(PrintSetup.A4_PAPERSIZE);
printSetup.setScale((short)60);
printSetup.setLeftToRight(true);
sheet.setMargin(Sheet.TopMargin, 0);
sheet.setMargin(Sheet.BottomMargin, 0);
sheet.setMargin(Sheet.LeftMargin, 0);
sheet.setMargin(Sheet.RightMargin, 0)