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): 24.2
First Released: 17 Sep 2016
Last Updated: 20 May 2025
Cost: Free - Appian Supported

Resources

Documentation

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

Parents

ravinderl352 over 5 years ago

Import CSV to Database V3, is this smart service functional ? I get the below error message : Unknown column 'NAME,ADDRESS' in 'field list' though my CSV file column names are exact same and aligned with DB column names as well.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Comment

ravinderl352 over 5 years ago

Import CSV to Database V3, is this smart service functional ? I get the below error message : Unknown column 'NAME,ADDRESS' in 'field list' though my CSV file column names are exact same and aligned with DB column names as well.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Children

No Data