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
  • Hello,

    Does 'Export SQL to Flat File' smart service continue to work fine with the 2.2.19 version of this plug-in?
    Since I have a requirement to export multiple tables using SQL to CSVs.

    Albeit  'Export SQL to Flat File' is deprecated, would there be any issues using it?
    Also, is there any replacement for  'Export SQL to Flat File' ?

    Please help, thank you!

Comment
  • Hello,

    Does 'Export SQL to Flat File' smart service continue to work fine with the 2.2.19 version of this plug-in?
    Since I have a requirement to export multiple tables using SQL to CSVs.

    Albeit  'Export SQL to Flat File' is deprecated, would there be any issues using it?
    Also, is there any replacement for  'Export SQL to Flat File' ?

    Please help, thank you!

Children
No Data