Hi Everyone,
in Appian 19.2 version, Excel tool - export sql to excel smart service has bee deprecated. we encounter "[ following error was raised by the Export to Excel function: null ]" error in production.
i am seeking for solution, how to fix the issue?
if there any alternate solution for this.
kindly help me here.
Discussion posts and replies are publicly visible
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.
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.
@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?