Interested to Buy Any Domain ? << Click Here >> for more details...
How to Import data from a ".xls" file to Data table
during Runtime.
- 1 Answers
- 5373 Views
- I also Faced
- E-Mail Answers
Answer / sreeprasad
DataTable.Import("path of the file")
DataTable.ImportSheet("filepath","sheetsource","sheetDest")
Sheetsource:index or name of the sheet in the file which u
want to import. index begins vth 1.
SheetDest: index or name of the sheet in the datatable
which u want to replace vth Sheetsource.Index begins vth 1.
ex:
Datatable.importsheet("c:\name.xls",1,"name")
| Is This Answer Correct ? | 2 Yes | 0 No |
Hello Everybody, How to maintain the page state in QTP. My scenario is: 1. I opened a notepad file. 2. Entered some text in the notepad file. 3.And changed the font type and color of the notepad file. And saved that. 4.Now next time when I will open the notepad it is showing the changed font type and color, rather than the default values. Please provide the code. Thanks, Gaytri
How many check points are there in QTP and what are they?
Give the syntax to load function at run time.
Approach for Installation,comaptibility,system testing
Why do you choose only QTP for your project automation among remaining tools like Rational robot and silk test?
Please provide specific examples of advanced/creative usage of QTP, including how impact & benefits for your project
what is verification & validation?
Using Regular expression in Date format DD/MM/YYYY (0[1-9]|[12][0-9]|3[01])/(0[1-9]|1[12])/([0-9]{4}) in this regular expression year 0000 also accepted.I need atleast any one single digit must be nonzero value (like 0009,1000,0034)
I want to open a Notepad window without recording a test and I do not want to use SystemUtil.Run command as well How do I do this?
Did you face the problem, changing the properties of an object in Run Time?
How many scripts do you write per day. What is the average number of scripts you have written in your recent project
1 Answers CenturyLink, Optum, Value Labs,
What are the different scripting languages you could use when working with QTP ?
WinRunner 
