| || |
Data from Excel / DB
I have an idea for inserting the testdata from excel or access into QTP scripts but need some help.
1. Write a function where your pass which sheet to read. This function should put all the column names ( headers) in an object and then all the data from rows get associated to this object structure. This is a typically data row model. It is possible to do this in other tools but not idea as how I get this done in QTP.
Example - The sheet has firstname, lastname, addr1, addr2 as headers and x number of rows that contains the data. Now if I can port this to an object with attrubutes firstname, lastname, addr1, addr2 and all the rows with data then would be nice.
Re: Data from Excel / DB
Look and you will find what you seek...