We have a requirement to upload excel sheet data to an internal table via a WDA application . I searched the forum for a viable solution but couldnt find one.
We have some data in an excel sheet which we want to upload to an internal table, and then display it in a table element on the application screen.
Heres how i tried doing it :
I used the file upload functionality provided . I uploaded the file as an Xstring(this works without a problem) . Then i took the filename into a variable and tried to pass this filename to a function module which reads excel data (ALSM_EXCEL_TO_INTERNAL_TABLE)
However this gives me an error saying 'error while importing clipboard' . This seems to come from the CL_GUI_FRONTEND_SERVICES->import method.
Could anybody suggest a solution to this or an alternative method by which i could access Excel sheet data from the presentation layer in the WDA application ?