java--excel的相关信息

//添加数字
  jxl.write.Number number = new jxl.write.Number(3, 4, 3.14159); //put the number 3.14159 in cell D5
  sheet.addCell(number);
  //添加带有字型Formatting的对象
  jxl.write.WritableFont wf = new jxl.write.WritableFont(WritableFont.TIMES,10,WritableFont.BOLD,true);
  jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);
  jxl.write.Label labelCF = new jxl.write.Label(4,4,"文本",wcfF);
  sheet.addCell(labelCF);
  //添加带有字体颜色,带背景颜色 Formatting的对象
  jxl.write.WritableFont wfc = new jxl.write.WritableFont(WritableFont.ARIAL,10,WritableFont.BOLD,false,jxl.format.UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.RED);
  jxl.write.WritableCellFormat wcfFC = new jxl.write.WritableCellFormat(wfc);
  wcfFC.setBackground(jxl.format.Colour.BLUE);
  jxl.write.Label labelCFC = new jxl.write.Label(1,5,"带颜色",wcfFC);
  sheet.addCell(labelCFC);
  //添加带有formatting的Number对象
  jxl.write.NumberFormat nf = new jxl.write.NumberFormat("#.##");
  jxl.write.WritableCellFormat wcfN = new jxl.write.WritableCellFormat(nf);
  jxl.write.Number labelNF = new jxl.write.Number(1,1,3.1415926,wcfN);
  sheet.addCell(labelNF);
  //3.添加Boolean对象
  jxl.write.Boolean labelB = new jxl.write.Boolean(0,2,false);
  sheet.addCell(labelB);
  //4.添加DateTime对象
  jxl.write.DateTime labelDT = new jxl.write.DateTime(0,3,new java.util.Date());
  sheet.addCell(labelDT);
  //添加带有formatting的DateFormat对象
  jxl.write.DateFormat df = new jxl.write.DateFormat("ddMMyyyyhh:mm:ss");
  jxl.write.WritableCellFormat wcfDF = new jxl.write.WritableCellFormat(df);
  jxl.write.DateTime labelDTF = new jxl.write.DateTime(1,3,new java.util.Date(),wcfDF);
  sheet.addCell(labelDTF);
  //合并单元格
  //sheet.mergeCells(int col1,int row1,int col2,int row2);//左上角到右下角
  sheet.mergeCells(4,5,8,10);//左上角到右下角
  wfc = new jxl.write.WritableFont(WritableFont.ARIAL,40,WritableFont.BOLD,false,jxl.format.UnderlineStyle.NO_UNDERLINE,jxl.format.Colour.GREEN);
  jxl.write.WritableCellFormat wchB = new jxl.write.WritableCellFormat(wfc);
  wchB.setAlignment(jxl.format.Alignment.CENTRE);
  labelCFC = new jxl.write.Label(4,5,"单元合并",wchB);
  sheet.addCell(labelCFC); //

  //设置边框
  jxl.write.WritableCellFormat wcsB = new jxl.write.WritableCellFormat();
  wcsB.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THICK);
  labelCFC = new jxl.write.Label(0,6,"边框设置",wcsB);
  sheet.addCell(labelCFC);
 
  //也可以加多个format
  Label lable = new Label(11,11,"formate");
        WritableCellFormat blueFomat = new WritableCellFormat();
        blueFomat.setBackground(Colour.BLUE);
        blueFomat.setAlignment(Alignment.CENTRE);
  blueFomat.setBorder(Border.ALL, BorderLineStyle.THIN);
  lable.setCellFormat(blueFomat);
  sheet.addCell(lable);
 
 
  book.write();
  book.close();
 }
}
 
 
//自动调整列宽
获取字符串长度，然后再设置setColumnView，
byte[] bstrLength = rs.getString(j).getBytes(); //中文字符算两个字节
sheet.setColumnView(j-1, bstrLength.length+2);