Input data from DataTable to Excel


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?

USe append range activity of excel scope…

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.

Try it with unchecking visible property of excel application scope…

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


1 Like


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


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