On Wed, 19 Dec 2007, ramilani12 wrote:
The API POI support VLOOKUP?
Not for formula evaluations
http://svn.apache.org/repos/asf/poi/trunk/src/scratchpad/src/org/apache/poi/hssf/record/formula/functions/Vlookup.java
"public class Vlookup extends NotImplementedFunction"
You'll either need to implement the vlookup function yourself (and if so,
please send in the code so we can add it to svn!), or trigger a
calculation of the formula yourself when opening the sheet in excel
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]