org.eclipse.swt.snippets.Snippet305.java Source code

Introduction

Here is the source code for org.eclipse.swt.snippets.Snippet305.java

Source

/*******************************************************************************
 * Copyright (c) 2000, 2015 IBM Corporation and others.
 *
 * This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License 2.0
 * which accompanies this distribution, and is available at
 * https://www.eclipse.org/legal/epl-2.0/
 *
 * SPDX-License-Identifier: EPL-2.0
 *
 * Contributors:
 *     IBM Corporation - initial API and implementation
 *******************************************************************************/
package org.eclipse.swt.snippets;

/*
 * Show row/column position of current selection in an Excel sheet.
 *
 * For a list of all SWT example snippets see
 * http://www.eclipse.org/swt/snippets/
 */

import org.eclipse.swt.*;
import org.eclipse.swt.layout.*;
import org.eclipse.swt.ole.win32.*;
import org.eclipse.swt.widgets.*;

public class Snippet305 {
    static int SheetSelectionChange = 0x00000616;
    static String IID_AppEvents = "{00024413-0000-0000-C000-000000000046}";

    public static void main(String[] args) {
        Display display = new Display();
        Shell shell = new Shell(display);
        shell.setText("Excel Sheet Selection Example");
        shell.setLayout(new FillLayout());
        OleAutomation application;
        try {
            OleFrame frame = new OleFrame(shell, SWT.NONE);
            OleControlSite controlSite = new OleControlSite(frame, SWT.NONE, "Excel.Sheet");
            controlSite.doVerb(OLE.OLEIVERB_INPLACEACTIVATE);

            OleAutomation excelSheet = new OleAutomation(controlSite);
            int[] dispIDs = excelSheet.getIDsOfNames(new String[] { "Application" });
            Variant pVarResult = excelSheet.getProperty(dispIDs[0]);
            application = pVarResult.getAutomation();
            pVarResult.dispose();
            excelSheet.dispose();

            OleListener listener = new OleListener() {
                @Override
                public void handleEvent(OleEvent e) {
                    // SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
                    Variant[] args = e.arguments;
                    // OleAutomation sheet = args[1].getAutomation(); // Excel.Sheet
                    OleAutomation range = args[0].getAutomation(); // Excel.Range
                    int[] dispIDs = range.getIDsOfNames(new String[] { "Row" });
                    Variant pVarResult = range.getProperty(dispIDs[0]);
                    int row = pVarResult.getInt();
                    dispIDs = range.getIDsOfNames(new String[] { "Column" });
                    pVarResult = range.getProperty(dispIDs[0]);
                    int column = pVarResult.getInt();
                    range.dispose();
                    System.out.println("row=" + row + " column=" + column);
                }
            };
            controlSite.addEventListener(application, IID_AppEvents, SheetSelectionChange, listener);
        } catch (SWTError e) {
            System.out.println("Unable to open activeX control");
            display.dispose();
            return;
        }
        shell.setSize(800, 600);
        shell.open();
        while (!shell.isDisposed()) {
            if (!display.readAndDispatch())
                display.sleep();
        }
        if (application != null)
            application.dispose();
        display.dispose();
    }
}