service task: read data from excel via JavaDelegates

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.

bonsoir

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 kind to shed me some light on this one?


i've searched for javascript code as following:

function GetData(cell,row){
     var excel = new ActiveXObject("Excel.Application");
     var excel_file = excel.Workbooks.Open("C:\test.xls");
     var excel_sheet = excel.Worksheets("Sheet1");
    var data = excel_sheet.Cells(cell,row).Value;
   return data;
   }
document.write(GetData(1,1));‍‍‍‍‍‍‍‍

However this one returns "org.activiti.engine.ActivitiException: coudn't deserialize value 'sun.org.mozilla.javascript.internal.InterpretedFunction@87e0dc' in variable 'GetData'"

frederikherema1

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?