Wshile running my QTP 9.5 scripts,,I am trying to learn how to clear a datasheet in Excel.
I have tried:
with no luck.
Is there an easy way to clear a datasheet?
thx for looking.
Thx for the help ;-)
I'm not sat at my QTP machine at the moment but here's how I would clear a sheet in Excel, maybe this will point you in the right direction:
My linkedIn Profile
This is just a guess but you tried something like:
thx for the help.
I tried, but recived the RunError:
The DataTable.GetSheet operation failed. The Sheet1 sheet does not exist.
The Excel datasheet does indicate Sheet1
Is this code for Excel or QTP'S dataTable?
Perfect! I just added the objEcxel and poof, all is cleared.