Excel Generation

Hello GauravSingh,

If you are getting the data from you tables or views, You can use a dynamic query to create/construct the SQL statement using your data from the columns and you can use that statement in SQL to Excel smart service. 

If you are having a staging table then you can use the  Export Data Store Entity to Excel Smart Service 

If you are using a staging table to do so, you must make sure your DB table is locked until your action is completed every time you run the process. This will avoid multiple entries from different instances which will lead to incorrect data.

I recommend to use the SQL to Excel which seems to be hassle free.

We have CDT to Excel smart service which is now deprecated. But you might still try, it is still working.  You need to construct the data into your CDT format and then pass the data to the Smart service.

I hope this will give some solution to your question

Hello GauravSingh,

If you are getting the data from you tables or views, You can use a dynamic query to create/construct the SQL statement using your data from the columns and you can use that statement in SQL to Excel smart service. 

If you are having a staging table then you can use the  Export Data Store Entity to Excel Smart Service 

If you are using a staging table to do so, you must make sure your DB table is locked until your action is completed every time you run the process. This will avoid multiple entries from different instances which will lead to incorrect data.

I recommend to use the SQL to Excel which seems to be hassle free.

We have CDT to Excel smart service which is now deprecated. But you might still try, it is still working.  You need to construct the data into your CDT format and then pass the data to the Smart service.

I hope this will give some solution to your question

The problem that we go into is that we have the updated version of the Excel tools which doesn't have the smart service itself.

Is there any way possible to downgrade the version of the plugin

We are using Appian Cloud Instance.

I'm not sure if downgrading the version is possible. 

Excel Tools - 2.3.0

SQL To Excel Smart Service - 1.3.0

These versions have the smart services. Not sure about the latest.

If you have Connected Infrastructure setup, you could try and deploy the older version of the plugin from another environment to this environment. It may be better to use this opportunity to replace the deprecated plugin smart service with the out of the box smart service.