How to Import data from a ".xls" file to Data table during Runtime.

Categories >> Software >> Testing >> Automation Testing >> QTP
Suggest New Category

How to Import data from a ".xls" file to Data table during
Runtime.

Question Posted / narendraa

10 Answers
27857 Views
BirlaSoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to Import data from a ".xls" file to Data table during Runtime...

Answer / rajshri

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

Is This Answer Correct ?

18 Yes

0 No

How to Import data from a ".xls" file to Data table during Runtime...

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

Is This Answer Correct ?

14 Yes

3 No

How to Import data from a ".xls" file to Data table during Runtime...

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

Is This Answer Correct ?

10 Yes

1 No

How to Import data from a ".xls" file to Data table during Runtime...

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

Is This Answer Correct ?

2 Yes

1 No

How to Import data from a ".xls" file to Data table during Runtime...

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.

Is This Answer Correct ?

0 Yes

0 No

How to Import data from a ".xls" file to Data table during Runtime...

Answer / varun bisaria

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

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

Is This Answer Correct ?

0 Yes

0 No

How to Import data from a ".xls" file to Data table during Runtime...

Answer / giri

datatable.Import("file path")

Is This Answer Correct ?

2 Yes

3 No

How to Import data from a ".xls" file to Data table during Runtime...

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

Is This Answer Correct ?

0 Yes

1 No

How to Import data from a ".xls" file to Data table during Runtime...

Answer / kirankumar.y

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

Is This Answer Correct ?

1 Yes

4 No

How to Import data from a ".xls" file to Data table during Runtime...

Answer / sateesh

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

Is This Answer Correct ?

1 Yes

17 No

Post New Answer