Skip to main content
K
kathirm0790
January 31, 2023
Question

Excel download.

  • January 31, 2023
  • 3 replies
  • 0 views

I have a table with value column. Already I have implemented download link in my report based on the table.

I need to add a new column with formatted value, front end I have done this, but download part, how can I manage(I dnt want to change backend table)

    3 replies

    gayathris111098
    gayathris111098
    February 3, 2023

    The Export Data Store Entity to Excel smart service does not allow you to format a data. 

    Two ways you can try,

    1. Using the Export Record List functionality as that allows you to export the same format you see on the record list itself.

    2. Use Export CDT to Excel smart(deprecated) If its already in your environment. (The only way of getting this would be to get an old version (2.0.0 or earlier) of the Excel Tools plug-in)

    https://community.appian.com/discussions/f/general/17467/feature-request-update-the-export-data-store-entity-to-excel-smart-service-to-accept-an-excel-base-template

    community.appian.com/.../export-cdt-to-excel

    konduruc733182
    konduruc733182
    February 3, 2023

    Hello kathirm0790,

    You can use the export SQL to excel smart service to do this.

    Create an expression rule that will contain the select statement and all the columns that you need in the excel sheet.

    Call this rule in the SQL statement of the Smart service.

    I hope this explanation is understandable. 

    gopinathb0002
    gopinathb0002
    April 3, 2023

    You may try using Custom Cell Positions and Custom Cell Values using Export Data Store Entity to Excel Smart Service. 

    Terms & ConditionsAccessibility statement