How to insert datatable from Execute Querie into excel?

Help
1

Hi all!
I have a Database like this:

|ID|Month|Validation|
|1|08|Coincide|
|2|09|Coincide|
|3|07|Coincide|
|4|09|Coincide|
|5|07|Coincide|
|6|07|Coincide|

And I want to insert it into excel file like this (A,B and C are Excel cells, n is the counter for number of rows in original database):
For ID 1: A1:1,B1:08,C1:Coincide
For ID 2: A2:2,B2:09,C1:Coincide
.
.
.
For last ID:A+(n+1),B+(n+1),C+(n+1)

I’m using for each row activity and write cell activity with a counter that increments each iteration and allows me to write in each excel file but it takes too much time. Does anyone know how can I to improve this process?

Regards,
Juramirez

2

Use Write Range activity and directly write the whole datatable in excel

3

Wow, didn’t see it before. Thanks!

1 Like
4

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