In Studio: Get data per transaction from app and send it to an excel temple for each row

Help Studio
, ,
1

Hi,

I want to get data per transaction from an app and send it to an excel template file to the corresponding column per every row. FYI-my input excel file is the same as output one. The only difference is the output information/data sits corresponding to the input data in the same file. I am sharing screenshots for your visibility

image (7)
image (7)766×305 49.4 KB

2

Here is the template excel file that my source data is from and I will populate teh data I get from the app to this the same template

image (10)
image (10)1352×766 158 KB
I

Can anyone help with this?

3

@Sisay_Dinku

image
image795×713 16.5 KB

image
image1347×657 34.4 KB

image
image777×572 14.1 KB

image
image1523×710 40.6 KB

4

@sangeethaneelavannan1 I’d like to add a couple things
– I use modern design activities
– The data I receive from the app is just one transaction number
if there is a transaction number per each iteration, that is considered as a sucessful transaction otherwise failure
– Get text activity is employed only one time per iteration

Please let me know if you need more info

5

@Sisay_Dinku

For each iteration, the current row is a transaction item here and if the Get text activity is passed you can save the transaction number in the transaction item and status as well otherwise save the reason for failure in the transaction item.
Are you using REframework?

6

NO, I am not using REframwork

7

One more thing, the transaction number pops up like you see below. However, in the excel file I want it to be only the number part. Can you type the code for the logic you’re talking about?

image.png
image.png690×583 76.8 KB

8

@Sisay_Dinku dt_Output=dt_Output.Split(“:”)(1) .this will give only number from transaction number.

image
image575×523 11.5 KB

Main.xaml (16.6 KB)

9

@Sisay_Dinku Is the issue resolved?