Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
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.
Hi, I will update documentation for this method. I verified that it's working correctly as Excel documents start their rows with 1.
I was using the function readexcelsheet() in an expression object.