使用POI生成Excel文档并设置打印样式

package test;
 2
 3import java.io.FileOutputStream;
 4import java.io.IOException;
 5
 6import org.apache.poi.hssf.usermodel.HSSFCell;
 7import org.apache.poi.hssf.usermodel.HSSFCellStyle;
 8import org.apache.poi.hssf.usermodel.HSSFFont;
 9import org.apache.poi.hssf.usermodel.HSSFPrintSetup;
10import org.apache.poi.hssf.usermodel.HSSFRichTextString;
11import org.apache.poi.hssf.usermodel.HSSFRow;
12import org.apache.poi.hssf.usermodel.HSSFSheet;
13import org.apache.poi.hssf.usermodel.HSSFWorkbook;
14
15public class ExcelTest {
16
17    public static void main(String[] args) throws IOException {
18        
19         // create a new file  
20         FileOutputStream out = new FileOutputStream("D:/workbook.xls");  
21         // create a new workbook  
22         HSSFWorkbook wb = new HSSFWorkbook();  
23         // create a new sheet  
24         HSSFSheet sheet = wb.createSheet();  
25           
26         //2.model  
27         HSSFRow row = sheet.createRow(2);  
28         row.setHeightInPoints(20);  
29         HSSFCell cell = row.createCell(2);  
30         HSSFFont cnFont = wb.createFont();  
31         cnFont.setFontHeightInPoints((short) 10);  
32         //font.setFontName("汉仪报宋简");  
33         cnFont.setFontName("隶书");  
34         HSSFCellStyle cnStyle = wb.createCellStyle();  
35         cnStyle.setFont(cnFont);  
36         cell.setCellStyle(cnStyle);  
37         HSSFRichTextString richText = new HSSFRichTextString("中文字体测试");  
38         cell.setCellValue(richText);  
39         HSSFCell enCell = row.createCell(3);  
40         HSSFFont enFont = wb.createFont();  
41         enFont.setFontHeightInPoints((short) 10);  
42         enFont.setFontName("Arial Black");  
43         HSSFCellStyle enStyle = wb.createCellStyle();  
44         enStyle.setFont(enFont);  
45         enCell.setCellStyle(enStyle);  
46         enCell.setCellValue(new HSSFRichTextString("English font test"));  
47         sheet.setColumnWidth(2, 4000);  
48         sheet.setColumnWidth(3, 4000);
49         
50         //3.output  
51         sheet.setDisplayGridlines(false);  
52         sheet.setPrintGridlines(false);  
53         HSSFPrintSetup printSetup = sheet.getPrintSetup();  
54         //A4纸
55         printSetup.setPaperSize(HSSFPrintSetup.A4_PAPERSIZE);  
56         wb.write(out);  
57         out.close(); 
58    }
59}

HSSFSheet fromsheet = wb.getSheetAt(0); //模版页
            for(int num=0;num<addSheetNum;num++)//新增
            {
                String numStr = String.valueOf(num+2);

                HSSFSheet newsheet = wb.createSheet("第"+numStr+"页");  
                //设置打印参数  
                newsheet.setMargin(HSSFSheet.TopMargin,fromsheet.getMargin(HSSFSheet.TopMargin));// 页边距（上）  
                newsheet.setMargin(HSSFSheet.BottomMargin,fromsheet.getMargin(HSSFSheet.BottomMargin));// 页边距（下）  
                newsheet.setMargin(HSSFSheet.LeftMargin,fromsheet.getMargin(HSSFSheet.LeftMargin) );// 页边距（左）  
                newsheet.setMargin(HSSFSheet.RightMargin,fromsheet.getMargin(HSSFSheet.RightMargin));// 页边距（右  

                HSSFPrintSetup ps = newsheet.getPrintSetup();  
                ps.setLandscape(false); // 打印方向，true：横向，false：纵向(默认)  
                ps.setVResolution((short)600);  
                ps.setPaperSize(HSSFPrintSetup.A4_PAPERSIZE); //纸张类型  
                
                SheetFunc.copyRows(wb, 0, num+1,0 , 46, 0);//复制
                wb.getSheetAt(num+1).setColumnWidth((short)0, (short)2400);//256,31.38
            }