Skip to main content
bhushanc391326
bhushanc391326
June 21, 2021
Question

Export CDT To Excel breaking after recent update to Excel Tools Plugin Version 2.2.13

  • June 21, 2021
  • 5 replies
  • 0 views

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: 

  • We are on Cloud.
  • We tried to use the new Export Data Store to Excel plugin however it does not support XLSM files.


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.

5 replies

selvakumark
selvakumark
Participating Frequently
June 21, 2021

Hi [mention:5ee4c401835c47eeb39abd471c636860:e9ed411860ed4f2ba0265705b8793d05],

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.

mikes0011
mikes0011
Brainy
June 21, 2021

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).

The Expression Guru
selvakumark
selvakumark
Participating Frequently
June 22, 2021

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.

C
chandhinir
June 21, 2021

Another alternative plugin:

https://community.appian.com/b/appmarket/posts/sql-to-excel

Terms & ConditionsAccessibility statement