data table

[sia sharma]

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

[ksrikanth2k9]

use Datatable.import filepath for importing into datatable

[sia sharma]

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,1

---

I have used this also

Code:

Datatable.Import "D:\datasheet.xls",1,1

[sshukla12]

Hi,
Use Datatable.ImportSheet "D:\datasheet.xls",1,1

Regards,
Sankalp

[freeboynil]

Code:

Datatable.Importsheet "D:\datasheet.xls","<Sheet1>","<Global>"

[SIBICA]

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

[SIBICA]

Hi,
Here use Datatable.Importsheet "D:\Sheet.xls","Sheet1","Global"
Dont include anything else.

I think It may work.

Regards,Sibi C A

[SIBICA]

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

[sia sharma]

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

[SIBICA]

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