topic Re: Function Module ALSM_EXCEL_TO_INTERNAL_TABLE in Application Development and Automation Discussions

Function Module ALSM_EXCEL_TO_INTERNAL_TABLE

Former Member — Wed, 20 Dec 2006 05:03:33 GMT

Hi all!

It is mandetory to provide rows and columns details to Function like start and end of each. Can it be flexible? any other function?

Because program will run automatically and it will pick up the data runtime. So columns and rows cannt be defined.

Please help.

Thanks in advance,

Former Member — Wed, 20 Dec 2006 05:07:47 GMT

ya u can use gui_download for download exel sheet.

Former Member — Wed, 20 Dec 2006 05:08:42 GMT

Hi prax,

1. U may give 1 to 999999 as the limit.

regards,

amit m.

Former Member — Wed, 20 Dec 2006 05:08:49 GMT

Try to use the function module GUI_UPLOAD. Your internal table and excel file have to be of the same structure to use this function module.

Former Member — Wed, 20 Dec 2006 05:10:27 GMT

Yes, it is mandatory to give start and end of columns & rows.

former_member508729 — Wed, 20 Dec 2006 05:11:20 GMT

HI ,

YOu can use FM TEXT_CONVERT_XLS_TO_SAP.

regards

Ashutosh

PS: reward points if helpful

jayanthi_jayaraman — Wed, 20 Dec 2006 05:11:31 GMT

Hi,

give the end of row as 99999(some large no).

Former Member — Wed, 20 Dec 2006 05:19:10 GMT

How to go to second sheet of same excel file?

Thanks in advance.

jayanthi_jayaraman — Wed, 20 Dec 2006 05:20:57 GMT

Hi,

I think you need to OLE if you want to get data from multiple sheets.

Check these links.