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
  • 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.

  • Hi Michael,

    Error was due to application server cache. Issue was resolved after restarting the application server.

    Thank you.

    Regards,

    Satya Andra.

Comment Children
No Data