Aspose.Cells.ReportingServices.Client Automation Error When MS Excel 2007 loads Using 64-Bit Windows 7

Aspose.Cells Product Family
1

When Microsoft Excel 2007 loads Aspose.Cells.ReportingServices.Client add-ins, MS Excel 2007 produces an automation error (see attached scrrenshot).

The line causing the error is:

Set AsposeClientTools = CreateObject("Aspose.Cells.ReportingServices.Client.AsposeClient").

Aspose Client.Cells.ReportingServices.Client add-in was successfully working under a 32-bit version of Windows 7 after registering the Aspose.Cells.ReportingServices.Client.dll add-in using the RegAsm utility. Upon upgrading the 32-bit version of Windows to a 64-bit Windows 7, we have began experiencing the automation error when Excel 2007 loads as stated above. We have tried on 2 different machines - both running 64-bit Windows 7 and the problem exists on both machines.

Aspose Client.Cells.ReportingServices.Client add-in works using a 32-bit Windows 7 but not using a 64-bit Windows 7 - Is Aspose Client.Cells.ReportingServices.Client add-in compatible with 64-bit Windows 7 ?

We have tried unregistering and re-registering the Aspose.Cells.ReportingServices.Client.dll add-in using the regasm utility but to no avail. The problem remains.

We require this issue to be resolved ASAP. Please assist!

2

Hi,

Thanks for your interest in Aspose.Cells for Reporting Services.

We have logged your comment and the screenshot. We will investigate this issue and get back to you asap.

This issue has been logged as CELSSREP-28975.

3

Hi,

We have tested the latest version at 64-bit Windows 7. It is working fine.

Please download the latest version: Aspose.Cells for Reporting Services v1.7.0.36 (MSI)

4

Hi,

I uninstalled the current version of aspose.cells for reporting services (via Windows Uninstall), downloaded and installed Aspose.cells for reporting services version 1.7.0.36 as suggested but this did not fix the automation error issue. I then ran the regasm utility but still received the same automation error message shown in the previous post.

The issue has now been resolved by the following procedure and MS Excel 2007 loads error free and containing the Aspose.Cells Add-in:

  • Uninstall current version of Aspose.Cells for Reporting Services
  • Manually delete all "Aspose" entries in the registry (using regedit)
  • Restart PC
  • Install Aspose.Cells version 1.7.0.36

Thank you for your assistance.

Case can be closed.

5

Hi,

Thanks for your input and congratulation, you were able to successfully install Aspose.Cells for ReportingServices.

We have marked this issue resolved and closed it in our database.

6

Hi,

Please search the “Aspose.Cells.ReportingServices.Client.AsposeClient” key and get CLSID value in registry table .

And find the CLSID key through the CLSID value.

If you find these information, please post here and check Aspose.Cells.ReportingServices.Client.dll location is correct.

If you cannot find these information, please try reference follow steps to modify follow information and import registry table.


1. Check 87064D63-6D5C-37BD-8953-19490282B0B7 value uniqueness. If no uniqueness, please modify CLSID value

2. Modify Aspose.Cells.ReportingServices.Client.dll location.

3. Import registry table.


=================================================================================


Windows Registry Editor Version 5.00


[HKEY_CLASSES_ROOT\Aspose.Cells.ReportingServices.Client.AsposeClient]

@=“Aspose.Cells.ReportingServices.Client.AsposeClient”


[HKEY_CLASSES_ROOT\Aspose.Cells.ReportingServices.Client.AsposeClient\CLSID]

@="{87064D63-6D5C-37BD-8953-19490282B0B7}"


[HKEY_CLASSES_ROOT\Wow6432Node\CLSID{87064D63-6D5C-37BD-8953-19490282B0B7}]

@=“Aspose.Cells.ReportingServices.Client.AsposeClient”


[HKEY_CLASSES_ROOT\Wow6432Node\CLSID{87064D63-6D5C-37BD-8953-19490282B0B7}\Implemented Categories]

@=""


[HKEY_CLASSES_ROOT\Wow6432Node\CLSID{87064D63-6D5C-37BD-8953-19490282B0B7}\InprocServer32]

@=“mscoree.dll”

“Assembly”=“Aspose.Cells.ReportingServices.Client, Version=1.5.3.0, Culture=neutral, PublicKeyToken=null”

“Class”=“Aspose.Cells.ReportingServices.Client.AsposeClient”

“CodeBase”=“file:///E:\Program Files (x86)\Aspose\Aspose.Cells for Reporting Services\Bin\Aspose.Cells.ReportingServices.Client.dll”

“RuntimeVersion”=“v2.0.50727”

“ThreadingModel”=“Both”


[HKEY_CLASSES_ROOT\Wow6432Node\CLSID{87064D63-6D5C-37BD-8953-19490282B0B7}\ProgId]

@=“Aspose.Cells.ReportingServices.Client.AsposeClient”


=================================================================================