topic UPLOAD EXCEL in Application Development and Automation Discussions

UPLOAD EXCEL

Former Member — Wed, 12 Jan 2011 13:18:13 GMT

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.

Re: UPLOAD EXCEL

Former Member — Wed, 12 Jan 2011 13:37:45 GMT

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

Re: UPLOAD EXCEL

Former Member — Wed, 12 Jan 2011 13:42:16 GMT

Try to use this Function Module ALSM_EXCEL_TO_INTERNAL_TABLE

Re: UPLOAD EXCEL

Former Member — Wed, 12 Jan 2011 16:21:36 GMT

Ok, thanks a lot all!