There isnt a worksheet named... Error

image

When I tried to read a cell value from a Worksheet using Read Cell Activity I am getting the above error.
My Workbook, Sheet and Range do exist. I am sure about it.

I dont know why it says ‘[106]INPUT’ . My Workbook name is something else.

image

Has anyone encountered this before?

‘[106]INPUT’ seems to be sheet name that is coming up from the variable ‘strPublicComparableCompaniesSheet’. Are you saying that its not the sheet that your workbook has? In that case, you may be mapping an incorrect variable.

If that sheet exists then try to compare the value from the variable and the sheet name, you may need to trim any extra spaces.

Thanks,
Rammohan B.

2 Likes

No idea where that string ‘[106]INPUT’ comes from.!

I tried giving a wrong Sheetname

image

still same error

Hi Anandhu,

Is it possible to share the workflow file? I’ve tried recreating this error using a couple of sheet names and can’t seem to.

Cheers,
Josh

Hi jcb,

Sorry I cant share the workflow.

But I did some research and it seems like some issue with the Excel File that i was accessing.
I tried to write data in to cell using excel application scope and it worked but it wiped out the entire sheet before writing the value. weird!.

Found a similar topic on this page :
https://github.com/ClosedXML/ClosedXML/issues/317