Here is an example with a simple XLSX file attached to the project. If you are using XLS or another format, you'll need to search for how to create the connection string. The article below shows an example for both XLS and XLSX.
Thanks, Thomas! I tried this in my local and it works. But in the client environment, I had to reference more dlls just so that I can use the OLEDb component. So ended up using 'findcelladdress' method in excel connector.