Information
  • Author: Appian Corporation
  • Type: Plug-in (Function & Smart Service)
  • Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
  • Industry: All Industries
  • Compatible Version(s): 23.2+
  • First Released:
  • Last Updated:
  • Cost: Free
Resources
Share
Home » AppMarket » Excel Tools

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 , 

    I was able to use the queryappianlogs function with the older version of Excel tools. But, when i updated this latest Excel tools plugin, i am getting error message and the data is not shown. Can you please fix this in this in the latest version?

    Please find below the error log in the application server log.

    ERROR: Bundle com.appiancorp.ps.exceltools [61] Unable to get module class path. (java.lang.NullPointerException)
java.lang.NullPointerException
	at org.apache.felix.framework.BundleRevisionImpl.calculateContentPath(BundleRevisionImpl.java:432)
	at org.apache.felix.framework.BundleRevisionImpl.initializeContentPath(BundleRevisionImpl.java:365)
	at org.apache.felix.framework.BundleRevisionImpl.getContentPath(BundleRevisionImpl.java:351)
	at org.apache.felix.framework.BundleRevisionImpl.getResourceLocal(BundleRevisionImpl.java:494)
	at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1617)
	at org.apache.felix.framework.BundleWiringImpl.getResourceByDelegation(BundleWiringImpl.java:1460)
	at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.getResource(BundleWiringImpl.java:2597)
	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
ERROR: Bundle com.appiancorp.ps.exceltools [61] Unable to get module class path. (java.lang.NullPointerException)
java.lang.NullPointerException
	at org.apache.felix.framework.BundleRevisionImpl.calculateContentPath(BundleRevisionImpl.java:432)
	at org.apache.felix.framework.BundleRevisionImpl.initializeContentPath(BundleRevisionImpl.java:365)
	at org.apache.felix.framework.BundleRevisionImpl.getContentPath(BundleRevisionImpl.java:351)
	at org.apache.felix.framework.BundleRevisionImpl.getResourceLocal(BundleRevisionImpl.java:494)
	at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1617)
	at org.apache.felix.framework.BundleWiringImpl.getResourceByDelegation(BundleWiringImpl.java:1460)
	at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.getResource(BundleWiringImpl.java:2597)
	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
Comment

  • Hi , 

    I was able to use the queryappianlogs function with the older version of Excel tools. But, when i updated this latest Excel tools plugin, i am getting error message and the data is not shown. Can you please fix this in this in the latest version?

    Please find below the error log in the application server log.

    ERROR: Bundle com.appiancorp.ps.exceltools [61] Unable to get module class path. (java.lang.NullPointerException)
java.lang.NullPointerException
	at org.apache.felix.framework.BundleRevisionImpl.calculateContentPath(BundleRevisionImpl.java:432)
	at org.apache.felix.framework.BundleRevisionImpl.initializeContentPath(BundleRevisionImpl.java:365)
	at org.apache.felix.framework.BundleRevisionImpl.getContentPath(BundleRevisionImpl.java:351)
	at org.apache.felix.framework.BundleRevisionImpl.getResourceLocal(BundleRevisionImpl.java:494)
	at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1617)
	at org.apache.felix.framework.BundleWiringImpl.getResourceByDelegation(BundleWiringImpl.java:1460)
	at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.getResource(BundleWiringImpl.java:2597)
	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
ERROR: Bundle com.appiancorp.ps.exceltools [61] Unable to get module class path. (java.lang.NullPointerException)
java.lang.NullPointerException
	at org.apache.felix.framework.BundleRevisionImpl.calculateContentPath(BundleRevisionImpl.java:432)
	at org.apache.felix.framework.BundleRevisionImpl.initializeContentPath(BundleRevisionImpl.java:365)
	at org.apache.felix.framework.BundleRevisionImpl.getContentPath(BundleRevisionImpl.java:351)
	at org.apache.felix.framework.BundleRevisionImpl.getResourceLocal(BundleRevisionImpl.java:494)
	at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1617)
	at org.apache.felix.framework.BundleWiringImpl.getResourceByDelegation(BundleWiringImpl.java:1460)
	at org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.getResource(BundleWiringImpl.java:2597)
	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
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.