I have a database check point, which retrieves and checks the result set for a given query.
Is there anyway to export this result set into a excel sheet & save it into another folder?
This is possible in Win runner. Does anyone have a clue how to do the same in QTP??
Re: how do I exporting result set into an excel sheet
Thanks for that reply. But the problem lies one step before exporting the queried result set(database checkpoint). When the result set is tried to output on to the datasheet, the column name will be like xxx_col1_row1, for the first element and so on for all the elements of the result set.So each such data element will be written in a separate column.
So my question is 'Is there anyway of writing this result set in the same manner as it appears on to the datasheet, rather than on each single column?'