Excel Tools

Provides the following smart services, functions and servlets 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 CDT data to Excel
  • Export Portal Report to Excel
  • Export SQL data to CSV
  • Parse Excel to CDT
  • Merge Excel Documents
  • Export Process Metrics to Excel
  • Export Process Model Details to Excel
  • Import CSV to Database  

Functions included are:

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

Servets included are:

  • Report To Excel
  • Export Data Subset to Excel From Process