Writing to an existing Excel spreadsheet with Workflow
Created: 04 Feb 2013 | Updated: 06 Feb 2013 | 2 comments
This issue has been solved. See solution.
I need to have data that is coming from a web form and have it added to an Excel spreadsheet. Not overwrite and existing, but just drop to the next line of a spreadsheet and save the data each time something is submit by the form. Is this possible? If so, can someone tell me how.
Thanks in advance.
Discussion Filed Under:
Comments 2 Comments • Jump to latest comment
While there's no "append" functionality for Excel out-of-the-box, you could try the following:
1. Save your Excel document as a .csv file (or copy the Excel file to a .csv file)
2. Use a Append Lines to Text File component to append new comma separated data to the CSV file.
3. Use a Write File component and write the appended file back as a .xls file..
If your Excel file is pretty basic, this should work.
That got me close enough. Thanks.
John Atkins
Advanced Client Services Engineer
LifeWay Christian Resources
http://www.lifeway.com
TN User Group Membership Director
Would you like to reply?
Login or Register to post your comment.