Excel Tools

I am also having a similar use case. If this is addressed it would be very helpful!

Hello,

We would like to have an enhancement for readexcelsheet function.

Nature of this function:

• If the entire row is empty it will not read it/bring it to Appian
• There is no limit on how many rows to be read

What is needed?:
Can we introduce 2 new parameters?

• Allow nulls to be included
  Reason: When we do a validation check on the rows, we need to mention which row is having the validation error. Due to an empty row in middle, row calculation will be wrong as this function is not including any empty rows in the output. To avoid the row count issue, we would like to enable this feature.
• Max row parameter
  As we are allowing null values, we should add some kind of restriction on how many rows to be read. By default, we can define some max limit. 50000 Rows max?

• Fixed backwards compatibility issues with 2.2.10

Hello,

Does the current version of this plugin allow export of a datasubset or CDT to excel, and allow for download of that excel from the UI?  If so, which functions would be used?  I also noticed there are currently two versions of this plugin accessible through the cloud.

Thank you,

Walker

• Reverting to 2.2.9 due to compatibility issues with 2.2.10

These items were likely flagged before as well. We are going to address theses in the future. At this point, there is no danger these will stop working any time soon.

Yes, the compatibility states 17.1+

Based on the timestamps, the tomcat shutdown is not related to the plugin error. Also, I think this is a different plugin altogether.

Hi Dmitry,

Thank you for this plug-in, we have been using this extensively in live environments.

Recently since 2.2.9 version we started seeing high risk items (deprecated API references) in our health check report.

Even after upgrading to 2.2.10 version it is still there. Please see below:

5 plug-ins are using Appian APIs that are deprecated, private or have been removed. Plug-ins using APIs that have been removed from the latest Appian version will fail to function after an upgrade. Plug-ins using private APIs are not supported and risk breaking during an upgrade or between hotfixes. Plug-ins using deprecated APIs require refactoring to use alternative APIs as they will be removed and stop working in a future release. Contact Appian Professional Services for assistance updating a plug-in when expertise is not already available.
"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)
[deprecated] com.appiancorp.suiteapi.content.ContentService.getChildren(java.lang.Long, com.appiancorp.suiteapi.content.ContentFilter, java.lang.Integer)
[deprecated] com.appiancorp.suiteapi.process.GenericTypedVariable.<init>()
[deprecated] com.appiancorp.suiteapi.process.GenericTypedVariable.setType(java.lang.Long)
[deprecated] com.appiancorp.suiteapi.process.GenericTypedVariable.setValue(java.lang.Object)
[deprecated] com.appiancorp.suiteapi.process.analytics2.ProcessReport.copy()"

Can you please advise if there is a plan to fix this in 2.2.11?

Thanks Dmitry.  Is 2.2.10 compatible with Appian 20.1?  Also, is there a step by step user guide to help users with how to successfully import excel data?  We have the Readme that comes with excel steps but it has very little practical steps.