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
The editable grid has no such OOTB functionality.
Is there any other work around to do it. I have a requirement while clicking on the button it should download an excel file to the local system with the editable grid data.
Well, the typical more or less ugly Excel export things. A simple one might be to create a CSV file instead of an Excel.
But how to achieve it with editable grid.
hi aradhana ganabady may I know your complete use case, please?
I want to have button above the editable grid while clicking on the editable grid I want a excel file to be downloaded to my local system with the editable grid data.
OK, I think we need a bit more details about your specific use case.
- Where is the data coming from?
- Is that data stored in DB and just displayed in that grid?
- Is the data only entered, but not stored?
Editable Grid1 : Take comes from no where2: Data will be store in Record Type.3: Data is only entered and at the time frame its store in rule input.
OK. So you could submit, store the data, create the file, and return to the same interface showing the link to download the file.
The "official" way of handling this would be to write that data to a data store or record. Then you could do various things, including having your button launch a Start Process (function) calling a process model that invokes an Export DSE to Excel node, generates an Excel, then pass that document ID back to the interface to show in a Download link. This requires 2 clicks (not just 1) and there is no current good work-around.