java jxl

1、设置单元格的宽度：

WritableSheet sheetWrite=writeWorkbook.createSheet(pdName,i);
   sheetWrite.setColumnView(0, 4);//设置第一列的宽度为4
   sheetWrite.setColumnView(1, 23);//设置第二列的宽度为23
2、设置字体
WritableFont fontNormal= new WritableFont(WritableFont.ARIAL,11);
    WritableCellFormat cellFormat=new WritableCellFormat(fontNormal);
    cellFormat.setAlignment(jxl.format.Alignment.LEFT);
    cellFormat.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);
    cellFormat.setWrap(true);
    label.setCellFormat(cellFormat);
    sheetWrite.addCell(label);
3、单元格居右
     Label label=new Label(column,row,labelValue);
    WritableCellFormat cellFormat=new WritableCellFormat();
    cellFormat.setAlignment(jxl.format.Alignment.RIGHT);
    label.setCellFormat(cellFormat);
    sheetWrite.addCell(label);