Information

Author: Appian Corporation
Type: Plug-in (Function & Smart Service)
Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
Industry: All Industries
Compatible Version(s): 23.2+
First Released: 17 Sep 2016
Last Updated: 26 Apr 2024
Cost: Free

Resources

Readme

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

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