Interested to Buy Any Domain ? << Click Here >> for more details...
How to Import data from a ".xls" file to Data table during
Runtime.
- 10 Answers
- 28173 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / deeps
Hi,
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 ? | 14 Yes | 3 No |
Post New Answer View All Answers
What are the recording modes in qtp?
Can anyone share/send me QTP 8.2 Crack as I had it before but now it's virus affected. Pls send me on Sawale.vijay@gmail.com Thanks, ~Vijay
How to make qtp understand the difference amongst the same type of objects .suppose there are 5 check boxes in a page and I have to choose the 2nd one, how to do that through script?
What are the challenges you faced during you entire life automation ?
How do you do batch testing in wr and is it possible to do in qtp, if so explain?
What are the different attributes used with regular expression?
What is data driver in qtp? Where we use it?
How do you delete unwanted results in qtp?
Hi all, I am using windows vista, I am in the process of learning QTP. When ever I try to work with insert mode in flight application , i am getting the error of 'Operation must use an update table query, fractional truncation(null) error. Can anyone help me regarding this?
Which functionalities of QTP used in banking project? pls any say answer?
What is quicktest professional (qtp window?
How many types of status are there?
Define virtual object?
i have two questions for regular expression :- Q1. I have date pattern eg-29/11/2011 29-11-2011 29.11.2011 Que- if any separator is there between date,month and year pattern should match else it should not match eg- pattern should not match in case of 2911-2011 Q2. let say i have a string and there is a number in between of that string eg.-Amount 30002.234 successfully credited to your account . now i have to match this pattern in such a way that even if decimal is not there pattern should match ,how i will do this using regular expression
Hi frens! I am testing VB project with MS Access database. At add button click my record is storing in data table and it is shown in datagrid. So at Delete button click i want to check datagrid rows 9before and after delete). so how can i do it using descriptive programming?
