topic Re: service task: read data from excel via JavaDelegates in Alfresco Archive

service task: read data from excel via JavaDelegates

bonsoir — Mon, 23 Jul 2012 09:52:10 GMT

Hi everyone,Sorry to bother. As a newbie, i have a question regarding read data(specific cell from xls file) and filter the value with an exclusive gateway. after searching around the internet and forum, i still can't find a proper way to do it, no matter with groovy or javascript.Could anyone be ki

Re: service task: read data from excel via JavaDelegates

frederikherema1 — Mon, 23 Jul 2012 10:18:08 GMT

Hi,

Activiti uses client-side Javascripting, no I'm not sure if you're able to use "new ActiveXObject("Excel.Application");", as the ScriptBindings are not aware of these things. Can't you write a JavaDelegate that reads and extracts what'n needed from the XLS?

Re: service task: read data from excel via JavaDelegates

bonsoir — Mon, 23 Jul 2012 10:20:43 GMT

Hi,

Activiti uses client-side Javascripting, no I'm not sure if you're able to use "new ActiveXObject("Excel.Application");", as the ScriptBindings are not aware of these things. Can't you write a JavaDelegate that reads and extracts what'n needed from the XLS?

Would you please be kind to show me an example? Thank you for your suggestion.

Re: service task: read data from excel via JavaDelegates

frederikherema1 — Mon, 23 Jul 2012 10:23:45 GMT

Thats something Larry Page can help you with, google will get you on the way. There are a number of good ways of reading XLS in java, rather CSV's or full-blown XLSX's…

Re: service task: read data from excel via JavaDelegates

gbucsariu — Mon, 13 Aug 2012 10:27:19 GMT

Try EasyXLS.
http://www.easyxls.com
It is a java library and you may read write xls, xlsx and xlsb files.