I Imported the spreadsheet from the local folder. Then I exported that spreadsheet inside the Test Script folder as a 'Default.xls" file by overwriting the existing 'Default.xls' file.
My problem is the script does not read all the rows from the spreadsheet even I had set to "Run From All rows"

Is there a way to make script understand the 'Default.xls' file had changed during the runtime and to have it execute all the rows?


Here is the example code:

strDirPathName = "c:\Temp\Testdat.xls"
DataTable.ImportSheet strDirPathName, "Global", "Global"
strTestDir = Environment("TestDir")
DataTable.Export strTestDir & "\Default.xls"