topic Re: Excel Report Generation in Alfresco Archive

Excel Report Generation

vinodkumarnelib — Wed, 22 Jan 2014 13:02:06 GMT

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!!

Re: Excel Report Generation

scouil — Mon, 27 Jan 2014 17:37:39 GMT

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.

Re: Excel Report Generation

vinodkumarnelib — Tue, 28 Jan 2014 14:39:08 GMT

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.

Re: Excel Report Generation

scouil — Tue, 28 Jan 2014 14:58:18 GMT

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.