Excel Tools

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.

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, 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.

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