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
Anonymous
Parents
  • We are using MS SQL Server 2017, we've had no success with either Import Excel to Database or Import CSV to Database but we have had a true error message output when we've tried Load CSV to Database saying it's only compatible "This method only works with MySQL databases". Could you give us some feedback on the compatibility of this plugin?

Comment
  • We are using MS SQL Server 2017, we've had no success with either Import Excel to Database or Import CSV to Database but we have had a true error message output when we've tried Load CSV to Database saying it's only compatible "This method only works with MySQL databases". Could you give us some feedback on the compatibility of this plugin?

Children
No Data