How to give variables to the ADD DATA ROW activity

Help
1

I am getting wrong output (in the excel sheet)after assigning the variables in Add ROW activity in the attached xaml file,

list_example (2).xaml (20.8 KB)

The output which I got is,

wrongoutput

This is the output I need to get,

requirement

Can anyone please look into the xaml and reply me where I did wrong,

2

@sushmithaelluru Check the below workflow and let me know if anything wrong. Check path of csv file once since edited it.

list_example (2).xaml (15.3 KB)

1 Like
3

Sure, Thanks @Manjuts90.

1 Like
4

Thanks @Manjuts90, its working.

1 Like
5

@Manjuts90, one doubt . After reading that excel sheet in the another xaml, the columns are getting attached in this way.

columns

Can I know where is wrong?

6

@sushmithaelluru Can u share xaml file and excel sheet?

7

Will send within 10 minutes.

8

@sushmithaelluru okay

9

The below xaml is the one where am using that excel sheet @Manjuts90

exchange currency.xaml (18.1 KB)

exchange ratess.xlsx (8.8 KB)

10

@sushmithaelluru It wont happen like as u mentioned in that screenshot. Run previous workflow again and read the csv file again in this workflow and let me know if problem exists. Check the file path once in which csv is created and path which is used in other workflow.

11

OK… Will check again.

12

@Manjuts90, Getting the same error mentioned above and giving the same excel in the two workflows.

The path of excel sheet given in two workflows are same too.

First workflow,

frist%20workflow
frist%20workflow798×490 11.1 KB

The second workflow ,

workflow2
workflow2786×541 14.9 KB

13

@sushmithaelluru Ur opening csv file in excel application scope that might be reason u getting like that.

In first workflow - use write range range activity instead of write csv and use extension as “.xlsx”

In second worflow - Read same “.xlsx” file previous problem will not occur again.

14

OK…Thanks for the reply…

1 Like
15

HI @Manjuts90, I used the excel application scope in the both with the extension of “.xslx” in both the workflows, it’s working now.
Thanks much.

1 Like
16

@Manjuts90, previously in the above xaml file, am giving the list of currencies manually, but now want to read from excel sheet.
Am trying the below logic, where am able to retrieve the currencies from excel and cannot give to the list variable to put that data in the excel sheet!!

This is the excel sheet,

Users List.xlsx (9.4 KB)

This is the previous xaml file, where I gave manually the list data(currencies),
list_example (2) (1).xaml (17.6 KB)

Can you please look into this new xaml @Manjuts90.
list2.xaml (17.1 KB)

Thanks in advance.

17

@sushmithaelluru I am not getting what exactly ur saying. Can u explain bit more?

18

Yes @Manjuts90. Yesterday I got the combination of currencies in the excel sheet by manually giving the values in the list .But now I gotthose values from the excel sheet, currencies column

image
image1060×200 7.3 KB

And got the output as

from%20excel
from%20excel1366×768 78 KB

So am stuck here how to proceed after getting those and get the combinations like

USD EUR
USD CAD
USD USD in the excel sheet.

19

@sushmithaelluru Check below workflow.

list2.xaml (14.7 KB)

20

Thanks so much @Manjuts90 its working :blush:

1 Like