topic Re: Parse XLS from binary data in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/parse-xls-from-binary-data/m-p/8172069#M1623312 <HTML><HEAD></HEAD><BODY><P>For background, convert your XLS to a .txt (tab-delimited) or comma-separated-values (.csv) file and store on Apps server. You can then import in background with Open dataset....do...read into a line, split on separator into a defined structure, append that structure to internal table. enddo...close dataset.</P></BODY></HTML> Thu, 18 Aug 2011 11:50:58 GMT Former Member 2011-08-18T11:50:58Z Parse XLS from binary data https://community.sap.com/t5/application-development-and-automation-discussions/parse-xls-from-binary-data/m-p/8172068#M1623311 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Im currently facing this task. I have to make FM, which will have binary data of xls on input and i need to parse this. Any idea? I found just moduls which operates with path to xls on frontend. This FM has to work on background.</P><P>thanks for help.</P></BODY></HTML> Thu, 18 Aug 2011 09:59:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/parse-xls-from-binary-data/m-p/8172068#M1623311 Former Member 2011-08-18T09:59:52Z Re: Parse XLS from binary data https://community.sap.com/t5/application-development-and-automation-discussions/parse-xls-from-binary-data/m-p/8172069#M1623312 <HTML><HEAD></HEAD><BODY><P>For background, convert your XLS to a .txt (tab-delimited) or comma-separated-values (.csv) file and store on Apps server. You can then import in background with Open dataset....do...read into a line, split on separator into a defined structure, append that structure to internal table. enddo...close dataset.</P></BODY></HTML> Thu, 18 Aug 2011 11:50:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/parse-xls-from-binary-data/m-p/8172069#M1623312 Former Member 2011-08-18T11:50:58Z