title: How to import data from Excel into QTP
body: <p>I am trying to write a script that could be used to import data from a sheet in excel into my QTP Data table.
  Below is the script . But even though the script runs successfully, I cannot seem to get the data pop up in the data table. Any help is greatly appreciated.</p>
  
  <p>datatable.Import Sheet "C:\Documents and settings\Administrator\Desktop\Book1.xlsx",Sheet1,Action1</p>