Quality Testing

Quality is delighting customers

How to display the result in a excel columnwise in QTP

Hi,

I am working in QTP 10.0. I have captured all the values from my java application and have exported the values to a excel sheet. The results (values captured from the application) are exported row wise but i want it to be column wise. Can anyone help me how to proceed with this. Thanks in advance

Views: 479

Reply to This

Replies to This Discussion

Can you just give me the code which you have used to export the values into the excel normally to write the data we used to first create an excel object and with the help of the object we will create a worksheet and with that worksheet object we will write the data for instance if the worksheet object is ws then ws.cell(row,column)=""

Make sure that the row and column is clearly given

 

Thanks

DataTable.Value ("Quantity",strDataSheet)=Quantity

Here strDataSheet is ur excel sheet name..and Quantity is u r column name...

regards

nareshqatester@gmail.com

Check the books on QTP here http://www.softwaretestingbooks.tk to solve all your problems in QTP

RSS

TTWT Magazine


Advertisement

Advertisement

Advertisement

Advertisement

© 2020   Created by Quality Testing.   Powered by

Badges  |  Report an Issue  |  Terms of Service