Getting Error on Write to Excel Code stage

[dilshad_khan]

Hi Everyone,
I am facing issue while trying to write collection data in excel , please find snippets for more details, 
Can anyone please suggest best solution of this issue ?
Error Message : Internal : Could not execute code stage because exception thrown by code stage: Exception from HRESULT: 0x800A03EC

------------------------------
Dilshad Khan
------------------------------

[harish.m]

HI Dilshad Khan,

This error may occur due to some of the limitation present in the excel.
DOuble check the excel instance in task manager or restart the system and try to run the code again and see whteher you are still getting this error

Couple of threads related to this error:

BP KNowledge base

StackOverFlow -1
StackOverFlow-2

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------

[dilshad_khan]

Hi Harish ,
I could not open first link "BP Knowledge Base ", Can you please take screenshot and share me that solution. Issue is still persisting .

------------------------------
Dilshad Khan
------------------------------

[DevendranVenkatesh]

If possible, can you please show me that excel file screen shot?

Also confirm whether any filter or any cell has been merged?

------------------------------
Best Regards,
Devendran Venkatesh
RPA - Technical Architect |
Riyadh 11413, Kingdom of Saudi Arabia
Phone. +966-556784162
------------------------------

[dilshad_khan]

Hi,
Please find attached screenshot of excel, no cell is merged and no filter is used.

------------------------------
Dilshad Khan
------------------------------

[harish.m]

HI Dilshad Khan,

Below is teh screenshot, you  can login as a customer and check the knowledge base there is an option in the login screen.

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------

[Soumya21]

Hi

You have give cell reference like A1 and B1 Not like "A"

It won't work if we give only "A" in Cell reference

Thanks,

Soumya

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

[harish.m]

If possible can you share the screenshot of write excel action ?

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish Mogulluri
Lead developer
America/New_York TX
------------------------------

[dilshad_khan]

Thank You So Much to all of you , Special Thank You to  Somya, It was very minor but big mistake, Now code started working for me

On Mon, Aug 28, 2023, 8:49 AM Harish Mogulluri via Blue Prism Community <Mail@blueprism.email> wrote:

If possible can you share the screenshot of write excel action ? ------------------------------ ----------------------- If I answered your query... -posted to the "Blue Prism RPA Product" community

Blue Prism Product

Post New Message Online

Re: Getting Error on Write to Excel Code stage

Reply to Group Online Reply to Group

Aug 28, 2023 4:18 AM Harish Mogulluri

If possible can you share the screenshot of write excel action ? ------------------------------ ----------------------- If I answered your query. Please mark it as the "Best Answer" Harish Mogulluri Lead developer America/New_York TX ------------------------------

Reply to Group Online   Reply to Group via Email   View Thread   Recommend   Flag as Inappropriate