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

Question

程序的功能是将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();

Answer 1

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

Answer 2

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(); //具体的你再调整一下。