Examples with Dispatch com.jacob.com.Dispatch used on opensource projects

Example 21 with Dispatch

use of com.jacob.com.Dispatch in project janrufmonitor by tbrandt77.

the class OutlookTransformer method getContactCount.

public int getContactCount(String folder) {
    int count = 0;
    ActiveXComponent outlook = new ActiveXComponent("Outlook.Application");
    Dispatch mapiNS = null;
    Dispatch contactsFolder = null;
    Dispatch contactsSubFolder = null;
    Dispatch items = null;
    try {
        if (this.m_logger.isLoggable(Level.INFO))
            this.m_logger.info("created Outlook.Application dispatch");
        if (this.m_logger.isLoggable(Level.INFO))
            this.m_logger.info("Microsoft Outlook version: " + Dispatch.get(outlook.getObject(), "Version"));
        mapiNS = outlook.getProperty("Session").toDispatch();
        if (this.m_logger.isLoggable(Level.INFO))
            this.m_logger.info("Microsoft Outlook namespace: " + mapiNS);
        Variant contactsVariant = new Variant(10);
        contactsFolder = Dispatch.call(mapiNS, "GetDefaultFolder", contactsVariant).toDispatch();
        if (this.m_logger.isLoggable(Level.INFO))
            this.m_logger.info("Microsoft Outlook folder: " + contactsFolder);
        // searching subfolders
        this.m_logger.info("Includig outlook contact subfolders");
        contactsSubFolder = Dispatch.call(contactsFolder, "Folders", new Variant(folder)).toDispatch();
        items = Dispatch.get(contactsSubFolder, "Items").toDispatch();
        count = Dispatch.get(items, "Count").getInt();
    } catch (ComFailException ex) {
        this.m_logger.warning("1 item (e.g. distribution list) was ignored on loading.");
        if (ex.toString().indexOf("Can't get object clsid from progid") > -1) {
            this.m_logger.log(Level.SEVERE, ex.toString(), ex);
            PropagationFactory.getInstance().fire(new Message(Message.ERROR, getNamespace(), "olstarterror", ex));
        } else
            this.m_logger.warning(ex.getMessage() + ", " + ex.getSource());
    } catch (Exception ex) {
        this.m_logger.warning(ex.getMessage() + ", " + ex.toString());
    } finally {
        // added 2006/02/05: clean outlook references
        if (items != null)
            items.safeRelease();
        if (contactsFolder != null)
            contactsFolder.safeRelease();
        if (contactsSubFolder != null)
            contactsSubFolder.safeRelease();
        if (mapiNS != null)
            mapiNS.safeRelease();
        if (outlook != null)
            outlook.safeRelease();
    }
    return count;
}

Example 22 with Dispatch

use of com.jacob.com.Dispatch in project yyl_example by Relucent.

the class ExcelInvokeDemo method main.

public static void main(String[] s) {
    ComThread.InitSTA();
    // 获取ACTIVEX组件实例
    ActiveXComponent xl = new ActiveXComponent("Excel.Application");
    try {
        System.out.println("version=" + xl.getProperty("Version"));
        // 获取X1对象中version属性的值
        System.out.println("version=" + Dispatch.get(xl, "Version"));
        // 将true值赋给x1对象中的Visible属性
        Dispatch.put(xl, "Visible", new Variant(true));
        // 获得x1对象中的Workbooks属性，并将转为对象
        Dispatch workbooks = xl.getProperty("Workbooks").toDispatch();
        // 获得workbooks对象的add属性
        Dispatch workbook = Dispatch.get(workbooks, "Add").toDispatch();
        // 获得workbooks对象的ActiveSheet属性
        Dispatch sheet = Dispatch.get(workbook, "ActiveSheet").toDispatch();
        // 对sheet对象的Range属性执行其GET方法，再将Range属性的值设为A1
        Dispatch a1 = Dispatch.invoke(sheet, "Range", Dispatch.Get, new Object[] { "A1" }, new int[1]).toDispatch();
        // 同上
        Dispatch a2 = Dispatch.invoke(sheet, "Range", Dispatch.Get, new Object[] { "A2" }, new int[1]).toDispatch();
        // 将a1对象中的Value属性设为"123.456"
        Dispatch.put(a1, "Value", "123.456");
        Dispatch.put(a2, "Formula", "=A1*2");
        System.out.println("a1 from excel:" + Dispatch.get(a1, "Value"));
        System.out.println("a2 from excel:" + Dispatch.get(a2, "Value"));
        Variant f = new Variant(false);
        System.out.println(f);
    // Dispatch.call(workbook, "Close", f);
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        xl.invoke("Quit", new Variant[] {});
        ComThread.Release();
    }
}

Example 23 with Dispatch

use of com.jacob.com.Dispatch in project yyl_example by Relucent.

the class JacobWordEngine method getParagraphsProperties.

/**
   * 设置当前段落格式, 使用前,请先选中段落
   */
public void getParagraphsProperties() {
    Dispatch paragraphs = Dispatch.get(selection, "Paragraphs").toDispatch();
    // 行距
    String val = Dispatch.get(paragraphs, "LineSpacingRule").toString();
    // 对齐方式
    val = Dispatch.get(paragraphs, "Alignment").toString();
    // 段前行数
    val = Dispatch.get(paragraphs, "LineUnitBefore").toString();
    // 段后行数
    val = Dispatch.get(paragraphs, "LineUnitAfter").toString();
    // 首行缩进
    val = Dispatch.get(paragraphs, "FirstLineIndent").toString();
    // 首行缩进字符数
    val = Dispatch.get(paragraphs, "CharacterUnitFirstLineIndent").toString();
    val.toString();
}

Example 24 with Dispatch

use of com.jacob.com.Dispatch in project yyl_example by Relucent.

the class JacobWordEngine method addTableCol.

/**
   * 在指定列前面增加表格的列
   * 
   * @param tableIndex
   *        word文档中的第N张表(从1开始)
   * @param colIndex
   *        制定列的序号 (从1开始)
   */
public void addTableCol(int tableIndex, int colIndex) {
    // 所有表格
    Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
    // 要填充的表格
    Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
    // 表格的所有行
    Dispatch cols = Dispatch.get(table, "Columns").toDispatch();
    System.out.println(Dispatch.get(cols, "Count"));
    Dispatch col = Dispatch.call(cols, "Item", new Variant(colIndex)).toDispatch();
    // Dispatch col = Dispatch.get(cols, "First").toDispatch();
    Dispatch.call(cols, "Add", col).toDispatch();
    Dispatch.call(cols, "AutoFit");
}

Example 25 with Dispatch

use of com.jacob.com.Dispatch in project yyl_example by Relucent.

the class JacobWordEngine method setTableCellSelected.

/**
   * 设置单元格被选中
   * 
   * @param tableIndex
   * @param cellRowIdx
   * @param cellColIdx
   */
public void setTableCellSelected(int tableIndex, int cellRowIdx, int cellColIdx) {
    Dispatch tables = Dispatch.get(doc, "Tables").toDispatch();
    Dispatch table = Dispatch.call(tables, "Item", new Variant(tableIndex)).toDispatch();
    Dispatch cell = Dispatch.call(table, "Cell", new Variant(cellRowIdx), new Variant(cellColIdx)).toDispatch();
    Dispatch.call(cell, "Select");
}