+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: data table (/Thread-data-table)
data table - sia sharma - 09-06-2012
Dear All,
i have a excel sheet "datasheet.xls" which contains 50,000 entries in it
i want to export the data into datable...
how can i do this?
Thanks,
sia
RE: data table - ksrikanth2k9 - 09-07-2012
use Datatable.import filepath for importing into datatable
RE: data table - sia sharma - 09-07-2012
I have used the same
This is my code
Code:
Datatable.Import "D:\datasheet.xls","<Sheet1>","<Global>"I get this result when i run this code........
Wrong number of arguments or invalid property assignment: 'Datatable.Import'
I have tried this also
Code:
Datatable.Import "D:\datasheet.xls",1,1I have used this also
Code:
Datatable.Import "D:\datasheet.xls",1,1RE: data table - sshukla12 - 09-07-2012
Hi,
Use Datatable.ImportSheet "D:\datasheet.xls",1,1
Regards,
Sankalp
RE: data table - freeboynil - 09-09-2012
Code:
Datatable.Importsheet "D:\datasheet.xls","<Sheet1>","<Global>"RE: data table - SIBICA - 09-10-2012
Hi,
Use DataTable.ImportSheet "D:\datasheet.xlsx",1,"name"
name : is the namesheet in the test's run time Data Table
Regards,
Sibi C A
RE: data table - SIBICA - 09-10-2012
Hi,
Here use Datatable.Importsheet "D:\Sheet.xls","Sheet1","Global"
Dont include anything else.
I think It may work.
Regards,Sibi C A
RE: data table - SIBICA - 09-10-2012
Hi sia sharma,
Just confirm that whether the datatable is present in the D drive of your system and the name of the excel sheet that you have entered in QTP is matching with the Excel sheet name.Check the spelling also because, inside double quote the data is case sensitive.
Regards,
Sibi C A
RE: data table - sia sharma - 09-10-2012
The name of the excel sheet is matching and it is present in D drive.
what does it mean "the datatable is present in the D drive"?
RE: data table - SIBICA - 09-10-2012
I just wanted to confirm that the datasheet is there in your D drive.
Again you are getting errors?
Please share the screenshots of the error and the datasheet(Excel sheet in D drive).
Regards,
Sibi C A