upload EXCEL from Application server

[Former Member]

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

[Mohamed_Mukhtar]

hi ,

[Go through this link|]

Regards,.

[Former Member]

Hi,

I found the below sample code....

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/how-to-create-excel-file-xls-on-sap-app...

Regrads

Guru

[Former Member]

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'

[Former Member]

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

[kesavadas_thekkillath]

Use dataset concepts.

[Former Member]

Hi Ben,

Check this one for sample code:

Regards,

Chandra Sekhar

[Former Member]

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.

[Former Member]

Use Transaction code CG3Z

[Former Member]

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.