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