hi
ur using worng syntax man...u should use like this
''Load multiple datasheets from excel into QTP.
DataTable.AddSheet("Tabs")
DataTable.AddSheet("Navs")
DataTable.AddSheet("Portets")
'datatable.Import "F:\common.xls"
DataTable.ImportSheet "\common.xls","Portlets_temp","Tabs"
DataTable.ImportSheet "\common.xls","Portlets_temp","Navs"
DataTable.ImportSheet "\common.xls","Portlets_temp","Portlets"
On Mon, Aug 10, 2009 at 7:44 PM, Steve <[email protected]> wrote:
>
> I am trying to import three data sheets from one excel into QTP at
> runtime. It imports one fine, but the rest are empty. Here is my code:
>
> --------------------------------------------------------
>
> ''Load multiple datasheets from excel into QTP.
> DataTable.AddSheet("Tabs")
> DataTable.AddSheet("Navs")
> DataTable.AddSheet("Portets")
>
> DataTable.ImportSheet "\\<local shared drive>\CS_QA QTP Files\Portal
> \common.xls", "Tabs", "Portlets_temp"
> DataTable.ImportSheet "\\<local shared drive>\CS_QA QTP Files\Portal
> \common.xls", "Navs", "Portlets_temp"
> DataTable.ImportSheet "\\<local shared drive>\CS_QA QTP Files\Portal
> \common.xls", "Portlets", "Portlets_temp"
>
> ''Function that loads the excel spread sheets that are used for data
> input
> status = data_Import ("\\<local shared drive>\CS_QA QTP Files\Portal
> \common.xls", "Portlets", "Portlets_temp", Parameter("Data_Set"),
> rowToUse)
> If status = False Then
> reporter.ReportEvent micFail,"Data Import","Value Not found in Spread
> Sheet"
> exitRun
> End If
>
> --------------------------------------------------------
>
> The name of my QTP script is Portlets_temp
> (That is also the name of Action 1.)
>
> The function that is called above just grabs the first column value
> from the "Portlets" datasheet.
>
> When I run the script and have up the "Data Table" window to help me
> debug my script, I only see data get populated into "Portlets_temp",
> yet "Tabs", "Navs" and "Portlets" are empty. I want data to only
> appear in "Tabs", "Navs" and "Portlets".
>
> What am I doing wrong?
> Steve
>
>
> >
>
--
Mallipeddi Sreedhar
91-9000994721
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
-~----------~----~----~----~------~----~------~--~---
