+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: export UFT datasheet to excel and then append (/Thread-export-UFT-datasheet-to-excel-and-then-append)
export UFT datasheet to excel and then append - Mozza - 09-04-2018
Hi
I have created a datasheet for uploading in ALM (xlsx excel file) and this inputs to script when it is ran in the Test Lab of ALM
When the script runs, it passes created application information back into the datasheet (which can be seen in Test Lab report results)
This information, I would like to capture into a permanent excel as it can be used for other things
Question 1
I have the following which works fine
DataTable.ExportSheet "Z:\VCR\9. Testing\Test Execution\Maureen\Client Reg.xlsx" , "Global"
But.....
I would like it to be stored in ALM (so all testers in team can see it) and the following does not work - path does not exist
DataTable.ExportSheet "[ALM]Resources\DVA\Test Run Results\Client reg", "Global"
Can anyone help - is it possible to put the xlsx file into ALM
Question 2
As this can be ran many times by multiple users, I would like to just keep appending the datasheet to the xlsx
Can anyone help - is it possible (either in ALM or out)