FM to upload excel file

[former_member221367]

Hi ,

I have to upload excel file in my webdynpro application , for that i m using HR_KR_XSTRING_TO_STRING  but it dont work , I also used SCMS_XSTRING_TO_BINARY and SCMS_BINARY_TO_STRING for the purpose but did'nt get success .

Please help me out .

[former_member184578]

Hi,

There is no provision to upload excel file in Web Dynpro ABAP. However you can upload a tab delimited file (.txt or .csv files ). when you use the FM HR_KR_XSTRING_TO_STRING to upload the .xls file you will get junk characters.  You can convert the .xls file to tab separate file and upload using the mentioned function module.

But you can upload .xlsx files using ABAP2XLSX. Check this document for reference  http://scn.sap.com/docs/DOC-45719

Hope this helps u.,

Regards,

Kiran

[former_member221367]

Thanks Kiran for your reply , I tried the link ref by u but I am getting error as

The type "CL_FDT_XL_SPREADSHEET" is unknown.

The type "CX_FDT_EXCEL_CORE" is unknown.

I have checked these classes in se24 but not found there too.

[former_member184578]

Hi,

You should be on Netweaver 712 to use the mentioned classes.

Regards,

Kiran