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
  • There appear to be two unused arguments for the Import Excel To CSV smart service. Drilling into the plugin, it appears that ExcelHelperUtils.java::convertExcelToCSV does not use numberOfColumnsToReadInRow or rowNumberToReadFrom . It appears that implementation of either would be straightforward, given that they modify iterator start or exit conditions.  Would it be possible to get this fixed in the next version of the Excel Tools plugin? Is there a way I can contribute these changes?

Comment
  • There appear to be two unused arguments for the Import Excel To CSV smart service. Drilling into the plugin, it appears that ExcelHelperUtils.java::convertExcelToCSV does not use numberOfColumnsToReadInRow or rowNumberToReadFrom . It appears that implementation of either would be straightforward, given that they modify iterator start or exit conditions.  Would it be possible to get this fixed in the next version of the Excel Tools plugin? Is there a way I can contribute these changes?

Children