Excel Tools

Overview

Provides the following custom smart services and functions for handling data in Excel.

Key Features & Functionality

Smart Services included are:

  • Merge Excel Documents
  • Import CSV to Database
  • Import Excel to Database
  • 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
  • Query Appian Logs
  • Export Datasubset to Base64
  • Validate Document Headers
Anonymous
Parents
  • Hi

    Is there a way when usiing the import CSV to Database smart service and want to include a "row number"  in the target database in order to show which row of the csv the data was imported from?

    The row number would start from 1 and be incremented for each row imported. (Kind of like an fv!index in a forEach.) The row number could be included as an additional column and additional value in the smart service inputs

    Or

    Is it better to just update the target database row number field after the import is completed ?

    Regards

Comment
  • Hi

    Is there a way when usiing the import CSV to Database smart service and want to include a "row number"  in the target database in order to show which row of the csv the data was imported from?

    The row number would start from 1 and be incremented for each row imported. (Kind of like an fv!index in a forEach.) The row number could be included as an additional column and additional value in the smart service inputs

    Or

    Is it better to just update the target database row number field after the import is completed ?

    Regards

Children