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
  • Hi Team,

    We are facing an issue while parsing a CSV file that uses the delimiter "¤Â" (two characters). In earlier versions, we were able to successfully parse this file using the "Import CSV to Database" smart service.

    However, after the latest release, the same approach is no longer working as expected. The process does not throw any error, but it also does not produce the correct results.

    It appears that in the new release, the smart service accepts only a single character as a delimiter.

    Could you please advise on how we can handle a multi-character delimiter in the current version?

Comment
  • Hi Team,

    We are facing an issue while parsing a CSV file that uses the delimiter "¤Â" (two characters). In earlier versions, we were able to successfully parse this file using the "Import CSV to Database" smart service.

    However, after the latest release, the same approach is no longer working as expected. The process does not throw any error, but it also does not produce the correct results.

    It appears that in the new release, the smart service accepts only a single character as a delimiter.

    Could you please advise on how we can handle a multi-character delimiter in the current version?

Children
No Data