Skip to Content
0
Former Member
Sep 10, 2007 at 10:46 PM

Excel Upload Problem

1042 Views

Hi All,

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 ?