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 All,

    using 'Import CSV to Database' i need to add extra columns values into table that are not present in csv;

    I can't add this extracolumns into csv file.

    How i can import cvs fie into a table and add for each row additional information ? 

    In case i import the same csv file twice,  i need to differenziare rows of first import from rows fron second import.

    I note 'Import Excel to Database' have additional params as 'New Columns' 'New Columns values' , but i cant use it because i need to parse CSV file and not excel file

    Best regards, Saverio

  • Hi Saverio, I'm preparing to release a version 2.2.10 that has functionality that you are requesting. You will be able to specify two new parameters - list of additional columns and list of additional values to add that data to each row that is imported.

Comment Children