Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
Hey All,
Is there any smart service which have "Base Template" option, like we had in "Export CDT to excel". Requirement is excel generation with two pages. First page data comes from data store entity, where as second page is static information, which is fixed data. As the "Export Data Store Entity to Excel" not having base template, how to achieve this? Thanks in advance.
Discussion posts and replies are publicly visible
Hi Muthulakshmi,
We can use Export SQL to excel plugin, in your usecase where you can keep the base template with two sheets where the second sheet will hold the static data in the template itself.
By using this plugin just query the db and update in the sheet1 .
Thanks for your reply Dinesh. Here i am working on 19.4 version. Many smart services for excel is deprecated, including this "Export SQL to excel" one.
I have a feature request thread open for this. I would encourage you to go there and upvote it, as well as commenting with your use case to both float it back to the top of the Community thread list, as well as further demonstrate to Appian that this is a thing that's actually really needed in order to make Export DSE to Excel any sort of replacement for the deprecated Excel Tools nodes.
Thank you Mike. I have updated the feature Request Thread, with my use case
We are using cloud version - 19.4. Is there any other way to achieve this requirement for now?
Muthulakshmi said:Is there any other way to achieve this requirement for now?
Unfortunately without the old Export CDT to Excel smart service from Excel Tools, there is nothing I know of for now. If this will be a major blocker for you, you could open a support case with Appian Cloud Support and point them at both of these Community threads - other than that I have no idea how to escalate with them, considering that (according to Jupiter Munoz's reply in the feature request thread, at least) they seem to be aware of it already.