Workflow Soluiton

 View Only
  • 1.  Writing to an existing Excel spreadsheet with Workflow

    Posted Feb 04, 2013 05:19 PM

    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.



  • 2.  RE: Writing to an existing Excel spreadsheet with Workflow
    Best Answer

    Posted Feb 05, 2013 09:37 AM

    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.



  • 3.  RE: Writing to an existing Excel spreadsheet with Workflow

    Posted Feb 06, 2013 10:25 AM

    That got me close enough.  Thanks.