Export results from BAPI test to local excel sheet in UFT

[dwarak001]

Hello 

I recently started to use SAP BAPI to test in UFT we have a combination of GUI and SAP BAPI's in our test. I want to know how do I read and write the values of what the BAPI returns to the local excel sheet. Is there a standard way of doing this? I could not find any or will it be custom code in C# 

[JamesXue]

hi, there

UFT has a data file and there are 'Global' sheet and other sheets corresponds to the name of Actions. So you may in your code import the data from the output of your BAPI Test into the Global sheet. In this way, the data will be dynamically loaded before running the UFT test. 

For more detailed help, please refer to ADM online help.

Thanks.

James

[dwarak001]

Hello James,

The API test does not use a global sheet I know hoe to write to a global sheet in a gui test not sure what you are refering to I am importing an external sheet into my API test and want to write to that the method 

GetDataSource("Customer_Info!Sheet1").SetValue(2,"CRN","10000000");

does not work 

[JamesXue]

hi, 

yes, I was referring to GUI test. Sorry about that. For API test, you can either import the file in the Data pane or read content from a file with an Activity. 

For customer code, it's also an option. You may add an Activity of Custom Code and put the desired data to an output value to be consumed by the other activities.

Thanks.

James

[dwarak001]

Thanks for the reply is there any code snippet that you have seen