I have a weird issue with workflow writing to an excel file. I have deleted information at the top of the excel sheet, but workflow keeps appending data at where it last left off. Any ideas?
I have a weird issue with workflow writing to an excel file. I have deleted information at the top of the excel sheet, but workflow keeps appending data at where it last left off. Any ideas?
Hello Tommy!
I would actually suggest not writing to an excel table at all. Excel only allows 10 simultaneous connections, so when using this solution in a production environment, you can run into problems. I suggest instead having Workflow write to a SQL table. That SQL table can then be connected to excel using "Get External Data". This type of a configuration will be safer when multiple workflows are running or any large amount of data needs to be written.
In this Presales demo featuring Education Grant Applications, there is an example and a set-by-step on how to set this up!