The first thing that springs to mind could be character encodings? Secondly,
it could be that you are encoutering problems with forbidden characters in
file or folder names - I know that the [ and ] characters are disallowed in
Windows for example - though why this would cause what you are seeing I do
not know. Finally, have you tried calling the getStringCellValue() method
just to see what that returns? I know that you are dealing with a formula
cell but it would be interesting to see what the outcome is.
Aside from that, I am stumped, sorry.
brianireland wrote:
>
> Reading a cell formula value that includes a link to another excel file,
> very common
> for most of the excel files I work with, causes unusual returned string.
>
> e.g. Excel cell contains the following formula:
> ='C:\[poiTest.xls]HSSF Test'!$A$6
>
> Read the formula value using POI 3.5 beta, print it to Eclipse console,
> get:
> '[poiTest.xls]HSSF Test'!$A$6
>
> The C:\[ appears to be replaced with a square bracket and a little square
> (dont know what it is).
>
> Code used is:
>
> String formulaString = cell.getCellFormula();
> System.out.println ("String value: " + formulaString);
>
> Any help appreciated.
>
> Brian
>
--
View this message in context:
http://www.nabble.com/Formula-value-contains-a-link---not-reading-properly-tp22165667p22181073.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
