Package com.jacob.com

Examples of com.jacob.com.Dispatch

115
116
117
118
119
120
121
122
123
124
125
126
127
          if (i % 10 == 0) {
            System.out.println(Thread.currentThread().getName()
                + ": Iteration " + i);
            System.out.flush();
          }
          Dispatch comPresentations = Dispatch.get(comPowerpoint,
              "Presentations").toDispatch();
          Dispatch comPresentation = Dispatch.call(
              comPresentations,
              "Open",
              getWindowsFilePathToPackageResource("test"
                  + threadID + ".ppt", this.getClass()),
              new Integer(0), new Integer(0), new Integer(0))
View Full Code Here
331
332
333
334
335
336
337
338
339
340
341
          // show the type
          argString += "(" + argType + ")";
        }
        argString += "=";
        if (argType == Variant.VariantDispatch) {
          Dispatch foo = (args[i].getDispatch());
          argString += foo;
        } else if ((argType & Variant.VariantBoolean) == Variant.VariantBoolean) {
          // do the boolean thing
          if ((argType & Variant.VariantByref) == Variant.VariantByref) {
            // boolean by ref
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
  public void testPowerpoint() {
    ComThread.InitMTA();

    ActiveXComponent component = new ActiveXComponent(
        "Powerpoint.Application");
    Dispatch comPowerpoint = component.getObject();

    try {
      PowerpointTestThread[] threads = new PowerpointTestThread[NUM_THREADS];
      for (int i = 0; i < NUM_THREADS; i++) {
        threads[i] = new PowerpointTestThread(i + 1, comPowerpoint);
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
    try {

      System.out.println("version=" + axc.getProperty("Version"));
      System.out.println("version=" + Dispatch.get(axc, "Version"));
      axc.setProperty("Visible", true);
      Dispatch workbooks = axc.getPropertyAsComponent("Workbooks");
      Dispatch workbook = Dispatch.get(workbooks, "Add").toDispatch();
      Dispatch sheet = Dispatch.get(workbook, "ActiveSheet").toDispatch();
      hookupListener(sheet, excelSheetProgramId, typeLibLocation);
      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();
      System.out.println("Inserting value into A1");
      System.out.println("Inserting calculation 2xA1 into A2");
      Dispatch.put(a1, "Value", "123.456");
      Dispatch.put(a2, "Formula", "=A1*2");
 
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
        // should we get this?
      }

      String scriptCommand = getSampleVPScriptForEval();
      // get a thread-local Dispatch from sCon
      Dispatch sc = script.sCon.toDispatch();

      // call a method on the thread-local Dispatch obtained
      // from the DispatchProxy. If you try to make the same
      // method call on the sControl object - you will get a
      // ComException.
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
      ActiveXComponent excel = new ActiveXComponent("Excel.Application");

      try {

        excel.setProperty("Visible", false);
        Dispatch workbooks = excel.getProperty("Workbooks")
            .toDispatch();

        Dispatch workbook = Dispatch.call(workbooks, "Open", path, // FileName
            3, // UpdateLinks
            false, // Readonly
            5, // Format
            password // Password
            ).toDispatch();

        Dispatch sheets = Dispatch.call(workbook, "Worksheets")
            .toDispatch();
        System.out.println("Before executa");
        executa(excel, sheets);
        System.out.println("After executa");
View Full Code Here
137
138
139
140
141
142
143
144
145
     *            valor a ser escrito na celula
     */
    public void informarValorCelula(String celula, Dispatch sheet,
        String valor) {
      System.out.println("Entered informarValorCelula");
      Dispatch cel = obterCelula(celula, sheet);
      Dispatch.put(cel, "Value", valor);
      System.out.println("Exiting informarValorCelula");
    }
View Full Code Here
154
155
156
157
158
159
160
161
162
163
     *            pasta da planilha que cont�m a c�lula
     * @return - conte�do da propriedade Value
     */
    public Variant obterValorCelula(String celula, Dispatch sheet) {
      System.out.println("Entered obterValorCelula");
      Dispatch d = obterCelula(celula, sheet);
      Variant returnedValue = Dispatch.get(d, "Value");
      System.out.println("Exiting obterValorCelula");
      return returnedValue;
    }
View Full Code Here
176
177
178
179
180
181
182
183
184
185
     * @return - referencia para um c�lula ou conjunto de c�lulas,
     *         dependendo do par�metro passado
     */
    public Dispatch obterCelula(String celula, Dispatch sheet) {
      System.out.println("Entered obterCelula");
      Dispatch d = Dispatch.invoke(sheet, "Range", Dispatch.Get,
          new Object[] { celula }, new int[1]).toDispatch();
      System.out.println("Exiting obterCelula");
      return d;
    }
View Full Code Here
224
225
226
227
228
229
230
231
232
233
234
     *            Referencia para conjunto de pastas da planilha
     */
    public void executa(ActiveXComponent xl, Dispatch sheets) {

      System.out.println("Entered private ExcellCallBack executa()");
      Dispatch sheet = Dispatch.call(sheets, "Item", "Plan1")
          .toDispatch();
      columnA = obterValoresRange("A1:A50", sheet);
      columnB = obterValoresRange("B1:B40", sheet);
      System.out.println("Exiting private ExcellCallBack executa()");
    }
View Full Code Here
TOP

Related Classes of com.jacob.com.Dispatch

  • com.jacob.activeX.ActiveXComponent
  • com.jacob.samples.access.Access
  • com.jacob.samples.atl.MultiFaceTest
  • com.jacob.samples.MathProj.MathTest
  • com.jacob.samples.office.ExcelDispatchTest
  • com.jacob.samples.office.VisioPrintTest
  • com.jacob.samples.office.WordDocumentProperties
  • com.jacob.samples.outlook.Outlook
  • com.jacob.samples.system.SystemMonitor
  • com.jacob.test.events.ExcelEventTest
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.