下面程序得到的结果是:
Sheet 1
Formula in B1 value: 0 formula: A1+A2为什么value为0?怎么得到97?
Workbook wb=Workbook.getWorkbook(file);
try
{
OutputStreamWriter osw = new OutputStreamWriter(System.out, "UTF8");
BufferedWriter bw = new BufferedWriter(osw);
ArrayList parseErrors = new ArrayList();
Sheet s = wb.getSheet(0);
bw.write(s.getName());
bw.newLine(); Cell[] row = null;
Cell c = null; row = s.getRow(0);
c = row[1];
if (c.getType() == CellType.NUMBER_FORMULA ||
c.getType() == CellType.STRING_FORMULA ||
c.getType() == CellType.BOOLEAN_FORMULA ||
c.getType() == CellType.FORMULA_ERROR)
{
FormulaCell nfc = (FormulaCell) c;
StringBuffer sb = new StringBuffer();
CellReferenceHelper.getCellReference(c.getColumn(), c.getRow(), sb); try
{
bw.write("Formula in " + sb.toString() +
" value: " + c.getContents());
bw.flush();
bw.write(" formula: " + nfc.getFormula());
bw.flush();
bw.newLine();
}
catch (FormulaException e)
{
bw.newLine();
parseErrors.add(sb.toString() + ": " + e.getMessage());
}
}
Sheet 1
Formula in B1 value: 0 formula: A1+A2为什么value为0?怎么得到97?
Workbook wb=Workbook.getWorkbook(file);
try
{
OutputStreamWriter osw = new OutputStreamWriter(System.out, "UTF8");
BufferedWriter bw = new BufferedWriter(osw);
ArrayList parseErrors = new ArrayList();
Sheet s = wb.getSheet(0);
bw.write(s.getName());
bw.newLine(); Cell[] row = null;
Cell c = null; row = s.getRow(0);
c = row[1];
if (c.getType() == CellType.NUMBER_FORMULA ||
c.getType() == CellType.STRING_FORMULA ||
c.getType() == CellType.BOOLEAN_FORMULA ||
c.getType() == CellType.FORMULA_ERROR)
{
FormulaCell nfc = (FormulaCell) c;
StringBuffer sb = new StringBuffer();
CellReferenceHelper.getCellReference(c.getColumn(), c.getRow(), sb); try
{
bw.write("Formula in " + sb.toString() +
" value: " + c.getContents());
bw.flush();
bw.write(" formula: " + nfc.getFormula());
bw.flush();
bw.newLine();
}
catch (FormulaException e)
{
bw.newLine();
parseErrors.add(sb.toString() + ": " + e.getMessage());
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货