No answer yet...

I've tried a different approach.

I have modified the MacrosSample.java and created a new workbook test.xls, both are attached.

In test.xls I have created a Visual Basic macro:

Sub Sample_Func()
    Worksheets(1).Range("A1:IV100").Value = 3.14159
    Worksheets(1).Range("C3").Value = "Tester!"
End Sub

To view it, open test.xls -> Tools -> Macro -> Visual Basic Editor. Scroll down to "ThisWorkbook" in VBAProject in the left menu if it doesnt pop up automaticly.

And in the modifed Java class MacrosSample I call the macro:

//1 Opens the workbook
workbook = application.openWorkbook(new File("data/test.xls"));
...
//2 Runs the macro: populates all the cells in A1:IV100 with the value '3,14159'
runProcedure(workbook, "ThisWorkbook.Sample_Func()")
...
//3 Saves a copy to see that values got inserted
workbook.saveCopyAs(new File("data/after_macro.xls"));

*To populate the range "A1:IV100" the macro Java times it 0 ms, so fast that the Java cant time it. Thats a range of 25 600 cells!

Now we are talking speed!*

So back to my problem.

I have a two dimensional array in Java, that I want to write to a sheet  (double[][])

Then I want to read an other range in the sheet and return it to Java (as a two dimensional double table: double[][])

And this I wanna do many times over.

*

So the idea is that if I have a VB macro which takes an array as input, then writes this array to the sheet, then reads another range and returns it back to Java.

But I doesnt know very much about VB and its syntax, so I wonder if this is possible?

*

I've read another place that you can not insert arrays directly in sheets via VB,

you'll have to assign the array to a range first and then pass a reference to it to the macro-method.

Anybody? hehe

Thanks for helping so far.

I can now insert values in the specified range, but only types of Variants, see my code.

My problem is to convert a two dimensional array to a data type that Excel will take.

I will be grateful for any help on the issue.

My code uses the same wb.xls that is in my previous post.

public class StubTest {
    private static Application application = null;
    private static Workbook workbook = null;
    
    public StubTest() {
        try {
            long time1 = System.currentTimeMillis();
            long time2 = System.currentTimeMillis();
            application = new Application();
            workbook = application.openWorkbook(new File("data/wb.xls"));
            
            Random rand = new java.util.Random();
            double[][] data = new double[23][23];
            data = new double[23][23];
            for (int i=0;i<23;i++){
                for (int j=0;j<23;j++){
                    data+[j] = rand.nextInt(10);
                }
            }
            final  double[][] data2 = data;
            
            Range range = workbook.getWorksheet(1).getRange("B46:X68");
            final com.jniwrapper.win32.excel.Range _range = range.getPeer();
            final _Workbook _workbook = workbook.getNativePeer();
            
            
            time1 = System.currentTimeMillis();
            workbook.getOleMessageLoop().doInvokeLater(new Runnable() {
                public void run() {
                                                                                final String ss = "Merry chrismast";
                    _range.setValue2(new Variant(ss)); //Want to insert my array 'data2' in the '_range'
                }
            });
            workbook.saveCopyAs(new File("data/wb_after.xls"));
            
        } catch (FileNotFoundException ex) {
            ex.printStackTrace();
        } catch (ExcelException ex) {
            ex.printStackTrace();
        } catch (IOException ex) {
            ex.printStackTrace();
        }finally{
            //following construction should be used to close excel even after exception was thrown
            if (application != null) {
                application.close();
            }
        }
        
    }
    
    
    
    
    public static void main(String[] args) {
        StubTest s = new StubTest();
    }
}

I agree with you on the -issue.

In meanwhile i'll use the quote-tag: >

I figured it out by the way, for others who want to see:

String[] stringArray= {"A string", "2", "Third element"};

SafeArray array = new SafeArray(new int[]{stringArray.length,1}, Variant.class);

rowCol = new int[2];

 

for (int i = 0; i < stringArray.length; i++) {

rowCol[1] = 0;

rowCol[0] = i;

array.set(rowCol, new Variant(stringArray));

}

Its great this issue is solved, because  the built-in-functions was way to slow.

Thanks again mike