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
  • Same with previous posters, we were looking at migrating a lot of our functionality away from the older style deprecated plugs ins that the HEalthcheck has highlighted to use the Excel Tools functionality but the loss of the Export CDT to Excel smart service now prohibits that activity (if we wanted to use the up to date version of the plug in - bit of a catch 22 situation).  

    For the CSV to database V3 smart-service, we have also found that the insert scripts from the CSV file for databases that use Schemas are generating incorrectly.

    The insert scripts are generated like the below,

    insert into [schema.tableName] (column1,colum2) values (value1,value2)  -- WRONG

    But it should be generated as,

    insert into [schema].[tableName] (column1,colum2) values (value1,value2) – CORRECT

    Any chance this could be addressed in a future update?

Comment
  • Same with previous posters, we were looking at migrating a lot of our functionality away from the older style deprecated plugs ins that the HEalthcheck has highlighted to use the Excel Tools functionality but the loss of the Export CDT to Excel smart service now prohibits that activity (if we wanted to use the up to date version of the plug in - bit of a catch 22 situation).  

    For the CSV to database V3 smart-service, we have also found that the insert scripts from the CSV file for databases that use Schemas are generating incorrectly.

    The insert scripts are generated like the below,

    insert into [schema.tableName] (column1,colum2) values (value1,value2)  -- WRONG

    But it should be generated as,

    insert into [schema].[tableName] (column1,colum2) values (value1,value2) – CORRECT

    Any chance this could be addressed in a future update?

Children
No Data