Senior Member.

Excel macro to export execution status from ALM

I have been looking to extract daily execution status from ALM 12.55 to excel sheet through excel macro.

We have two options

1. A Dashboard>>Analysis Veiw, where we get the consolidated status on each day like, Pass, failed, Blocked etc.

2. Test lab>> Test Set folder of respective releases

Could some one help me with this?

2 Replies
Benjamin Wesley Trusted Contributor.
Trusted Contributor.

Re: Excel macro to export execution status from ALM


At the moment, we do not have professional resources that can help us to create the code you need.

Yet, we have documentation and examples in where you can follow and customize your own code.



Test Lab OTA API samples:



OTA API reference guide:



How to generate the status report of test in testset using the API



Thank you

Best Regards

Sumeet_Kushwah Super Contributor.
Super Contributor.

Re: Excel macro to export execution status from ALM

It can be easily done using OTA API. You can connect Excel to ALM and then download the data using SQL queries. If you have any questions then you can post specific questions and someone will reply,

You can look into this article to get started with the OTA API 


Sumeet Kushwah

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.