Microsoft KB Archive/169806

From BetaArchive Wiki

Article ID: 169806

Article Last Modified on 8/25/2005


  • Microsoft Visual J++ 1.0 Standard Edition
  • Microsoft Visual J++ 1.1 Standard Edition

This article was previously published under Q169806


Attempting to create a new _ExcelApplicaton object and casting it to an Application interface, generates the following exception:



To work around the problem call getDispatch on the Application object, in order to get at its COM interface. For the code mentioned in the MORE INFORMATION section, the workaround is to use a Workspace, and it's method .Application() to return an application object, and then use the getDispatch to get the Application interface:

     import xl5en32.*;
     public void TestExcel()
   Variant v1 = new Variant();
        Application app;

        // Create A new worksheet
   Worksheet wks = (Worksheet)new _ExcelSheet();

   // Get hold of a dispatch on the application
   v1 = wks.Application();
   app = (Application)v1.getDispatch();


Steps to Reproduce Behavior

  1. Run JAVATLB on Excel 5.0 Object Library. This creates Java class wrappers of the Excel objects and interfaces in the Type Library.
  2. Create a Java Application that contains the following code:

          import xl5en32.*;
          public void TestExcel()
            _ExcelApplication x = new _ExcelApplication();
             Application xlApp = (Application)x;
  3. Build the application and execute it.
  4. This causes a ClassCastException error when creating the Excel Automation object.


For the latest Knowledge Base articles and other support information on Visual J++ and the SDK for Java, see the following page on the Microsoft Technical Support site:

Additional query words: excel exception java

Keywords: kbprb KB169806