Excel Tools

Overview

Provides several smart services and functions for handling data in Excel and CSV formats.

Key Features & Functionality

Smart Services included are:

  • Import CSV to Database
  • Import Excel to Database
  • Merge Excel Documents
  • 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
  • Read Excel By Headers
  • Query Appian Logs
  • Export Datasubset to Base64
  • Validate Document Headers
  • Get Workbook and Sheet Metadata

Anonymous
Parents
  • Version 2.10.0 introduces a breaking change which impacts processes using the smart service "Import CSV to Database" where the data source is external. CSV Imports fail with the error: "Error Executing SQL", which works fine in version 2.9.0. Requesting clarification if a resolution is known for this issue or if this would be fixed in an upcoming release.

Comment
  • Version 2.10.0 introduces a breaking change which impacts processes using the smart service "Import CSV to Database" where the data source is external. CSV Imports fail with the error: "Error Executing SQL", which works fine in version 2.9.0. Requesting clarification if a resolution is known for this issue or if this would be fixed in an upcoming release.

Children
No Data