Video Screencast Help

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.

Comments 2 CommentsJump to latest comment

reecardo's picture

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.

SOLUTION
John Atkins's picture

That got me close enough.  Thanks.

John Atkins
Advanced Client Services Engineer
LifeWay Christian Resources
http://www.lifeway.com

TN User Group Membership Director