locked
Workflow 4.0 Excel Destination RRS feed

  • Question

  • I am new to Workflow, but have a lot of experience working with SQL Server 2005 Integration Services. 

    I have created a Dataflow that reads rows in from a database and filters them.  I need to be able to write the processed rows out to an Excel spreadsheet.  If I were using SSIS I would add an Excel destination object to the dataflow, define the column mapping and it would be a done deal.  With workflow there are not destination objects that I can find. 

    I know that with WF, we are strongly encouraged to use WCF services for reading/writing data.  Is there a way to write to Excel just using WF, without needing to use WCF too?

    Thanks.

    Monday, July 26, 2010 4:25 PM

Answers

All replies

  • Hi Neil,

    I've not done this myself but using the following it seems doable:

    1- WF ADO.NET Activity Pack CTP 1 : http://wf.codeplex.com/releases/view/43585

    2- How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET:http://support.microsoft.com/kb/316934/en-us

     

    You can take advantage of #1 and create your own Activity if need be.

     

    Ameen.

    • Proposed as answer by Andrew_Zhu Thursday, July 29, 2010 7:51 AM
    • Marked as answer by Neil Squires Friday, July 30, 2010 8:04 PM
    Monday, July 26, 2010 11:46 PM
  • Thanks Ameen,

    I'm going to use the c# version from

    http://support.microsoft.com/kb/306023

    This information is detailed enough that I should be able to write to Excel easily.

    Neil Squires

    Friday, July 30, 2010 8:04 PM
  • > 1- WF ADO.NET Activity Pack CTP 1 : http://wf.codeplex.com/releases/view/43585

    Also a quick note that my project quit working shortly after downloading the code in the immediately above link.  I received an inner exception that stated:

    {"Could not load file or assembly 'Microsoft.Data.Activities, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.":"Microsoft.Data.Activities, PublicKeyToken=31bf3856ad364e35"}    System.Exception {System.IO.FileNotFoundException}

    To fix the project I had to remove the reference to Microsoft.Data.Activities.  Hopefully the library will work in the future, but for now its a nice prototype to play with.

    • Edited by Neil Squires Monday, August 2, 2010 5:38 PM Clearified Link
    Monday, August 2, 2010 4:44 PM