Skip to main content
neeleshj2272
neeleshj2272
September 14, 2023
Question

Export readOnly grid data to excel

  • September 14, 2023
  • 7 replies
  • 0 views

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. 

7 replies

mikes0011
mikes0011
Brainy
September 14, 2023

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.

neeleshj2272
neeleshj2272Author
September 14, 2023

Is there any other way a part from that because it'll show as vulnerable if we use it.

mikes0011
mikes0011
Brainy
September 14, 2023

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.

sureshd0004
sureshd0004
September 14, 2023

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.

'

mikes0011
mikes0011
Brainy
September 14, 2023
'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.

sureshd0004
sureshd0004
September 15, 2023

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. 

    Terms & ConditionsAccessibility statement