Uploading Excel sheet data into internal table

[Former Member]

Hi All,

I want to upload Excel file data into internal table. My problem is that my excel file having more than one sheets. I want to upload the data of particula Excel sheet..

Please suggest me how can I upload particulat Excel sheet data .

Thanks and regards

Praveen

[rahulkavuri]

check this link

You can check Satish's answer in the above link

<b>Award points if found helpful</b>

[Former Member]

Hi Rahul,

Thanks for your mail.

Actually i have to upload the data using excel sheet name (because my excel file contains more than one sheets ). My intension is to how to Export the data of particular sheet.

For example my excel file contains 3 sheets, Say Data1 sheet , Data2 sheet and Data3 sheet.

Here I want to upload Data1 sheet data only.

Thanks and regards

Praveen

[jayanthi_jayaraman]

Hi,

As suggested by Rich in the link mentioned,use the below code to locate the active excel sheet and then call alsm_excel_to_internal_table fm.

CALL METHOD OF gs_excel 'WorkSheets' = gs_activesheet

EXPORTING #1 = gv_sheet_name.

CALL METHOD OF gs_activesheet 'Activate' .

CALL METHOD OF gs_chart 'Location'

EXPORTING #1 = 2 #2 = gv_sheet_name.

[Former Member]

HI Jayanthi,

Thanks for your reply.

I tried with the code but my problem is not solving .

Some times i need to upload more than one Excel sheets data depend up on requirement How can I identify the Sheet Name before passing to the FM ALSM_EXCEL_TO_INTERNAL_TABLE.

Can you please send me the code.

Thanks and regards

Praveen

[Former Member]

HI Praveen,

Here is the solution, just click on this link.

?

I hope it solves ur problem.

Regards,

Kumar

[Former Member]

Use Function Module:

ALSM_EXCEL_TO_INTERNAL_TABLE.