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

vinodn_persistent over 1 year ago

Does the Import CSV to Database smart service will ignore the empty column name present in the csv file ??

Example: columns specified :A,B,C,D,E

columns present in file: A,B, ,C, ,D,E
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Comment

vinodn_persistent over 1 year ago

Does the Import CSV to Database smart service will ignore the empty column name present in the csv file ??

Example: columns specified :A,B,C,D,E

columns present in file: A,B, ,C, ,D,E
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Children

No Data