Hi vivek, Your requirement is to update an excel in Test plan or test lab?
The code sent by me was for Test lab run. On Mon, Oct 20, 2008 at 4:38 PM, Ganesh muralidharan <[EMAIL PROTECTED]>wrote: > 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' > -- 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 -~----------~----~----~----~------~----~------~--~---
