topic Function Module for .xlsx to Internal table in Application Development and Automation Discussions

Function Module for .xlsx to Internal table

Former Member — Mon, 18 Oct 2010 13:52:09 GMT

Hi ,

Please let me know if there is any Function Module for .xlsx to Internal table.

@ Moderators - I suppose it is not basic question because I am asking about .XLSX but . XLS.

Not sure why rob.burbank has blocked the thread.

Regards,

Varun

Former Member — Mon, 18 Oct 2010 15:49:24 GMT

Does FM ALSM_EXCEL_TO_INTERNAL_TABLE not work with XLSX files?

Rob

Former Member — Mon, 18 Oct 2010 17:40:44 GMT

Poster needs to attempt. I found that ALSM_EXCEL_TO_INTERNAL_TABLE works exactly as expected with my .xlsx files.

nabheetscn — Mon, 18 Oct 2010 18:29:15 GMT

Use the following function module KCD_EXCEL_OLE_TO_INT_CONVERT.

Hope it helps

Nabheet

Former Member — Mon, 18 Oct 2010 18:38:54 GMT

@BreakPoint - It works for me too.

@OP - so this thread is locked as well. But if the FM doesn't meet your requirements, you can re-post with an explanation.

Rob