Answer / nagk24

we should not give parantesis

datatable.importsheet"path of excel","excell sheet name","action id(or)action name"
datatable.importsheet"d:\data.xls","sheet1","Action1"

Answer / kiran

yes u can import an excel sheet into datatable

datatable.importsheet("path of excel file",excel sheet name",sheid)

for ex:datatable.importsheet("c:\products.xls","sheet1",2)
hear 2 means: action sheet id

what type of automation is follwed in the project?

0 Answers   Google,

---

Can any one explain about environment variables with examples?

2 Answers  

---

How to run scripts 1,29,3,5,7,2 scripts using test batch runner in QTP.... Ie...I wanted to run scripts not in an order 1,2,3,4,5...like that How it is possible using test batch runner... I dont want hardcoded script

0 Answers   IBM,

---

I am using "QTP 9.0" in my system, need to install java add-ins to test the java based applications, please prvide information from where i can get those java add-ins for QTP 9.0

0 Answers   Infosys,

---

How can i see test results in excel sheet ? test data not present in data table.

5 Answers  

---

---

How we can add objects to the object repository during the running?is it possible or not?explain

3 Answers  

---

how to acess a test in RSA?

0 Answers   IBM,

---

why was automation used in the project?

1 Answers   Google,

---

Hi I have created a table in the MS access database. I want to access the table in this database through QTP. The code is given below. The code is not working.The following error is displayed "Data source name not found and no default driver specified". Any one can correct the code. Thanks in advance. Dim dbconnection, rs Dim ca, sname Set dbconnection = createobject("ADODB.Connection") Set rs = createobject("ADODB.Recordset") dbconnection.open "DSN = MS Access Database","", "" rs.open "select * from Research", dbconnection rs.movefirst If rs.EOF <> True AND rs.BOF<> True then ca = rs("order_number") sname = rs("customer_number") rs.movenext msgbox ca msgbox sname End If

1 Answers  

---

what is the script(qtp) to export and import the datas from MSaccess to Excel sheet.if anybody know plz tell me.

3 Answers  

---

What phases are involved in testing an application in qtp?

0 Answers  

---

Hi, one script having 10 Actions,but i want to execute only 3rd action and 7th action? how to execute selected actions? throgh script and through navigation?

2 Answers   IBM,

---