Skip to main content
S
shubhamy3376
July 3, 2023
Question

Exporting to excel

  • July 3, 2023
  • 8 replies
  • 0 views

Hi Everyone,

Can anyone suggest me if I need to export DSE to excel which have more than 50 columns, which smart service to prefer. Since Export DSE to excel smart service works for only 50 columns.

Thank you!

    8 replies

    mathieud0001
    mathieud0001
    Brainy
    July 3, 2023

    I have never tried this but perhaps you could try 2 exports (i.e. columns 1-50 and columns 50-100) and then merge using the Merge Excel Documents in the Excel Tools plugin?

    community.appian.com/.../excel-tools

    mikes0011
    mikes0011
    Brainy
    July 3, 2023

    I know there are a wide range of use cases, but please be sure to at some point at least consider whether "more than 50" is too many to be usable to anyone, which will usually be the case.

    Also i believe you can just call the node a second time, pointing to the result of the first use, and pointing at a starting cell one column to the right of the final column generated by the first call.  Does this not work for you?

    karumurua531442
    karumurua531442
    July 4, 2023

    Hi [mention:bb176b67c26c4e89b2173f39160c9f46:e9ed411860ed4f2ba0265705b8793d05] the better way is to use export sql to excel smart service this can be used for large amount of data as well. use select query for the required columns in sql parameter in that smart service.

    keerthanar849441
    keerthanar849441
    July 4, 2023

    But Export SQL to Excel smart service has been deprecated and it might be removed completely in the upcoming releases. So this method might not be the correct solution.

    mikes0011
    mikes0011
    Brainy
    July 4, 2023
    smart service has been deprecated and it might be removed

    It's been "deprecated" officially for several years now but still works fine, and there is yet no sufficient replacement for it - so it won't be removed without plenty of advanced notice.

    Terms & ConditionsAccessibility statement