******如何得到excel单元格的值？在线等待******

[wlily875]

WritableWorkbook w = Workbook.createWorkbook(new File("jxlrwtest.xls"));
WritableSheet ws = w.createSheet("Sheet 1", 0);
Number nc;
nc = new Number(0,0,20);
ws.addCell(nc);
nc = new Number(0,1,77);
ws.addCell(nc);
Formula f = new Formula(1,0, "A1+A2");
ws.addCell(f);
w.write();
System.out.println("parse:"+f.getContents());
w.close();

f.getContents()为“A1+A2”,如何得到"97"(即：20+77)？

[zxhong]

http://www.javaworld.com/javaworld/javaqa/2001-08/02-qa-0824-excel2.html

[wlily875]

程序的功能是将20放入A1,77放入A2,使B1＝A1+A2，想取出B1的值

import jxl.Workbook;
import jxl.write.WritableWorkbook;
import jxl.write.WritableSheet;
import jxl.write.Formula;
import jxl.write.Number;

WritableWorkbook w = Workbook.createWorkbook(new File("jxlrwtest.xls"));
WritableSheet ws = w.createSheet("Sheet 1", 0);
Number nc;
nc = new Number(0,0,20);
ws.addCell(nc);
nc = new Number(0,1,77);
ws.addCell(nc);
Formula f = new Formula(1,0, "A1+A2");
ws.addCell(f);
w.write();
System.out.println("parse:"+f.getContents());
w.close();

[bluesmile979]

Workbook workbook = Workbook.getWorkbook(new File("myfile.xls"));

Sheet sheet = workbook.getSheet(0);

Cell a = sheet.getCell(1,0);

DOUBLE numberb2 = a.getValue();

workbook.close(); //具体的你再调整一下。