topic Re: Function module to get all sheets info from excel file in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-get-all-sheets-info-from-excel-file/m-p/6687752#M1450532 <HTML><HEAD></HEAD><BODY><P>hi, </P><P>go through the FM in the link</P><P><A href="https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/36f08758-0a01-0010-c291-c03004aeb1af" target="test_blank">https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/36f08758-0a01-0010-c291-c03004aeb1af</A></P><P>hope it will solve ur problem</P><P>thanks</P></BODY></HTML> Thu, 25 Feb 2010 11:42:03 GMT Former Member 2010-02-25T11:42:03Z Function module to get all sheets info from excel file https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-get-all-sheets-info-from-excel-file/m-p/6687751#M1450531 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P>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.</P><P></P><P> </P><P>Thanks in advance.</P><P></P><P>Regards</P><P>Basavaraj</P></BODY></HTML> Thu, 25 Feb 2010 11:06:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-get-all-sheets-info-from-excel-file/m-p/6687751#M1450531 Former Member 2010-02-25T11:06:38Z Re: Function module to get all sheets info from excel file https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-get-all-sheets-info-from-excel-file/m-p/6687752#M1450532 <HTML><HEAD></HEAD><BODY><P>hi, </P><P>go through the FM in the link</P><P><A href="https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/36f08758-0a01-0010-c291-c03004aeb1af" target="test_blank">https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/36f08758-0a01-0010-c291-c03004aeb1af</A></P><P>hope it will solve ur problem</P><P>thanks</P></BODY></HTML> Thu, 25 Feb 2010 11:42:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/function-module-to-get-all-sheets-info-from-excel-file/m-p/6687752#M1450532 Former Member 2010-02-25T11:42:03Z