Workflow Soluiton

Expand all | Collapse all

Export to Excel

Jump to Best Answer
  • 1.  Export to Excel

    Posted 01-27-2015 07:12 PM

    Anyone know how I can export data to an excel document and need to save it to a specified folder.

    Thanks



  • 2.  RE: Export to Excel
    Best Answer

    Posted 01-27-2015 07:41 PM
      |   view attached

    Start by loading in the Microsoft Office library, and using the "Excel Write Component" found in the "Native" directory.

    Then use a "Write File" component to write the data to a file at a path you specify.  Here are some screenshots to show how it's set up.

    2015-01-27_17-23-09.png

    2015-01-27_17-22-38.png

    2015-01-27_17-18-04.png

    2015-01-27_17-23-41.png

    I've attached a demo project in case my explanation is insufficient.

    Attachment(s)

    package
    SaveToExcelDemo.package   11K 1 version


  • 3.  RE: Export to Excel

    Posted 01-27-2015 11:00 PM

    I did a more thorough writeup regarding this topic on my blog here as well:

    http://atmaworkflow.com/2015/01/27/write-data-to-an-excel-filedirect/

    There is an expanded demo project there as well.



  • 4.  RE: Export to Excel

    Posted 01-28-2015 11:05 AM

    Thanks Africo



  • 5.  RE: Export to Excel

    Posted 02-19-2015 05:19 AM

    I don't see Microsoft Office library. Could you please help



  • 6.  RE: Export to Excel

    Posted 02-19-2015 07:35 AM

    You have to manually add that library to your solution. Right click at the top of the tree view and select Project Properties, go to the Libraries tab, and add the LogicBase.Components.Office lib (I think that's what its called)



  • 7.  RE: Export to Excel

    Posted 02-20-2015 01:11 AM

    Thanks reecardo, I found it and it worked. Can I write in multiple sheets aswell? If that works it will be great for my project.