How to upload excel files into Quality Center using QTP Script and how to delete excel files from Quality Center using QTP Script?

NawabShaikh

 Profile Answers by NawabShaikh Questions by NawabShaikh

• Feb 21st, 2008

 

You need to use API's of Quality Center in the Script.

venkat_siqes

 Profile Answers by venkat_siqes Questions by venkat_siqes

• Apr 19th, 2010

 

You Must have MS Excel plugin installed in your system, then you will get one option in your Excel---> Export to QC.



Regards
Venkat

BSony

 Profile Answers by BSony Questions by BSony

• Aug 10th, 2011

 

Uploading text or xml files to quality Center:--------------

Function UpLoadAttachmentToQC(FilePath)
Set ObjCurrentTest = QCUtil.CurrentTest.Attachments
Set ObjAttch = ObjCurrentTest.AddItem(Null)
ObjAttch.FileName = FilePath
ObjAttch.Type = 1
ObjAttch.Post ObjAttch.
Refresh
End Function


Call UpLoadAttachmentToQC(FilePath) This works fine with Quality center 10.0 Version... but to achive the same task in Quality center 9.0 version ,we need to use ObjAttch.Save(True) Method also. This save method works fine with quality center 9.00 but not with 10.00 version. also i want the difference between save and post methods!!!!

Aruna

• Feb 23rd, 2012

 

Install the Execl Add in to the QC........

!open the excel u want to Export
!Click on the Add In Menu on the Excel
!Excel export option will come........

Provide the Respective path