EasyExcel 4 does not work anymore

1

Hi,
Recently I changed computer - now Windows 11. Clarion 11.0.1360
Every time I try to use EasyExcel it trows an error:

afbeelding
afbeelding266×136 3.99 KB

(Means: error during loading) - The demo app does that too…
Does anyone know if that can be fixed?
Thanks, Piet Bouma

2

Hi Piet,

Maybe this is the problem:

EasyExcel supports all Excel version that support COM automation (NOT starter, student or home version ).

3

Dank je Rob,
I use Office 365.
In an email from Guennadi (Ingasoftplus): (a few years ago…)
“EasyExcel doesn’t work with Office 365 because Office 365 doesn’t support OLE automation”.

Guennadi,

But did some test on a Windows 10 computer with the same app and Office 365 and it works there.
Must have done a trick…once

4

As Rob and you said. Also are you sure that you have Excel installed correctly?

5

Yes I did. I do not want to be unfriendly but why does EasyExcel not work with Office 365. I think this is used by a lot of folks.
But the trick: I installed an older version of msVisio (2013) and EE works…turns out I’ve done this before
odd? yes do I understand it ? no

6

It works just fine. just checked it:

image
image1142×759 150 KB

and
image
image273×177 2.71 KB

Probably it turns On some automation so Excel gets this setting too…

7

I just ran into a similar problem on my dev machine. The app loads but any commands to Excel produce: “Error loading type library/DLL.”

Using C10. I’m not sure where a person can get an old version of msVisio (2013) – if that, in fact, is the cure.

Suggestions?

Thanks.

Jim

8

I dont know if this is relevant, but it might be worth look at the COM TLib versions.

Excel 2007 was installed and it’s COM Classes are registered in HKCR\TypeLib{00020813-0000-0000-C000-000000000046}\1.6

call Excel through COM automation it used HKCR\TypeLib{00020813-0000-0000-C000-000000000046}\1.7.

was trying to talk to Excel 2010 instead which was not present.

This might also be relevant

Looks like Registry TLib issues in both cases, which will probably explain being able to install the msVisio (2013) to get things to work.

9

Thanks Rich. I’ll take a look. Appreciate the help.

I dont know if this is relevant, but it might be worth look at the COM TLib versions.

Excel 2007 was installed and it’s COM Classes are registered in HKCR\TypeLib{00020813-0000-0000-C000-000000000046}\1.6

call Excel through COM automation it used HKCR\TypeLib{00020813-0000-0000-C000-000000000046}\1.7.

was trying to talk to Excel 2010 instead which was not present.

https://learn.microsoft.com/en-gb/archive/blogs/dau-blog/how-to-solve-unable-to-cast-com-object-of-type-microsoft-office-interop-excel-applicationclass-to-interface-type-microsoft-office-interop-excel-_application

This might also be relevant
https://learn.microsoft.com/en-us/answers/questions/4988544/solved-getting-error-in-loading-dll-messages-after?forum=msoffice-all&referrer=answers

Looks like Registry TLib issues in both cases, which will probably explain being able to install the msVisio (2013) to get things to work.