One option is to output the value of your variable into some cell and then just use a formula to multiply two cell values.
The other option would be to use injected POI objects (http://jxls.sourceforge.net/reference/poiaccess.html) to access the value of the cell with POI API and multiply it by your value.
--
Regards,
Leo
Wednesday, June 1, 2011, 6:54:08 PM, you wrote:
| How can I use one of the variable value to multiply with one of the cell value? What’s the _expression_ syntax? I have a variable myValue and I would like to multiply that with a cell value B1. So the cell C1 should be something like B1*myValue. What’s the equivalent jxls syntax? Thank you. Hiren Pathak |
------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev
_______________________________________________ jXLS-user mailing list jXLS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jxls-user
