Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Writing data to other cells

Anonymous
2010-07-27
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.

     

  • 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.

     
  • Peter Smith
    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