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
  • Hey All, Is there any smart service which have "Base Template" option, like we had in "Export CDT to excel". Requirement is excel generation with two pages. First page data comes from data store entity, where as second page is static information, which is fixed data. As the "Export Data Store Entity to Excel" not having base template, how to achieve this? Thanks in advance.

Comment
  • Hey All, Is there any smart service which have "Base Template" option, like we had in "Export CDT to excel". Requirement is excel generation with two pages. First page data comes from data store entity, where as second page is static information, which is fixed data. As the "Export Data Store Entity to Excel" not having base template, how to achieve this? Thanks in advance.

Children