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
Anonymous
Parents
  • * Version 2.2.0  - 09 Nov 18

    - Added Convert Excel to CSV Smart Service

    - Added Import Excel to DB Smart Service

    - Added LOAD CSV to DB Smart Service - fast CSV import for MySQL database that are not hosted on Appian Cloud

    - Import CSV to DB can now decrypt EncryptedText fields (for importing into external DS)

    - Deprecated CDT to/from Excel, Export Report, Export Excel Servlets (existing use will continue to work)

  • - Added LOAD CSV to DB Smart Service - fast CSV import for MySQL database that are not hosted on Appian Cloud

    Does that mean Load CSV to DB Smart Service will work only for databases that are not hosted on Appian Cloud? 

Comment Children