I have requirement where I need to export data of the editable grid but issue here is I will be able to it in read only grid with help of parameter showexport but how to do it in editable grid.
Discussion posts and replies are publicly visible
Dose DSE to Excel accept record type as input because we don't use Data store over here we are completely in Record type.
As far as I know you'd have to use a workaround to make this work - like creating a DSE just for the record type in question (though that's a lot of work).
Alternatively, I actually prefer the smart services still found in the Excel Tools plug-in, such as "CDT to Excel", which is deprecated but still works fine as of my last check. With CDT to Excel, you would merely query your record type data, and use an expression rule to cast the columns of data you want into a "generic" CDT you create (you'd just create a generic CDT not linked to any table, with X number of plaintext columns), and use that within the CDT to Excel smart service node in your process.
It takes a little bit of setup but is very easy to use, and as a bonus, you can use a pre-formatted template Excel document (with pre-sized columns and formatted column headers with pre-enabled filtering, if you like).
I also continue to use the deprecated "Export CDT to Excel" service, as we have not seen any replacement function that allows the use of a base template. No issues with this service in my 24.4 environment.
can you let me know what file need to be uploaded here Excel_base_template - can you share any sample file.
For the base template you can simply construct a blank Excel file with your columns pre-configured (and pre-named) with customized widths, formatting (i.e. make the column names bold, add background color if you want, etc), and pre-enable filtering on one, many or all columns if you want the generated file to automatically have it available. Then you configure the smart service to start its output in the second row.
You can't do much pre-formatting of the cells that will actually contain data, as everything in the data cells gets overwritten; but it's nice to have a friendly format instantly in your generated excel document. Hence why I've been so insistent that Appian eventually fix the Export DSE to Excel smart service (though at this point I doubt it'll ever happen).