Cannot find column using MS Excel VBO

dongovor

New Member
Hello everyone.
Is anyone know how to handle this error:
Could not execute code stage because exception thrown by code stage: Cannot find column 3. <fileName.xlsx>
It appears when i use MS Excel VBO -> Get Worksheet As Collection (normal/fast). Column 3 name has new line (Alt+Enter).
 

VJR

Well-Known Member
Hi dongovor,

What is the heading of your column 3 that has a new line.
When I tried with Name <Alt Enter> Age I did not receive this error.
If you are in a position to share your file after removing any sensitive data then I can run and take a look at.
 

dongovor

New Member
Fixed myself...Just added new Action to MS Excel VBO which removes all type of newlines and trims column names. Because in different cases BP reads this column names as two different rows.
 
Top