Excel Tools

Hello,

We would like to have an enhancement for readexcelsheet function.

Nature of this function:

• If the entire row is empty it will not read it/bring it to Appian
• There is no limit on how many rows to be read

What is needed?:
Can we introduce 2 new parameters?

• Allow nulls to be included
  Reason: When we do a validation check on the rows, we need to mention which row is having the validation error. Due to an empty row in middle, row calculation will be wrong as this function is not including any empty rows in the output. To avoid the row count issue, we would like to enable this feature.
• Max row parameter
  As we are allowing null values, we should add some kind of restriction on how many rows to be read. By default, we can define some max limit. 50000 Rows max?

Hello,

We would like to have an enhancement for readexcelsheet function.

Nature of this function:

• If the entire row is empty it will not read it/bring it to Appian
• There is no limit on how many rows to be read

What is needed?:
Can we introduce 2 new parameters?

• Allow nulls to be included
  Reason: When we do a validation check on the rows, we need to mention which row is having the validation error. Due to an empty row in middle, row calculation will be wrong as this function is not including any empty rows in the output. To avoid the row count issue, we would like to enable this feature.
• Max row parameter
  As we are allowing null values, we should add some kind of restriction on how many rows to be read. By default, we can define some max limit. 50000 Rows max?

Hi, I have a use case that if the readexcelsheet function has a parameter for stopping at a certain row limit, it would be perfect. how did you work around this issue?

Hi, I have a use case that if the readexcelsheet function has a parameter for stopping at a certain row limit, it would be perfect. how did you work around this issue?

I am also having a similar use case. If this is addressed it would be very helpful!