Export to Excel

[Migration User]

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

Thanks

[africo]

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.

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

Attachment(s)

SaveToExcelDemo.package   11 KB 1 version

[africo]

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.

[Migration User]

Thanks Africo

[Migration User]

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

[Migration User]

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)

[Migration User]

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.