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

Nandhavi Nandakumar 2 months ago

Im using the Import CSV to Database smart service, on passing the csv file which has empty values in few cells Im getting the error 'Error executing SQL'. Does the smart service not support csv files with null values for a few cells?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Comment

Nandhavi Nandakumar 2 months ago

Im using the Import CSV to Database smart service, on passing the csv file which has empty values in few cells Im getting the error 'Error executing SQL'. Does the smart service not support csv files with null values for a few cells?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Children

No Data