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.

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

Children