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

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"


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



End If

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

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

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top