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
  • We are on appian 20.2 and using readexcelsheet function and getting below error along with tomcat getting forcibly shutting down.

    The excel tool version is 2.2.10 (com.appiancorp.ps.exceltools-2.2.10)

    Any one faced this issue or some bundle missing?

    2020-11-20 10:31:52,351 [Timer-5] INFO com.appiancorp.cache.sail.StatefulSailCacheImpl - Stateful SAIL current memory cache entries=0
    2020-11-20 10:47:31,150 [ajp-nio-0.0.0.0-8009-exec-3] ERROR com.appiancorp.util.BundleUtils - Cannot retrieve the value for key "function.areusersaddedbyrule.param.users.description" from the bundle.
    2020-11-20 10:47:31,150 [ajp-nio-0.0.0.0-8009-exec-3] ERROR com.appiancorp.util.BundleUtils - Cannot retrieve the value for key "function.aregroupsaddedbyrule.param.groupIds.description" from the bundle.
    2020-11-20 10:48:19 INFO [ajp-nio-0.0.0.0-8009-exec-7] com.sun.jersey.server.impl.application.WebApplicationImpl._initiate Initiating Jersey application, version 'Jersey: 1.19 02/11/2015 03:25 AM'
    ./inner-start.sh: line 17: 18965 Killed ./catalina.sh run
    2020-11-20 10:49:27 Appian in Tomcat is forcibly killed

    Thanks

    Nirav

  • Based on the timestamps, the tomcat shutdown is not related to the plugin error. Also, I think this is a different plugin altogether.

Comment Children
No Data