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
  • Hello,

    I have updated Excel Tools plug-in to latest version (v2.2.6) and noticed below error in stdout logs:

    2019-09-23 09:38:22,104 [Timer-5] INFO com.appiancorp.cache.sail.StatefulSailCacheImpl - Stateful SAIL current memory cache entries=8 size=201744 bytes
    ERROR: Bundle com.appiancorp.ps.exceltools [49] Unable to get module class path. (java.lang.NullPointerException)
    java.lang.NullPointerException
    at org.apache.felix.framework.BundleRevisionImpl.calculateContentPath(BundleRevisionImpl.java:431)
    at org.apache.felix.framework.BundleRevisionImpl.initializeContentPath(BundleRevisionImpl.java:368)
    at org.apache.felix.framework.BundleRevisionImpl.getContentPath(BundleRevisionImpl.java:354)
    at org.apache.felix.framework.BundleRevisionImpl.getResourceLocal(BundleRevisionImpl.java:493)
    at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1511)
    at org.apache.felix.framework.BundleWiringImpl.getResourceByDelegation(BundleWiringImpl.java:1420)
    at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.getResource(BundleWiringImpl.java:2430)
    at com.ibm.db2.jcc.am.wd.run(wd.java:49)
    at java.security.AccessController.doPrivileged(Native Method)
    at com.ibm.db2.jcc.am.GlobalProperties.a(GlobalProperties.java:146)
    at com.ibm.db2.jcc.am.GlobalProperties.d(GlobalProperties.java:100)
    at com.ibm.db2.jcc.am.dr.run(dr.java:124)
    at java.util.TimerThread.mainLoop(Timer.java:555)
    at java.util.TimerThread.run(Timer.java:505)
    java.lang.NullPointerException

    We are running on Appian v19.3. Can you please help me understand and find a fix for the above error?

    Thanks in advance.

  • Are you still having this error?This is an odd error, can you make sure that only one version of excel tools is active on your environment? If on cloud open up a support case ask the support team to manually redeploy the plugin.

Comment Children