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

komalc3 over 4 years ago

Hi

I am using the plugin "Import CSV to Database4". I am getting the error: "java.lang.ArrayIndexOutOfBoundsException: 12"

Any idea on why it is so? The size of my csv is 20381 KB.

Thanx in advance!!
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Comment

komalc3 over 4 years ago

Hi

I am using the plugin "Import CSV to Database4". I am getting the error: "java.lang.ArrayIndexOutOfBoundsException: 12"

Any idea on why it is so? The size of my csv is 20381 KB.

Thanx in advance!!
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Children

komalc3 over 4 years ago in reply to Bhargav Solanki

Hi Bhargav Solanki

My CSV has a column of varchar2 type (in Databse) in which data is separated by pipe |, this data is not getting imported.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Bhargav Solanki over 4 years ago in reply to komalc3

Can you please provide a detailed description of the steps you are taking including the number of columns in the CSV and where do you see the error?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel