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
  • @Ben ,I am still facing issues in Export to SQL smart service while exporting the data in multiple sheets.

    There are three tabs in my excel. Using three nodes to export each sheet data.in first node , the data is exported successfully and the generated document is passed as input to the second node to overwrite the data in sheet 2 and the output of second node is passed as input to 3rd node. The final document has data in third sheet whereas the data in sheet 1 and sheet 2 were lost.

    Can you please advise on this?

    Thanks in advance!

Comment
  • @Ben ,I am still facing issues in Export to SQL smart service while exporting the data in multiple sheets.

    There are three tabs in my excel. Using three nodes to export each sheet data.in first node , the data is exported successfully and the generated document is passed as input to the second node to overwrite the data in sheet 2 and the output of second node is passed as input to 3rd node. The final document has data in third sheet whereas the data in sheet 1 and sheet 2 were lost.

    Can you please advise on this?

    Thanks in advance!

Children
No Data