开发者

Junk contents from formula based cell using JXL api in JAVA

开发者 https://www.devze.com 2022-12-10 16:17 出处:网络
I am facing a problem while getting contents of cell using JXL api, if I am using formula in xls sheet. Right now I am using formula - IF($L10=\"\",\"\",+ROUND($L10*1.375,3)) in each

I am facing a problem while getting contents of cell using JXL api, if I am using formula in xls sheet. Right now I am using formula - IF($L10="","",+ROUND($L10*1.375,3)) in each cell but when the cell value is blank i am getting junk charactes when i call cell.getContents() method, the code snip is as follows - >>

Workbook = Workbook.getWorkbook(p_sourceFile);

excelsheet = workbook.getSheet(0);
for (int row = 1; row < noOfRows; row++) 
{ 
   cell = excelsheet.getCell(col, row);
   content 开发者_如何转开发= cell.getContents();

   System.out.println("content-" + content); //Is giving me junk character ? when the cell value is blank.

   ...

It will be a great help if anyone can help me !!!

Regards, Amit


Try this:

NumberFormulaCell cell = (NumberFormulaCell) excelsheet.getCell(col, row);
content = cell.getValue();

From the JavaDocs for Cell.getContents():

Quick and dirty function to return the contents of this cell as a string. For more complex manipulation of the contents, it is necessary to cast this interface to correct subinterface

The necessary subinterface for a numerical formula is NumberFormulaCell. If you want to get the formula as a String then call cell.getFormula().

I'm not sure if I'm really answering your question here or not. If I'm not, could you post these junk characters that get printed out, please?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号