JXL 如何创建数值型的excel表格！！

Question

是这样的，我用jxl创建了一个excel表格，但是我不知道怎么创建数值型的，默认创建的好像是文本型的吧，大家知道的请告诉我下，谢谢了。我的代码如下：
public static void  writeExcelBo(String fos, HashMap<String, Integer> hash, HashMap<String, Integer> hash1)
    {
     jxl.write.Number number;
     jxl.write.WritableWorkbook wwb;
     try
     {
      wwb= Workbook.createWorkbook(new File(fos));
      jxl.write.WritableSheet ws= wwb.createSheet("数据统计", 1);
      jxl.write.WritableSheet wss= wwb.createSheet("彩信中心", 2);
      ws.addCell(new jxl.write.Label(0, 0, "号码"));
      ws.addCell(new jxl.write.Label(1, 0, "短信条数"));
      wss.addCell(new jxl.write.Label(0, 0, "号码"));
      wss.addCell(new jxl.write.Label(1, 0, "接收彩信中心"));
      wss.addCell(new jxl.write.Label(2, 0, "对应次数"));
      Set<String> set = hash.keySet();  
      Set<String> set1 = hash1.keySet();
      int i=0;
      int j=0;
      for (String key : set) {   
          i++;
          ws.addCell(new jxl.write.Label(0, i, key));
          ws.addCell(new jxl.write.Label(1, i, new Integer(hash.get(key)).toString()));
      }  
      for (String key : set1) {   
          j++;
          wss.addCell(new jxl.write.Label(0, j, key.split(" ")[0]));
          wss.addCell(new jxl.write.Label(1, j, key.split(" ")[1]));
          wss.addCell(new jxl.write.Label(2, j, new Integer(hash1.get(key)).toString()));
      }
      wwb.write();
      // 关闭Excel工作薄对象
      wwb.close();
     } catch (IOException e){
     } catch (RowsExceededException e){
      
     } catch (WriteException e){
     }
    }

Answer 1

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(0, 2, 3.1415926, wcfN);
sheet.addCell(labelNF);

Answer 2

参考JXL

Answer 3

jxl.write.Number number = new jxl.write.Number(1, 0, 123.111);
sheet.addCell(number);