I have got a request from user to develope a report where he want to download the report displayed in excel sheet. I know about the export button available on grid and also the WS_DOWNLOAD FM which exports the internal table to spreadsheet.
My requirement is when user downloads the data displayed in grid, he want to do some operations on the data in background for some selective fields , so even it is showing value 'X' for particular field, it will process and download value 'Z' for that field. Out of 20 columns he can hide any number of columns as per his requirement and should be able to download only those visible columns on grid on button press.
Please let me know if anybody has worked on such requirement.