Recently one of the dev updated the Excel tools plugin from 2.0.2 to new 2.2.13 version in Appian and this has lead to breakage of the Export CDT To Excel smart service. can anyone suggest what can be done to resolve this issue?Note:
EDIT: Export Data Store to Excel also does not support alias with space in it. this makes it hard to generate excel files in user friendly manner. We use the generated files to upload to a system and it requires header to be in specific manner and does not accept with different headers. Example: Previously: First Name Now: First_Name
Thanks,Bhushan.
Discussion posts and replies are publicly visible
Hi bhushanc581,
Export Data Store to Excel supports the alias concept. All we have to do is to set the alias names using the 'Custom Cell Positions' & 'Custom Cell Values' parameters & exclude the header row in the export configurations. This will generate the excel file with custom headers.
Export DSE to Excel is not a valid replacement for Export CDT to Excel when an input excel template is required, since it does not accept any sort of input template (and if you have it overwrite a file it overwrites all formatting, etc).
Another alternative plugin:
https://community.appian.com/b/appmarket/posts/sql-to-excel
Hi Mike, I agree that it does not support custom templates & overwrites the document formatting. But I believe Bhushan's use case here is to just have a custom header for the data & that can be achieved using this smart service right? So I recommended this one for a simple & quick workaround.
Yeah - i'm unclear what exactly his requirements are with respect to an input template. I've almost never had a use case where I can use the generation without an input template, as customers almost always require pre-formatted columns with formatting on the headers and usually with filtering pre-enabled, all of which is possible in the Export CDT to Excel smart service, and none of which is possible in Export DSE to Excel thanks to its failure to include this (IHMO standard) feature.