BPC Object Excel VBO Extended 'GetClipboardText' error

[Fran.Woodcock]

Hi, I'm trying to get an Excel worksheet as a collection but am getting the following error and I don't understand what I could be doing wrong. The worksheet name is correct, I've checked for spaces and spelling etc.  The worksheet name doesn't change. The contents are a mix of text and numbers that can be in date form or just as numbers... could this be it?

This is my action:

The workbook name is referenced from a different page.

I'm on version 6.10.5

Thanks, Fran

[shreya.khot]

Hi @Fran.Woodcock ,

Do you get the worksheet name from blueprism & then use it or are you trying to store it in a variable to utilize it?

I can see involvement of spaces in the sheet name which can cause this issue try to check if the sheet name of the excel has extra spaces like " Sheet1" & you trying to access "Sheet1". In case this is any system generated sheet, best approach would be to get the worksheet name & then use the same to fetch data.

Still if you face the same issue I would encourage you to share a snip of the excel data you are trying to fetch.

Thanks

[John__Carter]

I doubt it's the data in the sheet. Could you use the official Excel VBO rather than a copy?