| || |
Unable to Import Excel from QC
Iam trying to Import Excel Sheet from Quality Center.
I uploaded excel sheet in Quality Center in Test Resources tab.
Kept Settings in QTP .Go to Tools>>options>>Folders>>Kept Settings for Test Data folder in Quality Center
When iam trying to Run QTP Script from Quality Center then script is showing an error unable to import excel sheet.
Can i know what would be the error.
I tried another method in uploading Test data
Datatable.ImportSheet "[QualityCenter\\Subject\Folder Name\Test.xls|","Sheet1",2
Same error got for this script also.
Try the string in File>settnigs. Then in the Location box there is a value.
Perhaps you do not need the double slash after Subject.
Use PathFinder.Locate method.
Datatable.ImportSheet PathFinder.Locate("[QualityCenter\Resources] Resources\TestData") -> TestData - Resource Name
Datatable.ImportSheet PathFinder.Locate("TestData") -> TestData - Resource Name
with Folders specified in search list (Tools > Options > Folders)
you can use prefix:
[Quality Center/Resources] Resources\...
to specify the path in Test Resources tab of QC