Hi Michel,

This is also possible to achieve using JExcel and again using Range's peer object. The following example demonstrates it:

Worksheet worksheet = ...;
 
long[][] data = {{2, 4}, {5, 1}, {3, 4}, {6, 2}};
worksheet.fillWithArray("A1:B4", data);
 
final com.jniwrapper.win32.jexcel.Range range = worksheet.getRange("C1:C4");
range.getOleMessageLoop().doInvokeAndWait(new Runnable() {
    public void run() {
        range.getPeer().setFormulaArray(new Variant("=A1:A4+B1:B4"));
    }
});

In the next version of JExcel we will add the appropriate method to the com.jniwrapper.win32.jexcel.Range class.

Please let me know if you have any further questions.

-Serge