Interested to Buy Any Domain ? << Click Here >> for more details...
How to Import data from a ".xls" file to Data table during
Runtime.
- 10 Answers
- 27830 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajshri
datatable.Import("file path")
datatable.Importsheet("file path",sheetid)
| Is This Answer Correct ? | 18 Yes | 0 No |
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 |
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 |
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 |
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 |
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 |
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 |
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 u will do versioning in QTP?
how to call a funtion in a script? i have saved the login scipt in notepad. with extension .vbs. But when i am calling the function with the keyword CALL <Function Name>. its not working out. can any one give me a clue how to call the external functions. with example.
What is use of object spy?
How QTP recognizes Objects in AUT?
Give the syntax to import/export xls into qtp.
Explain in brief about the quicktest professional (qtp) automation object model?
What are the check points can be inserted without recording?
What kinds of security (firewalls, encryptions, passwords, etc.) will be required and what is it expected to do? How can it be tested?
How we will execute(run) the scripts in qtp 8.2?
What is the difference between CVS and VSS? Are you store QTP SCRIPT In VSS OR CVS? Where you store QTP Script?
1 Answers Brain Roots, Ordain Solutions,
What is the descriptive programming?
what is option explicit?
WinRunner 
