How to delete data in the cells of excel sheet dynamically
My requirement is to add 4 rows of data in the excel sheets and the later clear that data and place a different set of data in the same cells. I have used ddt_set_val_by_row(table,row,parameter,"");
This is successfully deleting the data, but the ddt_row_count() is still 4.I have used ddt_close(table); before opening it again and finding rowcount. Still the problem persists. Is there any way to clear the excel sheet through script and make rowcount zero.
Re: How to delete data in the cells of excel sheet dynamically
That is one of the frustrating things with WinRunner and .xls files.
If you delete the data contained in the rows, WinRunner still detectd the rows. Only by manually editing and deleting the entire row and not just the contents does WinRunner recognize the rows being deleted.
The only way I can see to get around it is to add in statmenets to act only if the values are not NULL, that is , unless NULL is a valid condition.
Are these 4 rows the only information you are puling from the xls file? if it s, it seems a bit overkill putting this info into a sheet just to pull it out later - an array might prove easier to work with?
Insanity: doing the same thing over and over again and expecting different results