Skip to Content
0
Nov 10, 2011 at 05:07 PM

XML schema to upload .xlsx file

42 Views

Hello Guys,

I need to upload a .xlsx file from appl server scheduled in BACK GROUND to my ABAP program.

I am getting this error in the background job logs."Excel file /usr/sap/tmp/file.xlsx cannot be processed"

1) If i use open dataset & read dataset as below, i am getting some junk characters in wa_datatab.

OPEN DATASET i_file FOR INPUT IN TEXT MODE

if sy-subrc eq 0.

DO.

READ DATASET i_file INTO wa_datatab.

if sy-subrc ne 0.

exit.

endif.

ENDDO.

endif.

2) I dont think i can use the FM: TEXT_CONVERT_XLS_SAP here.

i am hearing about XML/iXML schema ..etc to do the same.

Can some one help me on this?

Thanks

Ricky