Answer Posted / jyotikrushna mohapatra

You can do by just parameterizing it.Let's explain with an
example. You have a datatable let table.xls in C drive and
if you want to extract the data from this excel file into
your document then write in the pane

datatable.importsheet "C:\\table.xls",1,destination

Here destination means where u have to place the data

I need to get some data from data base and store this (retrieved) data in a excel sheet using VB script in QTP9.0 I have created connection for data base I have created as excels sheet by using Set XL=CreateObject("Excel.Application") XLworksheet.cells(1,1).value= rs.fields.item("<>") I have taken a for loop and changed the cells values (1 as i and another 1 as j) But still I am not able to get Plz kindly tell me know this . It is very urgent

1928

---

How to Convert Hex color code to color name in VB Script?

4095

---

How will you format a number in percetage format in vbscript?

728

---

How will you get the octal value of the given number in vbscript?

651

---

Mention what are the rules to name variable in vbscript?

694

---

---

Write a code to print numbers from 5 to 0?

871

---

Explain about .wsf files?

757

---

what is used of Property........End Property loop ? how to write the script for it?

1857

---

Explain about tristate constants in vbscript?

773

---

Explain about the support of asp for vb script functionality?

662

---

how to write a vb script in QTP for yahoo registration form, i want to check the performance also like performance test, stress, load test like that.

4912

---

What are string functions in vbscript?

782

---

Out of the different type of operators, which are evaluated first and last in the vbscript language?

720

---

What are the special sub-types in vbscript?

696

---

while using Keyward driven framework in QTPif new requirements are added how to manage it...plz ans

1736

---