Excel Tools

Overview

Provides several smart services and functions for handling data in Excel and CSV formats.

Key Features & Functionality

Smart Services included are:

  • Import CSV to Database
  • Import Excel to Database
  • Merge Excel Documents
  • 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
  • Read Excel By Headers
  • Query Appian Logs
  • Export Datasubset to Base64
  • Validate Document Headers
  • Get Workbook and Sheet Metadata

Anonymous
Parents
  • Hi Team,

    Observed a behaviour in the “Import Excel to Database” Smart Service: when we map duplicate Excel header names to different database field names, the import fails with the error “column name cannot be null or empty.”

    In our use case, a single Excel header needs to be copied into multiple database fields, but this is currently not possible due to the error.

    Could you please verify this behavior and confirm whether it is a known issue? Also, can you confirm whether this will be addressed in an upcoming plugin release?

Comment
  • Hi Team,

    Observed a behaviour in the “Import Excel to Database” Smart Service: when we map duplicate Excel header names to different database field names, the import fails with the error “column name cannot be null or empty.”

    In our use case, a single Excel header needs to be copied into multiple database fields, but this is currently not possible due to the error.

    Could you please verify this behavior and confirm whether it is a known issue? Also, can you confirm whether this will be addressed in an upcoming plugin release?

Children
No Data