topic Re: Uploading Excel sheet data into internal table in Application Development and Automation Discussions

Uploading Excel sheet data into internal table

Former Member — Wed, 27 Dec 2006 13:03:17 GMT

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

Re: Uploading Excel sheet data into internal table

rahulkavuri — Wed, 27 Dec 2006 13:08:40 GMT

check this link

You can check Satish's answer in the above link

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

Re: Uploading Excel sheet data into internal table

Former Member — Wed, 27 Dec 2006 13:15:43 GMT

HI Praveen,

Here is the solution, just click on this link.

I hope it solves ur problem.

Regards,

Kumar

Re: Uploading Excel sheet data into internal table

Former Member — Thu, 28 Dec 2006 11:22:36 GMT

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

Re: Uploading Excel sheet data into internal table

jayanthi_jayaraman — Thu, 28 Dec 2006 11:49:33 GMT

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.

Re: Uploading Excel sheet data into internal table

Former Member — Thu, 28 Dec 2006 13:36:02 GMT

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

Re: Uploading Excel sheet data into internal table

Former Member — Thu, 28 Dec 2006 16:43:38 GMT

Use Function Module:

ALSM_EXCEL_TO_INTERNAL_TABLE.