You are viewing limited content. For full access, please sign in.

Question

Question

workflow writing to excel, but not at the top?

asked on October 22, 2014

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?

 

0 0

Replies

replied on October 27, 2014

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! 

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.