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,

    when using the readexcelsheet() function I noticed the documentation for the "startRow" parameter says the first row is based on the 0 index. When I pass a 0 for that parameter, the function behaves as intended and reads all rows in the excel sheet. When I pass a 1 however, it performs the same behavior.

    To exclude my headers on the first row, I have to pass the number 2 to the startRow parameter.

    A small inconvenience, but thought I'd post here. Maybe the function is confused because the majority of Appian is based on an index base of 1? We're on version 20.2 in our Appian environment.

  • Hi, please let me know the Smart Service where you have observed this behavior.

Comment Children