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

Varun Jain 5 months ago

We are using the Excel tools plugin to read data from an uploaded excel file into a database table. The plugin is reading the display value of a cell instead of the actual value. For ex. Display value is 0 for actual value 0.003.

Current readexcelsheetpaging function will read the display value only. Can we request a new function (eg. readexcelsheetpagingwithRealValue) to get real value ?
- Cancel
- Up +1 Down
- Reply
- More
- Cancel

Comment

Varun Jain 5 months ago

We are using the Excel tools plugin to read data from an uploaded excel file into a database table. The plugin is reading the display value of a cell instead of the actual value. For ex. Display value is 0 for actual value 0.003.

Current readexcelsheetpaging function will read the display value only. Can we request a new function (eg. readexcelsheetpagingwithRealValue) to get real value ?
- Cancel
- Up +1 Down
- Reply
- More
- Cancel

Children

No Data