https://community.blueprism.com/t5/Product-Forum/Error-when-fetching-data-from-MS-Excel/m-p/94085#M43494 P.s.: I found that the data in the title row or 'A' row of the excel has multi-line text and it didn't accept it once I made it a single line text. The code stage accepted it. But is there I way where I can eliminate the newline character when I'm exporting data from collections to excel? Tue, 06 Sep 2016 15:01:00 GMT Anonymous 2016-09-06T15:01:00Z https://community.blueprism.com/t5/Product-Forum/Error-when-fetching-data-from-MS-Excel/m-p/94084#M43493 Him I tried to get the data from an excel using MS Excel VBO and it throwed "Internal : Could not execute code stage because exception thrown by code stage: Cannot find column 1." error when I called 'Get Excel as Collection(Fast)'. PFA of the flow I created. I tried with another excel sheet and it worked flawlessly but particularly for this excel its throwing this error Tue, 06 Sep 2016 13:46:00 GMT https://community.blueprism.com/t5/Product-Forum/Error-when-fetching-data-from-MS-Excel/m-p/94084#M43493 Anonymous 2016-09-06T13:46:00Z https://community.blueprism.com/t5/Product-Forum/Error-when-fetching-data-from-MS-Excel/m-p/94085#M43494 P.s.: I found that the data in the title row or 'A' row of the excel has multi-line text and it didn't accept it once I made it a single line text. The code stage accepted it. But is there I way where I can eliminate the newline character when I'm exporting data from collections to excel? Tue, 06 Sep 2016 15:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Error-when-fetching-data-from-MS-Excel/m-p/94085#M43494 Anonymous 2016-09-06T15:01:00Z https://community.blueprism.com/t5/Product-Forum/Error-when-fetching-data-from-MS-Excel/m-p/94086#M43495 Vijay You should be able to do a 'find and replace'. I think the character code for a carriage return is 10. Perhaps try something like the below in a code stage: Replace(MyRange, Chr(10), """") Let me know if you need a complete code stage, but certainly try to build one using the above snippet. -Tom Tue, 06 Sep 2016 16:27:00 GMT https://community.blueprism.com/t5/Product-Forum/Error-when-fetching-data-from-MS-Excel/m-p/94086#M43495 TomBlackburn1 2016-09-06T16:27:00Z https://community.blueprism.com/t5/Product-Forum/Error-when-fetching-data-from-MS-Excel/m-p/94087#M43496 Thanks a lot Tom! That helped me indeed. Wed, 07 Sep 2016 13:39:00 GMT https://community.blueprism.com/t5/Product-Forum/Error-when-fetching-data-from-MS-Excel/m-p/94087#M43496 Anonymous 2016-09-07T13:39:00Z https://community.blueprism.com/t5/Product-Forum/Error-when-fetching-data-from-MS-Excel/m-p/94088#M43497 Hi Tom, would you be able to supply me with a complete code stage please? I have attempted to build my own but to no avail. Thanks. Mon, 10 Jul 2017 21:18:00 GMT https://community.blueprism.com/t5/Product-Forum/Error-when-fetching-data-from-MS-Excel/m-p/94088#M43497 Anonymous 2017-07-10T21:18:00Z