We tried to use the below code from forum to bind data sheet dynamically, but not working.
http://blogs.msdn.com/b/mathew_aniyan/archive/2009/04/16/more-on-data-driving-coded-ui-tests.aspx
<DataSource("System.Data.OleDb", @"Provider=Microsoft.Jet.OLEDB.8.0;Data Source=C:\QTP_Scripts\hCue_Refresh_POC\hCue_POC_01\TestProject1\TestProject1\Data\hCue_Refresh.xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'", "Login$", DataAccessMethod.Sequential), TestMethod()> _