Question:
Hi all,
I am developing a BSP where in I have a functionality with which users can upload a excel file . I have to get the contents into a internal table and processs the data.
I' using the method get_data method of the interface IF_HTTP_ENTITY . It gives me the data in binary format. How can I convert this binary data
into an internal table so that I can proces those entries?
Regards,
Siva
_________________
M.Ramesh,
SAP Consultant,
Mountain view,Ca-94085
Answer:
Spreadsheets are too complicated (data is unpredictable) for this sort of operation. i.e. the data can be in different worksheets etc.
Perhaps you'd be better off by getting the user to save the data in the spreadsheet as a CSV file and uploading that. CSV files are easier [possible] to process just by looping at the ITAB and performing a SPLIT at the comma... (be careful with this ABAP function)
_________________
Rgds,
Derek
_________________
For formal [onsite | telephone | IM | email] support on SAP Business Connector and ITS, please contact me directly