Exporting multiple test set in a separate excel sheet from ALM to excel using vba

  • Questions
  • Exporting multiple test set in a separate excel sheet from ALM to excel using vba
Question ID: 107330
0
0

Hi Friends,

I have completed coding for exporting all test set which is present in test lab folder in single excel sheet.

But I want to export each test set in separate excel sheet.Please help me on this.

Thanks Advance!

PFB the code:

Set TCFactory = QCConnection.TestFactory

Set TSTreeMngr = QCConnection.TestSetTreeManager

‘qcPath = "Root\\ECommerce – B2C\\Autozone.com\\B2C – DIY\\Search Enhancement – Part 2\\Search Enhancement-New Changes\\"

qcPath = Worksheets("Input").Range("K15")

Set TSFolder = TSTreeMngr.NodeByPath(qcPath)

Set TestSetList = TSFolder.FindTestSets("Desktop")

If TestSetList Is Nothing Then

MsgBox "No Test Cases are there in this location"

Else

clearSheet For Each TSet In TestSetList

‘Get TSTestFactory object for each TestSet

Set TSFact = TSet.TSTestFactory

‘Get TestCases of selected Test Set

Set TSTestsList = TSFact.NewList("")

For Each TSTest In TSTestsList

With Sheets("Test Case Data")

.Cells(tlrow, 1).Value = TSTest.Field("TS_Name")

.Cells(tlrow, 2).Value = TSTest.Field("TC_STATUS")

tlrow = tlrow + 1

End With

Next

Next

End If

Marked as spam
Posted by (Questions: 1, Answers: 0)
Asked on January 9, 2017 5:36 pm
54 views
Answers (1)
0
Private answer

@lakshmi19902017,
Is your issue resolved?
I am working on the similar requirement. In addition I would like to add few more columns like Test Setps Status, Responsible Tester, Step Name, Step Description, Actual Result, Expected Results.
Would you please share your code, if you have.

Marked as spam
Posted by (Questions: 30, Answers: 35)
Answered on August 8, 2018 5:56 pm