Excel Tools

Provides the following custom smart services and functions for handling data in Excel.  An example usage application for Export SQL to Flat File is also included.

Smart Services included are:

  • Export SQL data to Excel
  • Export SQL data to CSV
  • Merge Excel Documents
  • Import CSV to Database
  • Import Excel to Database
  • Load CSV to Database
  • Convert HTML to CSV  
  • Convert Excel to CSV

Functions included are:

  • Read Excel File
  • Read Excel Cell by Name
  • Read Excel Cell by Number
  • Query Appian Logs
  • Export Datasubset to Base64

 

NOTE: When deploying this plug-in, please delete all old versions of the ExportableDataSubset CDT AND update your model to point to the new version {urn:com:appian:ps:excel:types}ExportableDataSubset

Anonymous