Knowledge Management

Question:
I've searched and seached SAPFANs for the subject - uploading EXCEL files into an ABAP program. There's a lot of postings relating to the subject. Most of it is very confusing to an inexperienced OLE programmer. Please, can someone please provide some usable info and/or sample code to upload an EXCEL file into an ABAP, capturing all cells (hidden or otherwise).
I'm already using ALSM_EXCEL_TO_INTERNAL_TABLE, but it has some limitiations.
Thank You in advance.
Answer:
go to this link to see sample code, if you want to upload file from foreground:
http://sap.ittoolbox.com/code/d.asp?d=3126&a=s

upload from background:
save file as text file
use "OPEN DATASET", "READ DATASET" and "CLOSE DATASET".....
Answer:
the mentioned Function Module utilizes OLE2 as I recall to actually read the file...what 'limitations' are a problem?
_________________
D.
Answer:
Hi Folks,
We are using 4.0 version which don't have ALSM_EXCEL_TO_INTERNAL_TABLE function modufle. I use KCD_EXCEL_OLE_TO_INT_CONVERT which works .However I have an issue since it can't import data more than 32Chars width.Is there any alternative to this function module or workaround?
SGM