topic Solution to fulfill OA functions in Alfresco in Alfresco Archive

Solution to fulfill OA functions in Alfresco

andy2_0 — Fri, 27 Dec 2013 16:34:22 GMT

I have a couple of Excel files stored in Alfresco Doc library, they are created based on several templates. I want to extract the values from the specific cells of those files for further process. I drafted the solution as below1) create the Excel templates, set a specific cell to a JSON string, i

Re: Solution to fulfill OA functions in Alfresco

jpotts — Wed, 15 Jan 2014 22:55:35 GMT

This isn't possible without some minor coding work. I think a custom action that knows how to extract an arbitrary cell value out of a spreadsheet and store it in a property on the node would be a useful action.

I think this would take someone already familiar with creating custom actions less than half a day (easily) to code.

Once created, you could set up rules on your folder to invoke the action and you could reuse it on any folder in the repository without getting a developer involved.

Jeff

Re: Solution to fulfill OA functions in Alfresco

andy2_0 — Wed, 22 Jan 2014 15:47:09 GMT

Jeff, thanks for your response!