Inserting data in excel using write range workflow

Help
, , ,
1

inserting data in excel using write range workflow got error message

Untitled1
Untitled11440×900 54.7 KB

2

Hi @Aditya10989 ,
Are you trying to modify any data before ‘Write Range’?

1 Like
3

I am fetching data from excel using for each row I insert three value in variable then in add data row I am inserting datatable and three variable it successfully executed after this I am trying to insert this data in write range using workbook activity on that time I am getting error

4

Could you try using Write Range Activity with Excel Application Scope

5

yes got same message

6

Will it be possible to share a piece of workflow?

7

yes sureBot_Rasier.zip (2.4 MB)

8

did you got any solution

9

@Palaniyappan shall you help me on this…?

1 Like
10

let me check once
@Aditya10989

1 Like
11

the thing is we wont be able to a add or make any changes to a datatable if it under iteration within a for each or for each row loop
so rather adding the row to the same datatable
use a ASSIGN activity before to this FOR EACH ROW activity andd mention the
Finaldt = Exceldt.Copy
where Finaldt is a variable of type datatable with default value as New system.data.datatable

–now in the same for each row loop and add datarow activity mention the datatable as Finaldt instead of Exceldt…so that the new rows will be added to that excel datatable

Cheers @Aditya10989

1 Like
12

sorry did’t understand
you mean to say create another variable with the name of Finaldt with variable type datatable and use default value as New system.data.datatable this finaldt pass in write range…?
but assign activity we can’t use before loop because I am getting value from for loop

13

ok little bit understand let me try and will update you

1 Like
14

Hi I try but getting same message which I already mention.Kindly see the latestBot_Rasier.zip (2.4 MB) code

1 Like
15

let me check this
@Aditya10989

1 Like
16

I have done one mistake add data row I did not change the datatable to final now I changed see what happened

1 Like
17

is that working now @Aditya10989

18

almost more then 15 mintues I am executing this.it still showing in executing

19

oh god…running in debug mode…?
@Aditya10989

1 Like
20

yes I stop the execution and run this in debug mode