I need to be able to write back to cells other than the one the function was invoked from, for example: copy(A1:C1,A2:C2), but I can't see anyway of doing this from looking at the (Java) source.
Just started looking at JXLL - is it possible to extend the references to allow read/write?
Any advice/help here would be really great - I'm desperate to start using this fantastic tool.
In some example code there's a function ListFiles - it returns an array but only the first element is written into the cell.
You need to use Ctrl-Shift-Enter when evaluating a range from a single function. So type in your function, then select the range you want the results to appear int, press F2, then press Ctrl-Shift-Enter.
Hope that helps.
Log in to post a comment.