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
  • Did you find any way to execute this requirement?

  • Has anyone used the queryAppianLogs function to select a count from the files with a group by and a where condition ?

    No matter what I try I'm getting a null value return ... using the query without the group by returns data, using the count without the where also returns data but when combining the two together to get a simple count from the removed processes log where the timestamp is today returns nothing.

    Is this is a feature of the plug in ? We're using 2.5.0 

    Any hints / tips would be appreciated. 

    Thanks 

    Paul

  • Hi,

    We have a Appian 24.1, is this plugin compatible for this version?

    We are facing issues while performing export of records. It is not downloading the file even after clicking the Export option. Also, do you any recommendations on how many records we need to download at a time

  • Team,

    I am using the smart service - Import Excel to Database - in one of my development projects to read an excel files and write the values as-is to the database tables. The excel file is huge and is having 2 sheets that contains data to be written to 2 different table. As per the implementation, I have created 2 different tables for storing this information and the excel column names and table column names were specifically mentioned along with the mandatory information required for the smart service to work.

    Data is getting written into the database table, but not fully. The first sheet has 83621 rows (out of 83625), and the second sheet has 137738 rows (out of 137742) of data that needs to be written to the database table. The batch size of the smart service is configured as 1000. After successful execution of the process model, I could see that the 82994 rows were written from the first sheet and 136994 rows were written from the second sheet of the excel file.

    I believe it is something related to the batch size, as I modified the batch size from 1000 to 500 and the number of rows processes got changed to 83494 and 137494 respectively, which is 500 rows more than what was the previous outcome. Further, I reduced the batch size to 100 and the number of rows processes got changed to 83594 and 137694 respectively, which is again 100 more than was the previous outcome.

    Because of this issue, we are not able to extract the data completely from the excel files. Kindly help me in resolving this issue.

    Regards,
    Deepak

  • Is there a way in this plugin by which we are able to get the sheet name (tabs name) in the excel spreadsheet from this smart service ?

  • v2.6.3 Release Notes
    • Added support for PostreSQL.
  • Hi Team,

    I am using plugin html to csv. In converted csv file one of the column which has date value shows as "####".

    Could you please advise if we can avoid this and values can be visible to user. ?

  • Hi there, is there any known problem about concurrency? We have checked that when we execute 2 processes concurrently that call the CSV to DB smart service, it fails due to an SQL exception, but if we relaunch every single failed process model, it can process with no problem. It seems that the plugin cannot manage more than one connection on the same time.

  • v2.6.2 Release Notes
    • Upgraded Commons Compress Version

  • Hi,

    Is there any way to avoid the duplicate ingestion of csv data into database. Suppose second file contains the duplicate data compared to the first one, is there any way to ensure that the duplicate data do not append.

    Regards,

    Dushyant