Input data from DataTable to Excel

Help Studio
1

Hi,

I have an Excel file which is then output as datatable that I’m working with. At the end of a workflow I’m adding add data row to the datatable. Can someone tell me how do I now copy/output the datatable to the first Excel which I’m using but not with Write Range activity?

2

USe append range activity of excel scope…

3

Is it better and faster than Write Range? Because I’m working with table where many rows are inputted daily so Write Range is actually very slow for that kind of process.

4

Try it with unchecking visible property of excel application scope…

Let me know if it works or we can look for another way…

image

1 Like
5

@markosc

Check if your excel is with .xlsx extenstion, then you can use workbook activities instead of using excel application scope etc.,

Hope this may help you

Thanks

6

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