dtLocalSheet empty even though excel file contains data

[vidhi]

The problem was that UFT changes names of actions, when those actions (reusable actions) are used from other actions (master tests).
In particular, my Action1 was not really named Action1 anymore, when I included it in maMasterTest. Instead, it's name was Action1 [Reusable Actions].
So what I had to do was to rename excel sheets in that manner.

Which caused more problems, because excel sheets' names have a limit of 31 characters. But that's another story

You may just name your Excel sheet as 'Action1' only and append  '[Reusable Actions]' at run time to it.