PRB: ClassCastException Error When Using Excel Object in Java

ID: Q169806

The information in this article applies to:

• Microsoft Visual J++, versions 1.0, 1.1

SYMPTOMS

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

   exception:java.lang.ClassCastException:xl5en32/_ExcelApplication

RESOLUTION

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.*;
     import com.ms.com.*;
     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();
     }

MORE INFORMATION

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.

      import xl5en32.*;

      public void TestExcel()
      {
        _ExcelApplication x = new _ExcelApplication();
         Application xlApp = (Application)x;
      }

4. This causes a ClassCastException error when creating the Excel

   Automation object.

REFERENCES

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:

   http://support.microsoft.com/support/visualj/ 
   http://support.microsoft.com/support/java/ 

Keywords          : JCOM 
Version           : 1.0 1.1
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: January 30, 1998