Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Function module to get all sheets info from excel file

Former Member

‎2010 Feb 25 11:06 AM

0 Likes
382

Hi All,

I have an excel file with 10 sheets in it. Is there any FM / Method to get all the sheets data at a time into internal table? I donu2019t want to keep loop on a FM / method for number of work sheets, I want the complete data of my excel sheet at a time into internal table.

Thanks in advance.

Regards

Basavaraj

Hi All,

I have an excel file with 10 sheets in it. Is there any FM / Method to get all the sheets data at a time into internal table? I donu2019t want to keep loop on a FM / method for number of work sheets, I want the complete data of my excel sheet at a time into internal table.

Thanks in advance.

Regards

Basavaraj

Reply
1 REPLY 1
Read only

Former Member

‎2010 Feb 25 11:42 AM

0 Likes
322

hi,

go through the FM in the link

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/36f08758-0a01-0010-c291-c03...

hope it will solve ur problem

thanks