GUI_UPLOAD issues

[Former Member]

Hello,

I am trying to download a big chunk of file into an internal table which has a size of 60000 rows using 'GUI_UPLOAD'. When I check number of rows or internal table size after executing the FM in debug mode, the internal table have only 6699 rows instead of 59900 rows. Is there a constraint on number of rows in GUI_UPLOAD function module. Please share your thoughts or solution to my problem.

Thanks

[ShyamPindiproli]

You can alternatively make a try using the Static method - of the GUI Front End Services

'CL_GUI_FRONTEND_SERVICES =>GUI_UPLOAD'.

[Former Member]

Hi Ben,

Read this thread completely . http://scn.sap.com/thread/492737

Hope will solve your issues while uploading.

Regards,

Saravana.S

[Former Member]

try with this

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

[former_member222709]

Hi Ben,

You can use 'GUI_UPLOAD' for records upto 65,535 rows, but, there are some issues while using xls. If you want to check the reason for the reduced number of rows, then, debug the internal table used in 'GUI_UPLOAD'. Locate the record where the truncation happens. Probably, whenever 'GUI_UPLOAD' comes across special characters in an xls file, it considers the encounter record as a comment till the same special character is repeated. So look out for ',",!, etc. in your excel file and you might get the problem.

Finally, this can be resolved either by using 'GUI_UPLOAD' with a text file or using the new OLE Methods with 'CL_GUI_FRONTEND_SERVICES'.

Hope this helps.

Regards,

Pranav