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,

    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?
  • I am also having a similar use case. If this is addressed it would be very helpful!

Comment Children