Migrate from GitHub to SourceForge with this tool. Check out all of SourceForge's recent improvements.

Writing data to other cells

  • Anonymous

    Anonymous - 2010-07-27


    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

    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


    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.