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,

    We have recently upgraded to 18.4, and are looking to implement exportable excel reports using the Getdatasubsetdownloadlinkfromprocess function like we have used in previous versions. In the Modules listed on the plugin, it says that the function still exists and is not deprecated, but when I go to search and implement, this function does not appear. Has anyone else had a similar issue? Also, may we have some documentation behind this plugin like previous versions?

    Best Regards

Comment
  • Hello,

    We have recently upgraded to 18.4, and are looking to implement exportable excel reports using the Getdatasubsetdownloadlinkfromprocess function like we have used in previous versions. In the Modules listed on the plugin, it says that the function still exists and is not deprecated, but when I go to search and implement, this function does not appear. Has anyone else had a similar issue? Also, may we have some documentation behind this plugin like previous versions?

    Best Regards

Children