Answer / rajshri

datatable.Import("file path")
datatable.Importsheet("file path",sheetid)

Answer / 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")

Answer / chinna

Hi,

Datatable.Importsheet("Path of the sheet",Source sheetid,
Destination sheetid)

Ex.Datatable.importsheet("C:\Book1.xls",1,1)
z=datatable.getrowcount
For i = 1 to z

datatable.setcurrentrow(i)

A=datatable.value(1,1)
b=datatable.value(2,1)
c=a+b
datatable(3,1)=c
Next
msgbox c

Answer / masack

If you want import all the sheets of the workbook during
runtime datatable.

Dim array_shtname()

Set xls = createobject("Excel.Application")
xls.visible = true
Set xlsop = xls.workbooks.open ("excel\path")
shtcount = xlsop.worksheets.count

ReDim preserve array_shtname(shtcount)

For sh = 1 to shtcount
array_shtname(sh-1) = xlsop.worksheets(sh).name
Next
xls.quit

Data_Sheet_Count = datatable.GetSheetCount

For i = 1 to shtcount
Datatable.AddSheet Cstr(array_shtname(i -1))
datatable.ImportSheet "excel\path",i,cint(Data_Sheet_Count)
+i
Next

Answer / sanhosh

The following example uses the ImportSheet method to import the first sheet of the name.xls table to the name sheet in the test's run-time Data Table. 
DataTable.ImportSheet "C:
ame.xls" ,1 ,"name"




How ever in runtime data table iam unable to get the sheet pls help me.

Answer / varun bisaria

Datatable.Import "...XLS file name..."

DataTable.ImportSheet(FileName, SheetSource, SheetDest)
DataTable.ImportSheet "C:
ame.xls" ,1 ,"name"

Answer / giri

datatable.Import("file path")

Answer / srinivasulu

Dim Shet1' Add a new sheet
Data table.Addsheet "shet1"
'datatable.importsheet "file name","Source
sheet","destination sheet"
datatable.importsheet "file name","sheet 1","shet1"
'now we can check the run time data table

Answer / kirankumar.y

varaiable=data table.value("perameter name",dt global
sheet/dt local sheet)
if it is wrong please correct me

Answer / sateesh

i think it is ddt_import("....");

Syntax for how to call one script from another? and Syntax to call one "Action" in another?

2 Answers  

In google i'm going to search something like "rose", i usually get 10 results in the first page and in 2nd page 10 results and in 3rd 10 results so on upto 10th page 10 results. so if i want to open all the 10 pages 10 results i.e., 100 results and close..what is the DP for this? pls can anyone answer my Question..PLZZZZZ...

4 Answers   Indium Software,

write the regular expression for date format of mm/dd/yy?

10 Answers   CTS, HCL,

Suppose you are using shared objects repository in your test and you want to split your present action? At that time shared object repository is single or it’s also splits?

0 Answers  

What are accessibility check point and xml check point?

5 Answers   IBM,

Explain in brief about the qtp automation object model (aom).

0 Answers  

I have enrolled for a QTP course which is a four weekend course.Do you think its a good way to start off learning this tool?What all do i need with me in order to become a pro at using this tool?

0 Answers   TCS,

How to supress warnings from the "Test results page"?

6 Answers   BirlaSoft,

Can any body help me to write descriptive program to find a cell value (say 2 row, 3rd column) in a datatable which is creating dynamically and statically

0 Answers  

In a QTP project lets say there are 100+ function library and incorrectly we have duplicate some function in multiple libraries. How to find those duplicate functions and remove them?

1 Answers  

What are the different ways to invoke an application using QTP?

0 Answers  

OPening of notedpad in QTP to write and execute the coding?

2 Answers