Export SQL to excel plugin has been deprecated?

hI,

yes, there is a alternate solution, you can use datastoreentity to exce plugin available for  achieving your solution

Regards,

Bhanu. 

This smart service is having limitation of taking only 50 column and in our report column is more that 100. by spliting the column we can show the report but User do not want that kind of report.

Kindly help me here.

Regards,

Vikram 

Have you tried running the smart service twice, once for each set of columns (1 - 50, 51 - 100)? You would pass the generated document into the second instance of the node to be updated, and pass in a starting cell equating to the cell position of the 51st column.  I'm not 100% sure how well this will work but I'd give it a try.

Also in a big picture sense, 100 columns is a lot for a report - it might be worth breaking down and determining whether all of these are strictly necessary at all times.

Have you tried running the smart service twice, once for each set of columns (1 - 50, 51 - 100)? You would pass the generated document into the second instance of the node to be updated, and pass in a starting cell equating to the cell position of the 51st column.  I'm not 100% sure how well this will work but I'd give it a try.

Also in a big picture sense, 100 columns is a lot for a report - it might be worth breaking down and determining whether all of these are strictly necessary at all times.

@bhanuprakashm806 - exportdatasubsettoexcel pluing - where will i get it?

it's not actually a plug-in (i think he meant to say "Smart Service"?) - it's available out-of-the-box for the past several Appian versions.

edit: i was referring to "export data store entity to excel", not "export data subset" (which was a plug-in); as far as I know that one, if even still available, is outdated and certainly not recommended.

is it fisible soluton for this?