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

Question

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.

Mike Schmitt · Answer

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.

Ravi Roshan · Answer

You can try to export the data to CSV Format, if that meets your requirement. To do this you need to convert the data to HTML and then you can use Convert HTML to CSV smart service to generate the document.