Skip to Content
0
Oct 13, 2020 at 04:06 AM

UPLOAD_OLE exception thrown when uploading Excel file with Comments

252 Views Last edit Oct 13, 2020 at 04:11 AM 2 rev

Hi all,

I'm using a customised version of ALSM_EXCEL_TO_INTERNAL_TABLE to upload excel files to SAP. I've come across an error where having comments in the excel file will cause the FM to throw the UPLOAD_OLE error (sy-subrc = 2). Would anyone happen to know a workaround around this so I can still upload the file without deleting all comments?

Regards,

YiLin

Edit: Would also like to add that I tried uploading the same file using FM KCD_EXCEL_OLE_TO_INT_CONVERT but the same exception was thrown when there were comments in the Excel file. Once I removed the comments , the exception disappeared.