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

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks