Plug-in (Function & Smart Service)Free
Excel Tools
by Appian Corporation
Description
Provides several smart services and functions for handling data in Excel and CSV formats.
Features
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
- Get Workbook and Sheet Metadata
Release notes
BIGINT data types now use Java Long instead of Integer to support larger numbers for CSV import