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
  •      @ @Apppin Support Team  @Appian Corporation

    Read Excel File Paged (readexcelsheetpaging()) function is not reading excel file properly in one of the use case. Could you please review and fix this issue. 

    Use case and Steps to re-create:

    • Create a simple Excel file with two columns(Two Headers)

    • Add an simple Excel function to second column

      • The logic is, based on column 1 value conditionally populate second column value

      • Ex: =IF(A2:A100 = "", "-", IF(A2:A100<100, "TRUE","FALSE"))

    • Populate the data in column 1 for this Template using Appian process (You can used Export CDT to Excel or Export SQL to Excel)

      • Note: I know the above mentioned smart services are deprecated, but those are working fine (You may already know about this as your the owner of the plugin and As community team members mentioned)

    • Now use readexcelsheetpaging() to read the generated Excel file

      • It only returns the first column values, but the second column values coming as blank

        • Note1: Now download the same generated document from Appian to local desktop and open the file, you will see the column 1 and column 2 values properly.

        • Save the file and re-upload the file to Appian manually, now if we read the file using readexcelsheetpaging() it reads properly

    • Note 2:  But if we use readexcelsheet function it is reading properly (But it is not recommend to use as it consumes to much system resources)

    • I think there is an issue reading the file if it is generated in Appian, could you please review this and fix the issue.
Comment
  •      @ @Apppin Support Team  @Appian Corporation

    Read Excel File Paged (readexcelsheetpaging()) function is not reading excel file properly in one of the use case. Could you please review and fix this issue. 

    Use case and Steps to re-create:

    • Create a simple Excel file with two columns(Two Headers)

    • Add an simple Excel function to second column

      • The logic is, based on column 1 value conditionally populate second column value

      • Ex: =IF(A2:A100 = "", "-", IF(A2:A100<100, "TRUE","FALSE"))

    • Populate the data in column 1 for this Template using Appian process (You can used Export CDT to Excel or Export SQL to Excel)

      • Note: I know the above mentioned smart services are deprecated, but those are working fine (You may already know about this as your the owner of the plugin and As community team members mentioned)

    • Now use readexcelsheetpaging() to read the generated Excel file

      • It only returns the first column values, but the second column values coming as blank

        • Note1: Now download the same generated document from Appian to local desktop and open the file, you will see the column 1 and column 2 values properly.

        • Save the file and re-upload the file to Appian manually, now if we read the file using readexcelsheetpaging() it reads properly

    • Note 2:  But if we use readexcelsheet function it is reading properly (But it is not recommend to use as it consumes to much system resources)

    • I think there is an issue reading the file if it is generated in Appian, could you please review this and fix the issue.
Children