How to upload .xlsx into internal table in WD abap

[former_member202245]

I have used FM  'TEXT_CONVERT_XLS_TO_SAP' but it is giving a dump:

Exception condition "CNTL_ERROR" raised.

If anyone knows how to upload .xlsx or .xls into internal table please share.

Thanks

Parag

[Former Member]

Hello Parag, Amy,

You can use cl_fdt_xl_spreadsheet standard class for .xlsx file upload. You can refer to my content for the same through the given link.

http://scn.sap.com/docs/DOC-45719

Please award points if useful.

Thanks and Regards,

Devesh Singh

[amy_king]

Hi Parag,

Did you solve this? I'm trying to do the same, however, after much searching it seems the answer is that ABAP Web Dynpro doesn't have the ability to upload .xls or .xlsx files and you must convert the Excel file to a CSV or tab-delimited text file and upload that. Did you find a different solution?

Cheers.

[Former Member]

save your xlsx file as .csv and try to upload again

[Former Member]

hi parag,

http://saptechnical.com/Tutorials/WebDynproABAP/Upload/Page1.htm

try this link

regards

Rajashiva

[amy_king]

Just FYI for other readers in search of a solution , I tried this solution myself but it seems that in the end the file that the demo uploads is really a text file and not an Excel file. Uploading an .xls or .xlsx file doesn't work because converting xstring to string doesn't translate Microsoft's proprietary Excel format.

[Former Member]

Upload your file as .csv

make your data source as xstring.

use FM 'HR_KR_XSTRING_TO_STRING'.