Dear All,
I was confronted with the following use case: I am using some expressions to
retrieve data in an excel template depending on some parameters (for example
dates), and I would like to be able to pass parameters by directly referencing
cells of the current workbook.
For example, I could have an object 'values' with a 'get' method returning
numbers depending on a date parameter, and write:
${ values.get("1/1/2015") }
It would be obviously extremely helpful to be able to reference cells of the
workbook in such expressions, for example to retrieve the date in the above
example from another cell.
Of course we have the 'sheet' variable which is defined in the context, but
querying it directly gives rise to overly complex syntaxes for users.
One solution is to adapt the method values.get(...) so that it is able to parse
references, like in:
${ values.get("A5") }
assuming that cell A5 contains a date so that we get the same value than in the
first example. This approach requires the class of the 'values' object to have
a reference to the sheet but it is feasible. The same could be implemented to
reference named cells and ranges.
As far as I see, there is no better method to achieve this kind of use cases.
Do you confirm? Or can you suggest alternative approaches?
Many thanks!
Carlo
------------------------------------------------------------------------------
_______________________________________________
jXLS-user mailing list
jXLS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jxls-user
