Geek Answers Handbook

Is there a good link to use OLE Automation (from Java)?

I am trying to communicate with Excel from a Java / SWT application. I was able to open the worksheet, open the file and save it, but more on that.

Can someone point me some docs / examples for this? I especially need to know which teams are available. I tried to write macros for verification. It was useful, but it did not give me everything that I wanted.

This is an example of what I have tried so far:

private static OleAutomation openFile(
        OleAutomation automation, String fileName) {
    Variant workbooks = automation.getProperty(0x0000023c);// get User
                                                            // Defined
                                                            // Workbooks
    Variant[] arguments = new Variant[1];

    arguments[0] = new Variant(fileName);
    System.out.println("workbooks::\t" + workbooks);

    IDispatch p1 = workbooks.getDispatch();
    int[] rgdispid = workbooks.getAutomation().getIDsOfNames(new String[] { "Open" });
    int dispIdMember = rgdispid[0];
    Variant workbook = workbooks.getAutomation().invoke(dispIdMember, arguments);
    System.out.println("Opened the Work Book");
    try {
        Thread.sleep(500);
    } catch (InterruptedException e) {
        e.printStackTrace();
    }
    int id = workbook.getAutomation().getIDsOfNames(new String[] { "ActiveSheet" })[0];
    System.out.println(id);
    Variant sheet = workbook.getAutomation().getProperty(id);
    OleAutomation sheetAutomation = sheet.getAutomation();

    return (sheetAutomation);
}
+1
source share
2 answers

, : OLE/COM-, Windows 2000? .

+1

VBA help MSOffice. Office VB.

+2

More articles:


All Articles