1,053 SAP Managed Tags: ABAP Development Hi, I am using the fm ALSM_EXCEL_TO_INTERNAL_TABLE to upload the excel file into an Internal table. Its working fine but some times it is throwing an error UPLOAD_OLE error. Can somebody has an idea on this? Thanks bprReply...
ABAP code for uploading an Excel document into an internal table using function module KCD_EXCEL_OLE_TO_INT_CONVERT. The code is based on uploading asimple Excel spreadsheet. This code also works with the new MS excel format .xlsx. Be carefull though for some reason SAP have decided to us...
UPLOAD_OLE = 2. Reply Former Member 2005 Jul 26 8:46 AM 0 Kudos 520 SAP Managed Tags: ABAP Development Hi, Try this out * Retrieve data file from presentation server(Upload from PC) DATA: i_file like rlgrap-filename value '/usr/sap/tmp/file.txt'. DATA: begin of it_da...
http://www.sapdevelopment.co.uk/file/file_upexcel.htm Reply Former Member 2,964 SAP Managed Tags: ABAP Development Hi see this program in this EXCEL TO INTERNAL TABLE AND THEN TO APPLICATION SERVER REPORTZSD_EXCEL_INT_APP.parameter:file_nmtypelocalfile.types:beginofit_tab1,f1(20),f2(40)...
Various useful answers from SCN Forum questionExcel File Upload In Webdynpro For ABAP Upload/Read .xlsx file in SAP WebDynproby Devesh Singh Class CL_FDT_XL_SPREADSHEET Above three references helped me to build solution,last onefits in perfectly. But there is always a catch – this class CL...
SAP Managed Tags: ABAP Development Hi all, I am a fresher and was working on uploading a .prn(space delimited) text file into my internal table. I get this Bad data format exception even after I attempted all trials. Any help is appreciated. Here is the code in the attached text file...
A Comprehensive Guide to Using OLE Objects in SAP ABAP 1 aATP 1 ABAP 41 ABAP 7.4 2 ABAP API 1 ABAP BAPI BAPI_FIXEDASSET_CREATE1 1 ABAP BTP 1 ABAP CDS VIEW 2 ABAP CDS Views 12 ABAP CDS Views - BW Extraction 3 ABAP CDS Views - CDC (Change Data Capture) 3 ABAP Cl...
SAP Managed Tags: ABAP Development Hi, Do use the function module as follows. CALL FUNCTION WS_UPLOAD. IMPORTING FILENAME = 'C:\' FILETYPE = 'ASC' OR 'DAT' TABLES DATA_TAB = ITAB[] EXCEPTIONS CONVERSION_ERROR = 1 FILE_OPEN_ERROR = 2 FILE_READ_ERROR = 3 INVALID_TYPE = 4 NO_...
SAP Managed Tags: ABAP Development hi we have the requirement to download data in excel file in unicode format for which the OLE FM EXCEL_OLE_STANDARD_DAT in used for the download. We now want to upload the same file after modification. GUI_DOWNLOAD uplaods the file wsith gibberish cha...
ABAP Development Hi, For excel file You must specify file type as .xls Regards Reply Former Member In response toFormer Member Options 2008 Mar 084:40 PM 0Kudos 469 SAP Managed Tags: ABAP Development I HAVE MENTIONED ALREADY THE FILE TYPE AS .XLS BUT IT WONT WORK... BY, RAGHUL...