Insert data in excel sheet

Help
21

@lakshman Hi I am getting this error

Untitled
Untitled1440×900 92.1 KB

22

@lakshman now it is executing successfully but not showing any data which I need to insert column processing status fail and column exception reason amount greater then 60 right now these column showing me empty

23

@AshwinS2 Its executing but not able to insert these value in column amount is false
column name “Amount is greater than 30”
right now both the column showing empty

24

Hi use

Dt.columns(“column name”). expression=“Amount is greater than 30”

Thanks
Ashwin.S

25

@AshwinS2 I used this throwing error as mentioned in attachment

Untitled
Untitled1920×1080 131 KB

26

Hi @Aditya10989

Use dt.columns(“column name”).column name.expression=“Fail”

Thanks
Ashwin.S

27

@AshwinS2 now

Untitled
Untitled1920×1080 104 KB
getting this error

28

Remove expression

Thanks
Ashwin.S

1 Like
29

thanks but now getting this error

Untitled
Untitled1440×900 66.8 KB

30

Untitled
Untitled1440×900 65.6 KB

31

@lakshman shell you suggest me…?

32

@sandeep13 can you please help me…???

33

Hello @Aditya10989
You assign value in datarow?? Right

34

Hello @Aditya10989
You can not assigned value in data table like you do. If you remember level 3 assignment 1 we use such activity
You should create data row activity then assign in data table in datarow property.
I not remember exactly property name

Thanks

2 Likes
35

Any reason you would not use an excel formula for this? In some solutions I create a blank template file that I then put data into from the source. I keep my formulas in the excel template to keep things simple.

Place in Z column
=IF(V2>60,“Fail”,“Good”)

Place in AA column
=IF(V2>60,“column processing status fail and column exception reason amount greater then 60”,“”)

1 Like
36

@sandeep13 Thank you very much

1 Like
37

@LeftBrainCo Thank you very much

1 Like