java - I'm getting the formula instead of the cell content -


this question has answer here:

i have code:

string fname = "c:/users/slim/desktop/xlsxfiles/plan.xlsx";              inputstream inp = new fileinputstream(fname);             workbook  wb = new xssfworkbook(inp);             sheet sheet = wb.getsheetat(0);              (row row : sheet) {                 system.out.println(row.getcell(0));                 system.out.println(row.getcell(11));             }

the problem i'm facing seems kinda weird me, because first time dealing poi.

the content of cell 0 date , have no problems @ all, content of cell 11 wich supposed number returning formula used content. here sample output:

31-aug-2013 l3/5 30-sep-2013 l3*2/5 31-oct-2013 l3*3/5 30-nov-2013 l3*4/5 31-dec-2013 l3 31-jan-2014 p8 28-feb-2014 p9 31-mar-2014 p10

and on...

what need show actual content of cell, not formula. i'm sure i'm missing small, complete beginner, i'm not able spot it.

the actual content of cell formula; excel doesn't show (instead, shows result of evaluating formula).

this document explains how calculate formula often, isn't necessary because excel saves last calculated value along formula.

so getcell(11).getnumericcellvalue() might enough.

note method throws exceptions when being used on cells text.


Comments

Post a Comment

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more

rewrite - Trouble with Wordpress multiple custom querystrings -

i'm working on adding multiple querystring , doesn't seem work. i've found codes seems work others might i'm missing something. i want like: http://mydomain.com/board/?getyear=2013&getsometext2=sometext to http://mydomain.com/board/2013/sometext/ i added code below functions.php file. doesn't seem work should though. this works. echoing querystring gets both variable without problem. http://mydomain.com/board/2013/sometext/ but doesn't. tested querystring vis isset() seems nothing being set/get http://mydomain.com/board/2013/ function add_query_vars($vars) { $vars[] = "getyear"; $vars[] = "getsometext2"; return $vars; } add_filter('query_vars', 'add_query_vars'); function add_rewrite_rules($arules) { $anewrules = array('board/([^/]+)/([^/]+)/?$' => 'index.php?pagename=board&getyear=$matches[1]&getsometext2=$matches[2]'); $arules = $a...
Read more