Excel Tools

Overview

Provides several smart services and functions for handling data in Excel and CSV formats.

Key Features & Functionality

Smart Services included are:

  • Import CSV to Database
  • Import Excel to Database
  • Merge Excel Documents
  • 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
  • Read Excel By Headers
  • Query Appian Logs
  • Export Datasubset to Base64
  • Validate Document Headers
Anonymous
Parents
  • We are currently using this plug-in within our application. As per our latest Appian Health Check Report, it is flagging that this plugin is using either removed, private or depreciated APIs and risk breaking during an upgrade or between hotfixes. Can you please let me know if the plugin will work for Appian version 21.4. Below is the text from our Health Check Report

    com.appiancorp.ps.exceltools (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.cfg.ConfigurationLoader.initializeConfigurations()
    [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()

Comment
  • We are currently using this plug-in within our application. As per our latest Appian Health Check Report, it is flagging that this plugin is using either removed, private or depreciated APIs and risk breaking during an upgrade or between hotfixes. Can you please let me know if the plugin will work for Appian version 21.4. Below is the text from our Health Check Report

    com.appiancorp.ps.exceltools (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.cfg.ConfigurationLoader.initializeConfigurations()
    [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()

Children
No Data