01-12-2011 1:18 PM
Hi,
Somebody know any FM or CLASS for uplaod excel over 600.000 rows?
Hi,
try OLE-logic to select a range, than use method COPY of OLE.
After this try method: CALL METHOD CL_GUI_FRONTEND_SERVICES=>CLIPBOARD_IMPORT.
Hope it helps.
regards, Dieter
Hi Dieter Gröhn,
Thanks for help.
But we don't resolve.
I need the FM for upload excel to internal table program.
The class CL_GUI_FRONTEND_SERVICES / method FILE_COPY and CLIPBOARD_IMPORT don't make what i want.
There is um method this class that can use for upload to internal table? or do you know any other FM or class?
Thanks.
01-12-2011 1:42 PM
01-12-2011 1:37 PM
Hi,
Use the Function Module : TEXT_CONVERT_XLS_TO_SAP
This Function will upload the excel sheet data in to an internal table.
Before that you should take care that the excel sheet must be in 97-2003 format. Other wise it will not read the data from the excel file and the data in the internal table will be zero.
So please do this validation in the at sellection of that parameter.
If the excel sheet is not in .XLS type then give a message saying that use the compatible excel sheet that is of type mentioned above.
With Regards,
Sumodh.P
01-12-2011 1:42 PM
01-12-2011 4:21 PM