Writing data to other cells

Brought to you by: poida_smith

Writing data to other cells

Forum: Open Discussion

Creator: Anonymous

Created: 2010-07-27

Updated: 2013-04-17

Anonymous - 2010-07-27

Hi,

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.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Anonymous - 2010-07-27

In some example code there's a function ListFiles - it returns an array but only the first element is written into the cell.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Peter Smith - 2010-11-16

Hi,

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.

Regards,
Peter

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.