How to export data present in Datatable to an ".xls"
file?
- 3 Answers
- 9467 Views
- I also Faced
- E-Mail Answers
Answer Posted / chinna
Hello,
Export data into Excel Sheet we will follow 2 methods.
1. Datatable.Export("Path of the sheet")
2. Datatable.Exportsheet "Path of the sheet",Source sheet id
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
How will you check a web application for broken links using qtp?
what is description object?
Can anyone tell me how i used QTP 9.2 use for GIS based S/w with an example?
How can you handle exceptions in qtp?
Hi Guys, I want to place all of my values which i am getting it from a loop in to a global shee. For that i had written the script like this For i = 1 to ECOs-1 ECO = List(i).GetROProperty("innertext") DataTable.AddSheet("ECOList") DataTable.GetSheet("ECOList").AddParameter "ECOList",ECO AbortECO = DataTable.GetSheet("ECOList").GetParameter ("ECOList").Value msgbox AbortECO DataTable.GetSheet("ECOList").SetNextRow Using the above script, whenever the loop iterates it is creating new column "ECOLIST" in the sheet called "ECOLIST". It means, the values are displaying in the column wise even though i added the script " DataTable.GetSheet("ECOList").SetNextRow" . The cursor is not moving to the next line. Anybody help me out how to pass the values from script to the excel(Global/Local) sheet. Pls let me know @ nbabu11@gmail.com if you are not clear about the question.
Explain the views in the QTP GUI?
any body can you help me what is the script to automate an comand promt
Call to copy of an action and call to existing action… i know the diff but in real project how to use..? i want live scenario.pls help me..
You will receive the mail in your outlook from client at night time to go ahead for the execution. Based on the mail you need to trigger the batch run. What is the QTP Code for this?
what is error and fault in terms of software quality?
How to use actions in qtp ?
How do you send email with attachment from outlook using qtp ?
What are the types of object repositories? Which one is you using?
when u script reveiwing in which area u more concentrates?
what is the difference btn risks & Therads in the Test plan documentation?
