jxl-excel使用心得

  使用jxl在java中生成excel

 

 

  //excel生成路径      
   String path = "C://circdata//export";
  //创建一个名为xls文件    
  java.io.FileOutputStream  fos = new FileOutputStream(path+"//sample.xls");

 //创建一个工作薄

  jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(fos);

 //添加一个工作表,创建一个sheet

  WritableSheet ws = wwb.createSheet("sample", 10);  

//设置字体

 WritableFont wf = new WritableFont(WritableFont.TIMES,10,WritableFont.BOLD);

 

WritableCellFormat wcf = new WritableCellFormat(wf);

//设置对齐方式CENTRE为垂直对齐

 wcf.setVerticalAlignment(VerticalAlignment.CENTRE);

wcf.setAlignment(Alignment.CENTRE);

//设置边框(All,Left,Right,BOTTOM,Top,None)

wcf.setBorder(Border.RIGHT,BorderLineStyle.THIN);

//设置单元格颜色

wcf.setBackground(jxl.format.Colour.YELLOW);

//合并单元格,合从0 列到8列,27行到29行

 ws.mergeCells(0, 27, 8, 29);

//填充数据,经一行第一列(行和列与数组下标相同,从0开始)

ws.addCell(new Label(0,0,"sample",wcf));

//设置为A4纸打印,PORTRAIT为纵向打印

ws.setPageSetup(PageOrientation.PORTRAIT, PaperSize.A4,1.0,1.0);

 //设置页面距

SheetSettings sheetS= ws.getSettings();
              
                sheetS.setTopMargin(0.4);
                sheetS.setLeftMargin(0.25);
                sheetS.setRightMargin(0.2);
                sheetS.setBottomMargin(0.4);