Hi Ganesh, Thanks for your help. My requirement is to update the excel in Test plan. I have a folder "Automation" in which we are maintaining all Test Scripts. What we are trying to do is to get the datatable updated with an excel in the attachment section of "Automation" folder.
I have already tried the code what you have mentioned in the last e-mail, however, for some reason its not updating the excel in QC. Import is working fine though. Its very strange, the datatable.export is working fine if I use local path for that excel(it exports the runtime datatable in that excel) but it just export the static datatable (and not the run time datatable) when we use the QC Path. Thanks & Regards, Vivek On Mon, Oct 20, 2008 at 4:57 PM, Ganesh muralidharan <[EMAIL PROTECTED]>wrote: > 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 -~----------~----~----~----~------~----~------~--~---
