I need to export the values of the module data into the EXCEL template.
Consider the scenario that you are running the script in the project folder path. Inside the EXCEL Template there is only one sheet you need to export.
The folder name (Eg: BON,NAME etc) inside the path should be exported under System Heading in the EXCEL template, next is the TEST heading inside the EXCEL where all the modules under the folder "TEST" should be updated.
The next two columns will be fetched from the attribute value (TEST RUN attribute).Same way for REQ modules too.
I have attached the Template where the data needa to be exported
I am not very sure how to export the data back to EXCEL to the specific cell.
Please help me out!