ビデオヘルプ
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Writing to an existing Excel spreadsheet with Workflow

作成: 04 Feb 2013 • 更新: 06 Feb 2013 | コメント数: 2
この問題は解決されました。 ソリューションを参照してください。

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.

コメント コメント数: 最新のコメントを表示

reecardo の写真

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.

ソリューション
John Atkins の写真

That got me close enough.  Thanks.

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

TN User Group Membership Director