Coding With Fun
Home Docker Django Node.js Articles Python pip guide FAQ Policy

How to upload an excel file using gui upload?


Asked by Rhys Burton on Dec 03, 2021 FAQ



If you are using excel file to upload using 'GUI_UPLOAD', first save the excel file in CSV format (Comma separated Values file). While saving the file, you can use dropdown to choose CSV format. Help to improve this answer by adding a comment.
Furthermore,
No need to use GUI_UPLOAD as it will not solve your purpose, use the below code, it will work for sure. DATA: lv_file_name TYPE rlgrap-filename.
Likewise, While using GUI_UPLOAD, you get the data into the internal table say int_tab. Then, you loop at int_tab into some work area (wa_file). Then, you use the following split statement. wa_mat-meins. And before ending the loop just use append statement to get the records into some other internal table which is having same fields as of uploading file.
Besides,
The security configuration for uploading from a local file must allow it to avoid the ‘allow / deny’ pop-up window. FM to read excel / txt file from local drive only runs on SAP GUI for Windows (both version 7.50 sp 10 and 7.60), but will get error if running on webgui because security configuration to upload from local file can’t allow in webgui.
Moreover,
Upload files with Powershell GUI Create Simple PowerShell UI for browsing the location of files with one textbox and two button type (upload & cancel)... In Browse button click event, you can perform the browse with the specific file that need to be upload to destination... In upload button click ...