I found below syntax in site : http://spqtp.blogspot.com/2008_09_01_archive.html
9) How to import excel file from Quality center (9.2) to QTP (9.2) data table? A) We can import with data table import command, but file path we have to give in specified format only. See the below code. Code:- DataTable.ImportSheet "[QC-ATTACH];;Subject\DomainName\Project Name\Automation\ScriptName;;\Excelfilename.xls","Source Sheet name","Destination sheet name(datat tale sheet name)" On Mon, Oct 20, 2008 at 4:06 PM, Vivek Prakash <[EMAIL PROTECTED]> wrote: > > Hi Ganesh, > > Thanks for your help, however, it seems either I am doing it wrongly, or > this is not exactly what I am looking for. > when I run this code using QC, I always get a pass status but nothing > happens in the attachment section. > > What I am trying to do: > ================= > > I am trying to update the datatable using QTP script and will use the same > data for other script (in a batch process run from QC). What is happening > right now is that qtp is exporting the static datatable and not the runtime > datatable using the code: > > datatable.Export "[QC-ATTACH];;Subject\Automation;;\Country_List.xls" > > I need to export the runtime datatable after a successful run of the script > which is using one Global datatable. > Any other thought on this will help a lot. > > Regards, > Vivek > > On Mon, Oct 20, 2008 at 11:18 AM, Ganesh muralidharan <[EMAIL PROTECTED] > > wrote: > >> Hi Vivek, >> >> You will have to export the QTP datatable to a local path and use QC code >> to upload the same to QC. >> >> sample code to upload to QC run attachments below >> Public Sub UdsUploadOutput(strPathName) >> Dim obj_Afact >> Dim obj_Att >> >> Set obj_Afact = QCUtil.Currentrun.Attachments >> Set obj_Att = obj_Afact.AddItem(Null) >> obj_Att.FileName = strPathName >> obj_Att.Type = 1 >> obj_Att.Post >> >> Set obj_Afact = nothing >> Set obj_Att = nothing >> End Sub >> >> Here 'Input Parameters : Output file with path >> >> >> On Mon, Oct 20, 2008 at 10:31 AM, Vivek Prakash <[EMAIL PROTECTED]>wrote: >> >>> Hi All, >>> >>> I need your help in exporting datatable to an excel file which is there >>> in QC. >>> I tried datatable.export, however, its giving error that file not found. >>> QTP is connected with the appropriate project in QC and other files like >>> XML or OR are getting connected properly. >>> Just having issues with datatable-excel export in QC. May be I am not >>> doing it correctly. >>> Please help. >>> >>> Regards, >>> Vivek >>> >>> >>> >> >> >> -- >> Ganesh Muralidharan >> Wipro Technologies >> Mob. : 9341023574 >> >> 'God Never Forgets' >> >> >> > > > > -- Ganesh Muralidharan Wipro Technologies Mob. : 9341023574 'God Never Forgets' --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
