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
  • Hey all, we're on the latest version of the plugin (with Appian 19.1) and do not see correct results when utilizing queryAppian

  • *..when utilizing queryAppianLogs() with hasHeader=false.  For instance:

    queryAppianLogs(
      sqlStatement: "select * from login-audit",
      hasHeader: false
    )

    returns a result set with the column name the same as the column value, not "COLUMN1,COLUMN2.." as defined.  Is anyone else having this issue?

  • Hi,

    The latest version of excel tools is now live on the App market
    Release notes are as follows:
    2.2.7 Release Notes

    Functionality Updates:
    • The “Import Excel to DB” smart service no longer errors if no value is passed for the inputs “New
    • Columns” and “New Columns Values”
    • The “Import CSV to DB” smart service now returns a readable error message if there are extra blank
    • columns in the CSV file
    • The “Query Appian Logs” function no longer skips the first row of data is the input “hasHeader” is passed
    • as false
    • The “Convert Excel To CSV” smart service has been updated to utilize the inputs
    • “numberOfColumnsToReadInRow” and “rowNumberToReadFrom”
    Documentation updates:
    • Documentation has been re-added to the AppMarket listing
    • For “Import Excel to DB”, the accepted formats for dates and date times in the sheet are now clearly
    • documented
    • For “Import CSV to DB” and “Import Excel to DB”, the descriptions and example values for the smart
    • service inputs have been updated
    • For “Query Appian Logs”, the passing of inputs by order is explained and an example function call has
    • been added
  • Thanks for confirming - as far as I remember, I'd tried it both ways (i figured dictionary syntax wouldn't work but also didn't produce specific errors).  

    Also as a side note, Community doesn't seem to send any sort of notification of a reply here even though you had replied directly to me (this seems to hold true for any sort of comment activity within the App Market space).

Comment
  • Thanks for confirming - as far as I remember, I'd tried it both ways (i figured dictionary syntax wouldn't work but also didn't produce specific errors).  

    Also as a side note, Community doesn't seem to send any sort of notification of a reply here even though you had replied directly to me (this seems to hold true for any sort of comment activity within the App Market space).

Children
No Data