I have a read only grid sourced from expression which is getting data from an integration. I want to export this grid data to excel. So can someone please help how to do this. Stuck here as Export CDT to excel is deprecated.
Discussion posts and replies are publicly visible
Export CDT to Excel still works fine in spite of being deprecated. There has never been a sufficient replacement provided, so for now I keep using it where necessary.
Is there any other way a part from that because it'll show as vulnerable if we use it.
Write the CDT data to a temporary table and then dump it into an Excel using the Export DSE to Excel smart service - this should work fine other than the fact that it has no method by which to supply a pre-formatted base template (which makes it useless to me since all my use cases require this, but if yours doesn't, then you should be fine).
This will be the "officially supported" solution (and AFAIK is currently the only one), despite my annoyance that the functionality of this node is still so hampered.
If possible and fits your needs you may try to create a expression back record for the integration and use OOTB export functionality if that satisfies your requirements.
Also, as suggested by @mike schmitt, you can write the data to DB table and use Export DSE to Excel smart service or if you need base template another plugin you can use which supports base template in 'SQL To Excel Smart Service' plugin. You can find 'Export SQL To Excel' smart service provided which accepts a base excel template with in this plugin and it has no deprecations as of now.
'
sureshgunawardane said:'SQL To Excel Smart Service'
FWIW, SQL to Excel is the twin sister of CDT to Excel, both are found in the Excel Tools plug-in, and both are currently deprecated (but also both still working). And from OP's earlier reply, it sounds as if they're under some oversight burden to avoid deprecated smart services, which I suppose I understand, though it leaves them in a tough spot since no sufficient replacement has ever been provided that actually captures the functionality made available in those deprecated smart services.
HI Mike,
Actually the plugin and the smart service I referred to is not in the Excel Tools plug-in. May be it is like you said and it is now bundled up in Excel tool. But this is a separate plugin we can use from App Market and it is not marked as deprecated, So probably using it won't add the burden of using in the project Neelesh is referring to. Please refer to the screenshot here.
sureshgunawardane said:But this is a separate plugin we can use from App Market and it is not marked as deprecated
You're right, that's a newer plug-in (I assume it might be a copy of the smart service that used to be in Excel Tools, but it's hard to say) and yes, it doesn't seem to be deprecated. So for any export that can be handled with a SQL statement somehow, I agree this would be something to consider. (Too bad they couldn't add a smart service for Export CDT to Excel, lol)