MS Excel VBO - Get WOrksheet as collection error

[amaury_guthmann]

Hi all, I am trying to feed a collection from an excel file with the MS Excel VBO - Get WOrksheet as collection function. My entries as some blanck values and it causes the following error message: Internal : Could not execute code stage because exception thrown by code stage: Cannot find column 57. Any idea? Thanks Amo

[John__Carter]

Amo - check the column headers in the file. Problems with Get Worksheet are usually caused by duplicate header names, strange characters in the names, etc. Maybe try Get Worksheet Range As Collection instead?

[amaury_guthmann]

HI All, thanks for your answers. Lastly the problem was due to my data. A tab character was hidden within one of my entry. As Blueprism uses a text to column based on tab separator for integrating an excel sheet within a collection it creates a shift in my columns structure. Regards Amo