https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48255#M3821 Hi, I am attaching a sheet. Need to know how to read Staff No, Name and NRIC No. Wed, 24 Oct 2018 22:38:00 GMT PuneetSingh 2018-10-24T22:38:00Z https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48255#M3821 Hi, I am attaching a sheet. Need to know how to read Staff No, Name and NRIC No. Wed, 24 Oct 2018 22:38:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48255#M3821 PuneetSingh 2018-10-24T22:38:00Z https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48256#M3822 Hi, singhpuneet.   Try the attachment file.   Regards, Met Vonghiran Thu, 25 Oct 2018 05:22:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48256#M3822 MetVonghiran 2018-10-25T05:22:00Z https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48257#M3823 Thanks Sir, Actually here you were passing a hard coded cell value say Cell_Staff No  = C12 if in future this cell value changes then what. I am looking how to read this data dynamically is there any way. Thanks again for reply if there is any way then pls let me know.   Thu, 25 Oct 2018 08:23:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48257#M3823 PuneetSingh 2018-10-25T08:23:00Z https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48258#M3824 You can use oledb excluding the empty rows. Thanks, Arshu Thu, 25 Oct 2018 11:40:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48258#M3824 ArshuHansda 2018-10-25T11:40:00Z https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48259#M3825 If I am not wrong OLEDB is used for database. I want to read data from excel file which I attached. Thu, 25 Oct 2018 13:59:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48259#M3825 PuneetSingh 2018-10-25T13:59:00Z https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48260#M3826 You could try using the Excel VBO, searching for the cell value of ""Staff Number"" then using that to get the cell value of the cell containing the actual number. This would only work if the value of Staff Number is in a consistent place such as column C as you would find the wording of Staff Number in B12 so you would know to get the value in C12.  If you found Staff Number in B50, then the value should be in C50 and so on. Hopefully the attached picture will help. Thu, 25 Oct 2018 18:09:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-read-data-from-file/m-p/48260#M3826 StephenColeman 2018-10-25T18:09:00Z