Excel Tools

We are on ver 2.2.10.  Appian health check shows High risk message regarding this plugin.  Please provide updated plugin.

Excel Tools (com.appiancorp.ps.exceltools) references private and deprecated Appian APIs
[private] com.appiancorp.common.xml.XmlBeanSerializer.populateObject(java.lang.Object, org.w3c.dom.Node)
[private] com.appiancorp.services.ASLIdentity.getIdentity()
[private] com.appiancorp.type.TypeRef.getId()
[deprecated] com.appiancorp.services.ServiceContext.getIdentity()
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getContentService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getGroupService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getProcessAnalyticsService2(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getProcessDesignService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getProcessExecutionService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getTypeService(com.appiancorp.services.ServiceContext)
[deprecated] com.appiancorp.suiteapi.common.ServiceLocator.getUserService(com.appiancorp.services.ServiceContext)

We are on appian 20.2 and using readexcelsheet function and getting below error along with tomcat getting forcibly shutting down.

The excel tool version is 2.2.10 (com.appiancorp.ps.exceltools-2.2.10)

Any one faced this issue or some bundle missing?

2020-11-20 10:31:52,351 [Timer-5] INFO com.appiancorp.cache.sail.StatefulSailCacheImpl - Stateful SAIL current memory cache entries=0
2020-11-20 10:47:31,150 [ajp-nio-0.0.0.0-8009-exec-3] ERROR com.appiancorp.util.BundleUtils - Cannot retrieve the value for key "function.areusersaddedbyrule.param.users.description" from the bundle.
2020-11-20 10:47:31,150 [ajp-nio-0.0.0.0-8009-exec-3] ERROR com.appiancorp.util.BundleUtils - Cannot retrieve the value for key "function.aregroupsaddedbyrule.param.groupIds.description" from the bundle.
2020-11-20 10:48:19 INFO [ajp-nio-0.0.0.0-8009-exec-7] com.sun.jersey.server.impl.application.WebApplicationImpl._initiate Initiating Jersey application, version 'Jersey: 1.19 02/11/2015 03:25 AM'
./inner-start.sh: line 17: 18965 Killed ./catalina.sh run
2020-11-20 10:49:27 Appian in Tomcat is forcibly killed

Thanks

Nirav

Does anyone know what the most up to date version of excel tools is?  Or is there only one version of excel tools?  I see above that it is compatible with Appian version 17.1 and above.  

Does "Import Excel to Database" support .xls ?

We are facing issue when uploading XLS file making the node to fail. There is no issue with uploading XLSX files though.

ERROR:

"The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF instead of XSSF)"

Hi musthafaj0003 - have you tried the SQL to Excel plug-in?

I am having issue with this function excelreadcellsbynumber() Attaching Sample code here: 

excelreadcellsbynumber(
excelDoc: todocument(618022),
sheetNumbers:{1},
columnNumbers:{1,2},
rowNumbers:{1,2}
)

And it is giving me "Expression evaluation error at function 'excelreadcellsbynumber':" Has anyone faced this problem, Please let me know.

Thank you.

Hi,

Is "Export SQL data to Excel" Smart service deprecated? 

Please let me if any alternative available for this smart service.