In order to import excel: datatable.ImportSheet "C:\QTP\test.xls",1,3
Syntax : Datatable.Importsheet(“nameofExcelfilewithpath”, “nameofthesourcesheet”, “nameofthedestinationsheet”) in order to refer column value in a datatable Datatable.Value(“Columnname”) to Export: datatable.ExportSheet "C:\Documents and Settings\aa\Desktop\test1.xls",3 *Syntax:* Datatable.Exportsheet(“nameofExcelfilewithpath”, “Nameofthesheet”) On Fri, Nov 25, 2011 at 5:53 AM, avinash vl <[email protected]> wrote: > Hi, > > How can I import/export spreadsheet to QC, currently we are using excel > sheets for Parameterization. I'm new to QC > QC Version 11.0 > QTP Version 11.0 > > Please help > > -- > Regards, > Avinash > > > -- > 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 -- 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
