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("....");

Explain about the test fusion report of quicktest professional?

0 Answers  

How to define array in qtp?

0 Answers  

what is runmodes in QTP

1 Answers  

Can I record on netscape browser does it require any special settings ?

2 Answers  

By using QTP, How do you test a frame in a web page?

4 Answers   TCS,

Thanks Rag... One more question, How we test the dynamic images which frequently changed?Using the bitmap checkpoint r any other options available.... Can u give the steps pls... Thanks

1 Answers  

In smart identification, explain about 1. Base filter properties 2. optional filter properties with examples?

2 Answers   TCS,

How to integrate QTP with QC using VB Scripting? What are the prerequisites to connect with QC?

0 Answers   CTS, Nabard,

how to create user defined functions in QTP? can any one expalin me with example.. Thanks in Advance for help

4 Answers  

Is there any MS Access addin in QTP?

7 Answers  

I Scheduled a QTP Script on remote desktop. Script is going to failure,when remote desktop connection fails.I have to open my remote desktop untile the scripts exection completes. If I disconnect my remote desktop connection, script is going to fail.?

1 Answers   TCS,

QTP WAS WORKING FINE BUT TODAY I GOT THE ERROR , THE MEMORY COULD NOT BE READ -REFERENCE MEMORY ,pPLEASE REPLY URGENT WHAT IS THE SOLUTON

1 Answers