09-08-2008 6:58 AM
hi,
can anyone advice how to upload EXCEL file in Application Server(SAP UNIX server) into a program internal table? can any please provide the source code as well. thanks
09-08-2008 7:13 AM
09-08-2008 7:14 AM
09-08-2008 7:22 AM
try this function module :
TEXT_CONVERT_XLS_TO_SAP.
there is one more,but this uploads values cell by cell and not row by row-
ALSM_EXCEL_TO_INTERNAL_TABLE'
09-08-2008 8:32 AM
hi,
i try use ALSM_EXCEL_TO_INTERNAL_TABLE'. but seems it does not take up from the application server. can you please advice how am i going to do it?
thanks
09-08-2008 7:31 AM
09-08-2008 7:36 AM
09-08-2008 7:40 AM
Hi,
Use DATA SET
OPEN DATASET
READ DATASET
CLOSE DATASET
Example:
open dataset p_file for input in text mode encoding default.
if sy-subrc = 0.
do.
read dataset p_file into ls_input-wa_string.
if sy-subrc eq 0.
append ls_input to lt_input.
else.
exit.
endif.
enddo.
endif.
close dataset p_file.
09-08-2008 7:41 AM
09-08-2008 7:42 AM
hi..
You need to use open dataset and close dataset concepts to load your file on application server.the path where you want to store the file on application server has to be given in the program.