AnsweredAssumed Answered

service task: read data from excel via JavaDelegates

Question asked by bonsoir on Jul 23, 2012
Latest reply on Aug 13, 2012 by gbucsariu
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'"

Outcomes