2 weeks ago
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
2 weeks ago
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
a week ago
I doubt it's the data in the sheet. Could you use the official Excel VBO rather than a copy?