Application Development 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: 

Parse XLS from binary data

former_member1033672
Participant

‎08-18-2011 10:59 AM

0 Kudos

Hi,

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.

thanks for help.

1 REPLY 1

Former Member

‎08-18-2011 12:50 PM

0 Kudos

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.