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

jinsongc over 4 years ago

Hi, I am using date format like "2020-08-12" or "2020-08-12 03:43:13" in "Import CSV to DB", but get the error message "Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'HH:mm:Ss'",

Can anybody help me out?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Bhargav Solanki over 4 years ago in reply to jinsongc

1) Can you elaborate what action are you trying to take for which function?
2) Can you please share sample rows of of the type of data you are taking the action with?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Comment

Bhargav Solanki over 4 years ago in reply to jinsongc

1) Can you elaborate what action are you trying to take for which function?
2) Can you please share sample rows of of the type of data you are taking the action with?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Children

No Data