Skip to main content
Y
yatins2606
Participating Frequently
May 16, 2023
Question

Interface to excel

  • May 16, 2023
  • 8 replies
  • 0 views

I want to export data from editable grid to excel file without storing data to database. How can I achieve this?

    8 replies

    stefanhelzle0001
    stefanhelzle0001
    May 16, 2023

    Would a CSV file work for you?

    Y
    yatins2606Author
    Participating Frequently
    May 16, 2023

    No, requirement is to export data to excel.

    stefanhelzle0001
    stefanhelzle0001
    May 16, 2023

    I do not know of any way. Maybe others can help.

    gopalk2865
    gopalk2865
    May 16, 2023

    Why dont you try creating a temp table and store these data into the table and then use export dse to excel. IS there any specific reason you dont want to write to db?

    mathieud0001
    mathieud0001
    May 16, 2023

    I usually do this by using [View:https://docs.appian.com/suite/help/23.1/Export_Process_Report_Excel_Smart_Service.html]. I use a dummy (empty) process report and use the Custom Cell Positions and Custom Cell Values to manually push to some values to it.

    vijayg1506
    vijayg1506
    June 1, 2023

    We are trying your approach but somehow unable to follow the the steps to get the result. could you please elaborate this more or share us some sample code.

    mathieud0001
    mathieud0001
    June 1, 2023

    Can you gives more details on which part you are having trouble with?

    - Create a process which calls the Export to Excel Smart Service

    - Add a script node that calls a an expression rule that returns 2 lists (positions and values)

    - Configure the Export Process Report to Excel node with an empty process report and the  positions and values

    Positions and values should look like this

    positions: {"A1", "A2"}

    values: {"value 1", "value2"}

    mikes0011
    mikes0011
    Brainy
    June 1, 2023

    Use the "CDT to Excel" node from the Excel Tools plug-in.  Create a generic CDT consisting of X number of plaintext fields (where X represents the maximum number of columns you might need).  Cast your data into this CDT type and pass it into a process instance using a!startProcess.  Should be fairly easy.

    Terms & ConditionsAccessibility statement