Excel Tools

Overview

Provides the following custom smart services and functions for handling data in Excel.

Key Features & Functionality

Smart Services included are:

  • Merge Excel Documents
  • Import CSV to Database
  • Import Excel to Database
  • Load CSV to Database
  • Convert HTML to CSV  
  • Convert Excel to CSV
  • Encrypt Excel with Password

Functions included are:

  • Read Excel File Paged
  • Read Excel Cell by Name
  • Read Excel Cell by Number
  • Query Appian Logs
  • Export Datasubset to Base64
  • Validate Document Headers
Anonymous
Parents
  • Hi All,

    We are currently on Appian 20.2 and Excel Tools (v2.2.9). I have observed below depreacted Appian APIs are being used in the plug-in (From Health Check Report).

    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()

    Could you please let me know if they have any impact on smart services or functions of the plug-in?

    Thank you.

    Satya B Andra.

  • Hi Satya, it is OK to use v2.2.9 right now as the deprecated APIs have not been removed. I'm preparing to release version 2.2.10 that will also include the fixes this situation.

Comment Children