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 long time, hope you are well.  Ok, I'm trying to utilise the Query Appian Logs function specifically for the Audit Log (our customer has compliance requirement for this), however from the expression I'm getting NULL.  Likely something I'm missing and hope you can spot the obvious.  Expression is as per below

    queryAppianLogs(
    sqlStatement: "select * from login-audit",
    subFolder: null,
    columnTypes: {
    "String",
    "String",
    "String",
    "String",
    "String",
    "String"
    },
    timestampFormat: "d MMM yyyy HH:mm:ss z",
    hasHeader: false
    )  

  • OK resolved. for benefit of others I just needed to add an additional column (same type eg. String), knew it was something simple!

Comment Children
No Data