Interested to Buy Any Domain ? << Click Here >> for more details...
How to export data present in Datatable to an ".xls"
file?
- 3 Answers
- 10130 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
What are the different types of recording modes in qtp? Which will be used when?
explain keyword driven framework with banking domain?
How do you capture tooltip using QTP?
How to get the format of a webedit class in qtp. How can i know that particular webedit accept what type of format like "mm/dd/yyyy" or "$" or Alphanumeric
What is clean sweep?
can any body clearly explain about keyword driven framework .give me the explanation for files what ever you use in this frame work?
I used the below code to open QTP through VBscript?But i can unable to Invoke QTP...PLZ help me with the correct code to invoke QTP through VBS with description of the code aswell. Dim qtApp 'As QuickTest.Application 'Declare the Application object variable Dim qtTest 'As QuickTest.Test 'Declare a Test object variable Dim qtResultsOpt 'Declare a Run Results Options object variable Set qtApp = CreateObject("QuickTest.Application") 'Create the Application object qtApp.Launch 'Start QuickTest qtApp.Visible = False 'Make the QuickTest application visible qtApp.Open "C:\form", True 'Open the test in read-only mode 'set run settings for the test Set qtTest = qtApp.Test qtTest.Run 'Run the test 'WScript.StdOut.Write "Status is: " & qtTest.LastRunResults.Status 'Check the results of the test run qtTest.Close 'Close the test qtApp.quit 'Close QuickTest Pro Set qtResultsOpt = Nothing 'Release the Run Results Options object Set qtTest = Nothing 'Release the Test object Set qtApp = Nothing 'Release the Application object
Hi Friends, Can anyone help me out in this one? In QTP, I am using Data Driver and want to parameterise multiple values (say 3 values ) for a field. How can I do it using Data Driver wizard? Plz mention it step-by-step. In the end after doing the needful, on opening the Data Driver window, how can I get number (i.e. 3) in the Parameterised column for that particualr value? Thanks a lot in advance.
How do client side image and server side image work?
Dear sir, i want to perform a QTP automated testing for mechancial engineering software like msc adams, msc nastran this softwares will help for mechanical engineering design analysis>> i know oad runner win runner, test director, QTp>> but i dont know how to use for automation
hi all can any body explain how to write the script for finding the mandatory fields which are having [red Astrik sign (*)]
Hi, My name is kishan. I have good Conceptual Knowledge on QTP. In order to Boost up my Confidence Level, I want to do a Project oriented Training only on QTP in Hyderabad. Kindly Let me know which is the Best QTP Project Training Institute in Hyderabad. Thanks in Advance kishan
in data driven testing for performing operations which method is easy from manual test data,keyword view,or from database.and why?
How to test the login page in different ways in automation testing and i need code?
How to use userdifined environment variables.Once we created in Environment tab which is at File--> Settings-- >Environment-->Userdifined
