Export Data Store Entity to Excel/CSV smart service issue with text formatting

Hi,

This smart service will not be retaining the formatting. Now as Appian had split them up in the 18.2 version. Csv files doesnt have formatting so what you can do is you can pass the data to a cdt and then use CDT to excel smart service.

Hope this helps

Regards
Ekansh

Hi You can use CDT to excel smart service

First create a temp cdt which will store your values as text format and for exporting the data into excel use the temporary cdt for that

One problem with this: the CDT to Excel Smart Service has now been deprecated at least since 2.0.2. As such, you are unable to use this Smart Service to export this data if you do not have an older version of the plugin or are able to recompile it to remove the "#Deprecated#" flag (which is not recommended).

Thanks Arpit. I'm aware of above smart service.
But we are looking for dynamic sheet renaming.

Now that Export CDT to Excel has been deprecated from the Excel Tools plug-in (for reasons not yet given), I'm in a real bind. The latest version of this node was the only one I know of which provided the ability for Word Wrap to be retained in the exported version of the document - all other Excel generators I've tested overwrite word wrap even when set in advance. If anyone has any tricks for this, I'd be all ears.

I wish I could use Export DSE to Excel, but the fact that it can't use a template document makes it nearly useless to me - every single report I've been required to build in the past needs to have pre-formatting determined via a template document.