topic Re: MS Excel VBO in Digital Exchange

MS Excel VBO

bonumeghana — Tue, 30 Jan 2024 05:46:00 GMT

Hi,

Can anyone please try to help me with this error. I recently added MS Excel VBO from digital exchange. New to the Blueprsim.

During an excel operation I am getting the following error: When I'm trying to open workbook

Internal : Could not execute code stage because exception thrown by code stage: Culture is not supported.
Parameter name: culture
0 (0x0000) is an invalid culture identifier.

Following are the steps which I am doing in BP:
Create instance->open workbook-> show->get worksheet as collection->close instance

Thanks in Advance

Regards

Meghana

------------------------------
Bonu Meghana
------------------------------

RE: MS Excel VBO

charliekovacs — Tue, 30 Jan 2024 16:49:00 GMT

Hi Meghana, welcome to Blue Prism and I'm glad you found your way to our community!

Which version of Blue Prism do you have? And are you using the latest version (v10.1.11) of the Excel object from the Digital Exchange?

https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo

It sounds like an issue with determining the culture info your computer is configured for. What language/region do you see in your Windows settings? Start Menu > Settings > Time & language (on Windows 11)

It sounds like there is a chance that changing to English (United States) may satisfy the Excel code library.

------------------------------
Charlie Kovacs
Sr. Digital Exchange Engineer
Blue Prism
Austin, USA
------------------------------

RE: MS Excel VBO

bonumeghana — Wed, 31 Jan 2024 07:27:00 GMT

Hi Charlie,

I'm using Blueprism 7.3.0 and latest version (v10.1.11) of the Excel object.

Even I changed to Region United States. Still showing same error.

Still not satisfy the excel code in open workbook.

Thanks in Advance.

Regards

Meghana

------------------------------
Bonu Meghana
------------------------------

RE: MS Excel VBO

bonumeghana — Wed, 31 Jan 2024 07:52:00 GMT

Hi Charlie,

When I check with the code, showing no errors.

But when I run the process, showing internal exception as shown below screenshot.

Thanks in Advance

Regards

Meghana

------------------------------
Bonu Meghana
------------------------------

RE: MS Excel VBO

charliekovacs — Wed, 31 Jan 2024 18:23:00 GMT

What happens if you try to open a different Excel file? I would also be curious to know if the error persists if you use the Excel VBO to first create a new workbook (and save it, close it) and then try to run the Open Workbook action on it. Basically, this would help determine if there is an issue with the Excel file itself or something else.

------------------------------
Charlie Kovacs
Sr. Digital Exchange Engineer
Blue Prism
Austin, USA
------------------------------

Re: RE: MS Excel VBO

KOSYNSKYI_IVAN — Sat, 20 Apr 2024 12:35:29 GMT

I need your help. I use Blue Prism 7.3.0 - Learning Edition. I don't understand how to download the Excel VBO.

Re: MS Excel VBO

JayantG — Fri, 26 Apr 2024 07:24:00 GMT

same issue is occured

Re: RE: MS Excel VBO

JayantG — Fri, 26 Apr 2024 07:54:00 GMT

simple click this url and down it.

https://digitalexchange.blueprism.com/dx/search?keyword=%22Blue%20Prism%20Enterprise%20-%20Core%22&page=1

Re: MS Excel VBO

rajeshkumarmuthineni — Thu, 16 May 2024 13:24:54 GMT

Hi is this fixed?

Re: MS Excel VBO

SabithaNirmal — Mon, 27 May 2024 06:07:49 GMT

Not yet fixed

Re: MS Excel VBO

electroisok — Sat, 15 Jun 2024 22:46:35 GMT

Did you to solve it? , I'm having the same problem

@Gbril @jhogelp

Re: MS Excel VBO

ewilson — Mon, 17 Jun 2024 13:35:43 GMT

A fix is being worked on now. It seems there's an issue in the Global Code where we try to read the systems culture info, but the .NET doesn't always work as expected.

Should have an update posted to the DX today.

Cheers,

Eric

Re: MS Excel VBO

ewilson — Mon, 17 Jun 2024 13:56:18 GMT

@bonumeghana @electroisok @SabithaNirmal @rajeshkumarmuthineni @JayantG

Version 10.3.2 of the Excel VBO has been posted to the DX. Should address the issue you're seeing with culture.

Cheers,

Eric

Re: MS Excel VBO

krlalliram — Wed, 19 Jun 2024 06:14:57 GMT

Hi,

I too get the same problem in blue prism 7.3

Before this, I used blue prism 7.1.2. There is no issue like this. I have lost my password. so I reinstall blue prism 7.3. In this, I got the problem. I tried many ways, but failed.

Have you resolved this? If you solved, guide me.

Thank you.

Re: MS Excel VBO

ewilson — Thu, 20 Jun 2024 13:38:40 GMT

@krlalliram so you've downloaded version 10.3.2. of the Excel VBO from the Digital Exchange, tested with it, and you're getting the same "culture" error?

Re: MS Excel VBO

ivan.fernando — Sat, 29 Jun 2024 06:44:39 GMT

I have downloaded Excel VBO version 10.3.2 and am getting this error. My BP version is quite a bit older though at 7.0.1. However, we don't get this issue with our older version of the Excel VBO so seems to be an issue with the current VBO.

Re: MS Excel VBO

wktan42 — Wed, 03 Jul 2024 09:12:42 GMT

@ewilson I have the same error too, and the problem still persist with the following trials:

Followed a suggestion from https://community.blueprism.com/t5/Getting-Started/doubt-regarding-opening-of-excel-workbook/td-p/111364
Open a new workbook

Kindly advise.

My Blue Prism setup:

Blue prism version 7.3.0
Excel VBO version 10.3.2 (This issue didn't happen when using version 10.3.0)

Re: MS Excel VBO

ewilson — Wed, 10 Jul 2024 15:19:06 GMT

@wktan42 we haven't been able to reproduce your issue. I'd advise to get the latest release (it's now 10.3.4) and try again. As you can see from the screenshot below, the only code that references "culture" is pictured, and the way the code is implemented is within a try...catch block. So there should be no exceptions related to the variable "culture" unless ytou're running an older version of the VBO prior to this try...catch being added.

Cheers,
Eric

Re: MS Excel VBO

ivan.fernando — Tue, 16 Jul 2024 05:22:17 GMT

Hi @ewilson ,

I have tried again with the latest VBO version (10.3.4) and still getting the culture error per screenshot below.

I noticed in the code snippet you posted above the function with the try catch is called "InvokeReflection". However, the "Open Workbook" action code seems to reference the function "Invoke" (screenshot below). Maybe this is why it's still happening?

Edit: just had a look further into the code, can see the Invoke() function then calls the InvokeReflection() function anyway so not sure why it's not being caught.

Re: MS Excel VBO

ewilson — Tue, 16 Jul 2024 15:57:02 GMT

My guess is that it's the declaration of the culture object that's throwing the error. For some reason, on your system, an invalid culture LCID (culture identifier) is being returned. We're going to move that declaration within the try...catch block. Update to the VBO will be posted later today.

Cheers,
Eric