Error using Get Row(Next)

Hi,

I am trying to read row from excel sheet using Get Row(Next) functionality but getting error :

Build info: version: '2.53.0', revision: '35ae25b1534ae328c771e0856c93e187490ca824', time: '2016-03-15 10:43:46'
System info: host: 'vC01-D001-VSTS', ip: '172.16.2.90', os.name: 'Windows Server 2008 R2', os.arch: 'amd64', os.version: '6.1', java.version: '1.8.0_121'
Driver info: com.freedomoss.crowdcontrol.webharvest.selenium.wrapper.RemoteDriverWrapper
Capabilities [{sikuliThreshold=0.8, webdriver.remote.sessionid=2360fdf7-10a0-44f5-92a9-223ae7b34b35, browserName=universal, takesScreenshot=true, javascriptEnabled=true, SEARCH_ALL_WINDOWS=true, platform=WINDOWS}]
Session ID: 2360fdf7-10a0-44f5-92a9-223ae7b34b35
  org.openqa.selenium.WebDriverException: Build info: version: '2.53.0', revision: '35ae25b1534ae328c771e0856c93e187490ca824', time: '2016-03-15 10:43:46'
System info: host: 'vC01-D001-VSTS', ip: '172.16.2.90', os.name: 'Windows Server 2008 R2', os.arch: 'amd64', os.version: '6.1', java.version: '1.8.0_121'
Driver info: com.freedomoss.crowdcontrol.webharvest.selenium.wrapper.RemoteDriverWrapper
Capabilities [{sikuliThreshold=0.8, webdriver.remote.sessionid=2360fdf7-10a0-44f5-92a9-223ae7b34b35, browserName=universal, takesScreenshot=true, javascriptEnabled=true, SEARCH_ALL_WINDOWS=true, platform=WINDOWS}]
Session ID: 2360fdf7-10a0-44f5-92a9-223ae7b34b35
  	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  	at org.openqa.selenium.remote.ErrorHandler.createThrowable(ErrorHandler.java:206)
  	at org.openqa.selenium.remote.ErrorHandler.throwIfResponseFailed(ErrorHandler.java:158)
  	at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:646)
  	at org.openqa.selenium.remote.RemoteWebDriver.executeScript(RemoteWebDriver.java:545)
  	at com.workfusion.rpa.helpers.RPA.executeScript(RPA.java:745)
  	at com.workfusion.rpa.helpers.RPA.executeGroovyScript(RPA.java:844)
  	at com.workfusion.rpa.helpers.Excel.getRow(Excel.java:202)
  	at com.workfusion.studio.rpa.recorder.model.action.excel.GetRowAction.executeAction(GetRowAction.java:35)
  	at com.workfusion.studio.rpa.recorder.model.action.ActionWithDelay.execute(ActionWithDelay.java:27)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.execute(ActionFlowPlayer.java:278)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.processAction(ActionFlowPlayer.java:217)
  	at com.workfusion.studio.rpa.recorder.model.action.excel.OpenSpreadsheetAction.executeAction(OpenSpreadsheetAction.java:42)
  	at com.workfusion.studio.rpa.recorder.model.action.ActionWithDelay.execute(ActionWithDelay.java:27)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.execute(ActionFlowPlayer.java:278)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.processAction(ActionFlowPlayer.java:217)
  	at com.workfusion.studio.rpa.recorder.model.action.RepeatAction.executeAction(RepeatAction.java:36)
  	at com.workfusion.studio.rpa.recorder.model.action.ActionWithDelay.execute(ActionWithDelay.java:27)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.execute(ActionFlowPlayer.java:278)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.processAction(ActionFlowPlayer.java:217)
  	at com.workfusion.studio.rpa.recorder.model.action.BaseNestedAction.executeAction(BaseNestedAction.java:22)
  	at com.workfusion.studio.rpa.recorder.model.action.ActionWithDelay.execute(ActionWithDelay.java:27)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.execute(ActionFlowPlayer.java:278)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.processAction(ActionFlowPlayer.java:217)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.lambda$1(ActionFlowPlayer.java:104)
  	at java.util.ArrayList.forEach(ArrayList.java:1249)
  	at com.workfusion.studio.rpa.recorder.processor.ActionFlowPlayer.lambda$0(ActionFlowPlayer.java:104)
  	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  	at java.lang.Thread.run(Thread.java:745)

Please help.

Hi, @RSingh_EXL_Service2,
Could you provide to us this full log file? and log of node (RPA_FOLDER/logs/*)?
Given stack trace does not contain the necessary information.

Best Regards
Kanstantsin Sheleh

Hi ksheleg,

Please find logs in attachment.rpa-node0-2017-05-03.0.log (38.9 KB)

Regards,

Hi, @RSingh_EXL_Service2,
Yes, it is issue in RPA, we will fixing it in next release.
as workaround for your task, you can open this file in excel, change something and save it.

Best Regards
Kanstantsin Sheleh

1 Like

Can you provide an estimate of when the release containing this functionality will be available? Iterating through rows in Excel is critical functionality for the processes we want to automate.

Thanks!

Hi,
I am trying to extract the second row of my excel sheet. I have used Get Row(2) as index number. But I am getting an error saying that “ERROR EXECUTING GETROWACTION”.

I have used Get Row(1) which is working fine. other than this, any index number I give it is showing an error.

Could you please help me out.

@ravikumar177 can you share the screenshot of this action in the actions flow?

Hi,
I am trying to read my excel data till Z column. It’s showing an error "ERROR EXECUTING EXCELGETRANGE ACTION "

Error executing ExcelGetRangeAction
com.workfusion.studio.rpa.recorder.playback.PlaybackMultiException: Error executing TemplateAction[templateName=ExcelGetRangeAction.ftl,id=2,name=Optional[ExcelGetRangeAction],parent=1,arguments=ActionArguments[targetVariable=[table],delay=[0],coordinateFrom=[A1],coordinateTo=[Z4],xsi:type=[recorder:ExcelGetRangeAction, recorder:ExcelGetRangeAction],pollingInterval=[300],active=[true],OpenSpreadsheetAction_filePath=[C:\Users\mulukalla.kumar\Desktop\CBRS_Allocation.xlsx],actionDetails=[(A1:Z4 to ‘table’)],awaitTimeout=[5000]]]
at com.workfusion.studio.rpa.recorder.playback.action.OpenSpreadsheetAction.execute(OpenSpreadsheetAction.java:52)
at com.workfusion.studio.rpa.recorder.playback.action.OpenSpreadsheetAction.execute(OpenSpreadsheetAction.java:16)
at com.workfusion.studio.rpa.recorder.playback.player.ActionPlayer.next(ActionPlayer.java:64)
at com.workfusion.studio.rpa.recorder.player.PlaybackLogic.playNextAction(PlaybackLogic.java:152)
at com.workfusion.studio.rpa.recorder.player.PlaybackLogic.run(PlaybackLogic.java:112)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.openqa.selenium.WebDriverException: java.lang.ClassNotFoundException: org.apache.poi.ss.formula.eval.NotImplementedFunctionException cannot be found by com.workfusion.studio.dependencies.rpa-api_9.2.0.4
Build info: version: ‘9.2.0.4’, revision: ‘1a10eeeced’, time: ‘2018-11-29T10:44:59.891Z’
System info: host: ‘WKSBAN19JAGG003’, ip: ‘172.17.137.32’, os.name: ‘Windows 7’, os.arch: ‘amd64’, os.version: ‘6.1’, java.version: ‘1.8.0_121’
Driver info: driver.version: RemoteWebDriver
at org.openqa.selenium.remote.internal.CustomWrapper.isCustomWrapperElement(CustomWrapper.java:44)
at org.openqa.selenium.remote.JsonToBeanConverter.convert(JsonToBeanConverter.java:218)
at org.openqa.selenium.remote.JsonToBeanConverter.convert(JsonToBeanConverter.java:48)
at org.openqa.selenium.remote.JsonToBeanConverter.convert(JsonToBeanConverter.java:149)
at org.openqa.selenium.remote.JsonToBeanConverter.convert(JsonToBeanConverter.java:48)
at org.openqa.selenium.remote.http.AbstractHttpResponseCodec.decode(AbstractHttpResponseCodec.java:82)
at org.openqa.selenium.remote.http.AbstractHttpResponseCodec.decode(AbstractHttpResponseCodec.java:45)
at org.openqa.selenium.remote.HttpCommandExecutor.execute(HttpCommandExecutor.java:164)
at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:741)
at org.openqa.selenium.remote.RemoteWebDriver.executeScript(RemoteWebDriver.java:677)
at com.workfusion.rpa.helpers.Excel.getRange(Excel.java:703)
at com.workfusion.rpa.helpers.Excel$getRange$5.callStatic(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallStatic(CallSiteArray.java:55)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callStatic(AbstractCallSite.java:197)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callStatic(AbstractCallSite.java:225)
at Script3.run(Script3.groovy:8)
at com.workfusion.studio.rpa.recorder.playback.shell.GroovyShellWrapper.executeScript(GroovyShellWrapper.java:48)
at com.workfusion.studio.rpa.recorder.playback.player.PlaybackContext.executeScript(PlaybackContext.java:65)
at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.executeBehavior(TemplateAction.java:33)
at com.workfusion.studio.rpa.recorder.playback.flow.StandardControlFlow.execute(StandardControlFlow.java:46)
at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.execute(TemplateAction.java:28)
at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.execute(TemplateAction.java:15)
at com.workfusion.studio.rpa.recorder.playback.player.ActionPlayer.next(ActionPlayer.java:64)
at com.workfusion.studio.rpa.recorder.player.PlaybackLogic.playNextAction(PlaybackLogic.java:152)
at com.workfusion.studio.rpa.recorder.player.PlaybackLogic.run(PlaybackLogic.java:112)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ClassNotFoundException: org.apache.poi.ss.formula.eval.NotImplementedFunctionException cannot be found by com.workfusion.studio.dependencies.rpa-api_9.2.0.4
at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:508)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:419)
at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:411)
at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:150)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at org.openqa.selenium.remote.internal.CustomWrapper.isCustomWrapperElement(CustomWrapper.java:42)
at org.openqa.selenium.remote.JsonToBeanConverter.convert(JsonToBeanConverter.java:218)
at org.openqa.selenium.remote.JsonToBeanConverter.convert(JsonToBeanConverter.java:48)
at org.openqa.selenium.remote.JsonToBeanConverter.convert(JsonToBeanConverter.java:149)
at org.openqa.selenium.remote.JsonToBeanConverter.convert(JsonToBeanConverter.java:48)
at org.openqa.selenium.remote.http.AbstractHttpResponseCodec.decode(AbstractHttpResponseCodec.java:82)
at org.openqa.selenium.remote.http.AbstractHttpResponseCodec.decode(AbstractHttpResponseCodec.java:45)
at org.openqa.selenium.remote.HttpCommandExecutor.execute(HttpCommandExecutor.java:164)
at org.openqa.selenium.remote.RemoteWebDriver.execute(RemoteWebDriver.java:741)
at org.openqa.selenium.remote.RemoteWebDriver.executeScript(RemoteWebDriver.java:677)
at com.workfusion.rpa.helpers.Excel.getRange(Excel.java:703)
at com.workfusion.rpa.helpers.Excel$getRange$5.callStatic(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallStatic(CallSiteArray.java:55)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callStatic(AbstractCallSite.java:197)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callStatic(AbstractCallSite.java:225)
at Script3.run(Script3.groovy:8)
at com.workfusion.studio.rpa.recorder.playback.shell.GroovyShellWrapper.executeScript(GroovyShellWrapper.java:48)
at com.workfusion.studio.rpa.recorder.playback.player.PlaybackContext.executeScript(PlaybackContext.java:65)
at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.executeBehavior(TemplateAction.java:33)
at com.workfusion.studio.rpa.recorder.playback.flow.StandardControlFlow.execute(StandardControlFlow.java:46)
at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.execute(TemplateAction.java:28)
at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.execute(TemplateAction.java:15)
at com.workfusion.studio.rpa.recorder.playback.player.ActionPlayer.next(ActionPlayer.java:64)
at com.workfusion.studio.rpa.recorder.player.PlaybackLogic.playNextAction(PlaybackLogic.java:152)
at com.workfusion.studio.rpa.recorder.player.PlaybackLogic.run(PlaybackLogic.java:112)
at java.lang.Thread.run(Thread.java:745)

Thank you @ravikumar177 can you also send over the Excel file you use in the script?
We’ll test the script with it.

@ashapkina As it is related to privacy i cant send that.Do I have any other way to send .

You can send it to me in a private message here on the forum so it will not be posted in a public topic.

@ashapkina I have found the solution. It occurred because it is having some formulas in between the excel.I have removed those formulas and had given values inside the cell. It’s working fine now.

Thank you.

1 Like

Glad it got solved :+1:

1 Like