Information
  • Author: Appian Corporation
  • Type: Plug-in (Function & Smart Service)
  • Support: This is an Appian supported plug-in. To the extent that this plug-in does not conform to its documentation, please submit a ticket to Appian Technical Support. Appian does not support customer-created customizations or outdated versions of the plug-in.
  • Industry: All Industries
  • Compatible Version(s): 25.2
  • First Released:
  • Last Updated:
  • Cost: Free - Appian Supported
Resources
Share
Home » AppMarket » Excel Tools

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

  • Observed that in 2.9.2, "Import Excel to Database" smart service does not support table column names with spaces and the following error is encountered in such cases: Invalid column name: <Column Name>. Only alphanumeric characters and underscores are allowed

    Hoping to understand if this is going to be fixed in an upcoming release of the plugin, as the upgrade to 2.9.2 would require substantial changes in processes relying on column names with spaces.

Comment

  • Observed that in 2.9.2, "Import Excel to Database" smart service does not support table column names with spaces and the following error is encountered in such cases: Invalid column name: <Column Name>. Only alphanumeric characters and underscores are allowed

    Hoping to understand if this is going to be fixed in an upcoming release of the plugin, as the upgrade to 2.9.2 would require substantial changes in processes relying on column names with spaces.

Children
No Data
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.