Excel Report Generation

[vinodkumarnelib]

Hi Support,

I have a requirement in my workflow where I have generate an excel report consisting of workflow properties as column headers in excel and values as the properties value's of all the completed workflow tasks.Can anyone please help me in this context.

Thank you in advance!!

[scouil]

Hi,

To trigger it:
Alfresco support java jobs triggered by crons. I believe that's what you need.

To create the file:
The easy way out would be to convince your product owner to use a csv for this. Which is lighter and open.
This way, you can just write your text directly to a newly created file.
Otherwise, you'll have to include the excel-writer library of your choice (e.g. apache poi) and use this.

[vinodkumarnelib]

Hi Scouil,

Thank you for the reply, m client requires to be in excel file.Please can you elucidate the steps for it.
It will help me a lot.

Thanks in advance.

[scouil]

Hi,

To create the scheduled action, please refer to
http://wiki.alfresco.com/wiki/Scheduled_Actions

It will trigger your custom java code.
You'll retrieve a writer to your node with something similar to this:
http://wiki.alfresco.com/wiki/NodeRef_cookbook#Writing_data_to_a_node.27s_content

Then it all depends on the library you choose, and what kind of writer it's compatible with.
But then it's plain java and nothing alfresco-specific anymore.