How to bind data table and three variable in new excel sheet

Help
, , ,
21

no I already check this both contain 15 column but in one column have empty value

22

yes I checked in debugged mode.Actually my excel sheet 12 column contain.I added three more column in filter data table as mentioned in attachment and that 15 property I am passing in arrayrow as mention in attachment and in debug mode for each contain only 12 column

Untitled
Untitled1440×900 72 KB
Untitled1
Untitled11440×900 53.4 KB
@balupad14

23

I think before this I need to create three column in excel Loss cal,dc cal,ao cal

24

@lakshman
1.write range activity used in side workbook or excel …?
2.and we need to mention write range outside the loop…?

25

@Aditya10989

  • Add DataRow activity should be inside the loop.

  • You can use Workbook Write Range activity or Excel Write Range activity.

26

workbook write range activity outside loop…?

27

I insert workflow write range activity I got

Untitled1
Untitled11440×900 54.7 KB
error message

28

Yes it should be outside loop.

1 Like
29

yes thanks

1 Like
30

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.