nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

Find more posts tagged with

Comments

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.