How can i export the results set from Stored procedure to Excel?

Hi, I am trying to export the result set from Stored procedure to Excel. What is the best way to achieve this? I tried using Export DSE to Excel but it is extracting only from DSE and was not able to feed the Stored procedure results.

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    Sadly the Excel Tools plug-in has deprecated the "CDT to Excel" smart service, but if you somehow have access to an older version of the plugin (2.0.0 or before, IIRC), you might try that.  Note that it was supposedly deprecated due to performance concerns, though I've never had any performance issues with the latest versions even after extensive use.  Appian still hasn't provided any information as to when they might provide a functionally complete replacement for this component, leaving many of us stuck using old/outdated versions.

Reply
  • 0
    Certified Lead Developer

    Sadly the Excel Tools plug-in has deprecated the "CDT to Excel" smart service, but if you somehow have access to an older version of the plugin (2.0.0 or before, IIRC), you might try that.  Note that it was supposedly deprecated due to performance concerns, though I've never had any performance issues with the latest versions even after extensive use.  Appian still hasn't provided any information as to when they might provide a functionally complete replacement for this component, leaving many of us stuck using old/outdated versions.

Children
No Data