Advance Excel command

To determine the problem, we need to look at the Bot Agent log. By default, this is located in C:\ProgramData\AutomationAnywhere\BotRunner\Logs. The filename will resemble Bot_Launcher_YOURNAME.log.

(Note that ProgramData is a hidden folder. You may have to show hidden folders or just copy/paste the path to a File Explorer window.)

Inside, look for something like these lines:

2024-Jul-19 Fri 07:41:28.536 INFO  [BotRunner-c138642e-523c-4a5e-8061-585a6cf36eaa_c4b375ddb035da01] - com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcel {deploymentId=c138642e-523c-4a5e-8061-585a6cf36eaa_c4b375ddb035da01, traceId=c4b375ddb035da01} - execute(OpenExcel.java:205) - Excel Source Option is : desktopfilepath

Hidden within that will be the reason for the issue. Feel free to add snippets of the log back here for assistance.

I have the same issue.  Provided log below.  Kindly assist me.

2024-Sep-23 Mon 18:55:56.335 INFO  [main] - com.automationanywhere.botlauncher.LauncherApp {} - main(LauncherApp.java:70) - Username of the current bot launcher session: ERS1257
2024-Sep-23 Mon 18:54:51.973 INFO  [BotRunner-cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275] - com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcel {deploymentId=cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275, traceId=25c13b3136ab7275} - execute(OpenExcel.java:205) - Excel Source Option is : desktopfilepath
2024-Sep-23 Mon 18:54:52.003 INFO  [BotRunner-cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275] - com.automationanywhere.bot.service.GlobalSessionContext {deploymentId=cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275, traceId=25c13b3136ab7275} - getResources(GlobalSessionContext.java:454) - Looked up embedded resource with key 6.20.0-89f1aacc-e679-4ca7-b0f9-5345489546af
2024-Sep-23 Mon 18:54:52.003 INFO  [BotRunner-cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275] - com.automationanywhere.bot.service.GlobalSessionContext {deploymentId=cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275, traceId=25c13b3136ab7275} - getResources(GlobalSessionContext.java:454) - Looked up embedded resource with key 6.20.0-89f1aacc-e679-4ca7-b0f9-5345489546af
2024-Sep-23 Mon 18:54:53.085 INFO  [TokenRefreshService-0] - com.automationanywhere.refresh.token.TokenRefreshServiceImpl {} - lambda$new$1(TokenRefreshServiceImpl.java:117) - User token refreshed for deployment id:cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275
2024-Sep-23 Mon 18:54:53.791 ERROR [BotRunner-cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275] - com.jniwrapper.win32.jexcel.Application {deploymentId=cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275, traceId=25c13b3136ab7275} - error(SourceFile:69) - java.lang.reflect.InvocationTargetException: null
    at com.jniwrapper.win32.MessageLoopThread$ThreadSynchronizedAction.rethrowExceptionIfSaved(MessageLoopThread.java:644) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.MessageLoopThread.doInvokeAndWait(MessageLoopThread.java:273) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.jexcel.Application.<init>(Unknown Source) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.automationanywhere.botcommand.excel.msexcel.adapter.factory.MSExcelExecutor.getApplicationInstance(MSExcelExecutor.java:154) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.automationanywhere.botcommand.excel.msexcel.adapter.factory.MSExcelExecutor.getExecutor(MSExcelExecutor.java:70) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcel.getExecutor(OpenExcel.java:267) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcel.execute(OpenExcel.java:242) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcelCommand.execute(OpenExcelCommand.java:202) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.automationanywhere.toolchain.runtime.BotCommand.execute(BotCommand.java:73) ~[bot-runtime.jar:?]
    at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
    at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
    at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
    at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?]
    at com.automationanywhere.bot.metrics.TimerInvocationHandler.invoke(TimerInvocationHandler.java:65) ~[bot-launcher.jar:?]
    at com.sun.proxy.$Proxy27.execute(Unknown Source) ~[?:?]
    at com.automationanywhere.botrunner.bot.Bot_Test_excel.executeNode1(Bot_Test_excel.java:194) ~[?:?]
    at com.automationanywhere.botrunner.bot.Bot_Test_excel.play(Bot_Test_excel.java:295) ~[?:?]
    at com.automationanywhere.botrunner.Main.play(Main.java:63) ~[?:?]
    at com.automationanywhere.botengine.service.impl.BotLauncherImpl.runBot(BotLauncherImpl.java:22) ~[bot-launcher.jar:?]
    at com.automationanywhere.botengine.service.impl.DispatcherImpl.lambda$start$9(DispatcherImpl.java:621) ~[bot-launcher.jar:?]
    at com.automationanywhere.botengine.utils.ThreadUtil.lambda$withThreadContext$0(ThreadUtil.java:20) ~[bot-launcher.jar:?]
    at java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) [?:?]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:?]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:?]
    at java.lang.Thread.run(Unknown Source) [?:?]
Caused by: com.jniwrapper.win32.com.ComException: COM object method returns error code: 0x80029C4A; Error loading type library/DLL.
    at com.jniwrapper.win32.com.ComException.checkResult(SourceFile:172) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.com.ComFunctions.coCreateInstance(SourceFile:165) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.com.impl.IUnknownImpl.<init>(SourceFile:81) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.automation.impl.IDispatchImpl.<init>(SourceFile:53) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.excel.impl._ApplicationImpl.<init>(Unknown Source) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.excel.Application.create(Unknown Source) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.jexcel.ft.run(Unknown Source) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.MessageLoopThread$ThreadSynchronizedAction.run(MessageLoopThread.java:620) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.MessageLoopThread$LoopThread.run(MessageLoopThread.java:562) ~[bot-command-msexcel-6.20.0.jar:?]

2024-Sep-23 Mon 18:54:53.799 ERROR [BotRunner-cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275] - com.jniwrapper.win32.jexcel.Application {deploymentId=cf2e599f-63e8-48cf-89d2-0b2e4dcf8e93_25c13b3136ab7275, traceId=25c13b3136ab7275} - error(SourceFile:69) - java.lang.reflect.InvocationTargetException: null
    at com.jniwrapper.win32.MessageLoopThread$ThreadSynchronizedAction.rethrowExceptionIfSaved(MessageLoopThread.java:644) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.MessageLoopThread.doInvokeAndWait(MessageLoopThread.java:273) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.jexcel.Application.<init>(Unknown Source) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.automationanywhere.botcommand.excel.msexcel.adapter.factory.MSExcelExecutor.getApplicationInstance(MSExcelExecutor.java:154) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.automationanywhere.botcommand.excel.msexcel.adapter.factory.MSExcelExecutor.getExecutor(MSExcelExecutor.java:70) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcel.getExecutor(OpenExcel.java:267) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcel.execute(OpenExcel.java:242) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.automationanywhere.botcommand.excel.msexcel.commands.OpenExcelCommand.execute(OpenExcelCommand.java:202) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.automationanywhere.toolchain.runtime.BotCommand.execute(BotCommand.java:73) ~[bot-runtime.jar:?]
    at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
    at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
    at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[?:?]
    at java.lang.reflect.Method.invoke(Unknown Source) ~[?:?]
    at com.automationanywhere.bot.metrics.TimerInvocationHandler.invoke(TimerInvocationHandler.java:65) ~[bot-launcher.jar:?]
    at com.sun.proxy.$Proxy27.execute(Unknown Source) ~[?:?]
    at com.automationanywhere.botrunner.bot.Bot_Test_excel.executeNode1(Bot_Test_excel.java:194) ~[?:?]
    at com.automationanywhere.botrunner.bot.Bot_Test_excel.play(Bot_Test_excel.java:295) ~[?:?]
    at com.automationanywhere.botrunner.Main.play(Main.java:63) ~[?:?]
    at com.automationanywhere.botengine.service.impl.BotLauncherImpl.runBot(BotLauncherImpl.java:22) ~[bot-launcher.jar:?]
    at com.automationanywhere.botengine.service.impl.DispatcherImpl.lambda$start$9(DispatcherImpl.java:621) ~[bot-launcher.jar:?]
    at com.automationanywhere.botengine.utils.ThreadUtil.lambda$withThreadContext$0(ThreadUtil.java:20) ~[bot-launcher.jar:?]
    at java.util.concurrent.CompletableFuture$AsyncSupply.run(Unknown Source) [?:?]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:?]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:?]
    at java.lang.Thread.run(Unknown Source) [?:?]
Caused by: com.jniwrapper.win32.com.ComException: COM object method returns error code: 0x80029C4A; Error loading type library/DLL.
    at com.jniwrapper.win32.com.ComException.checkResult(SourceFile:172) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.com.ComFunctions.coCreateInstance(SourceFile:165) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.com.impl.IUnknownImpl.<init>(SourceFile:81) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.automation.impl.IDispatchImpl.<init>(SourceFile:53) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.excel.impl._ApplicationImpl.<init>(Unknown Source) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.excel.Application.create(Unknown Source) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.jexcel.ft.run(Unknown Source) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.MessageLoopThread$ThreadSynchronizedAction.run(MessageLoopThread.java:620) ~[bot-command-msexcel-6.20.0.jar:?]
    at com.jniwrapper.win32.MessageLoopThread$LoopThread.run(MessageLoopThread.java:562) ~[bot-command-msexcel-6.20.0.jar:?]