topic Re: upload EXCEL from Application server in Application Development and Automation Discussions

upload EXCEL from Application server

Former Member — Mon, 08 Sep 2008 05:58:33 GMT

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

Re: upload EXCEL from Application server

Mohamed_Mukhtar — Mon, 08 Sep 2008 06:13:18 GMT

hi ,

[Go through this link|]

Regards,.

Re: upload EXCEL from Application server

Former Member — Mon, 08 Sep 2008 06:14:10 GMT

Hi,

I found the below sample code....

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/how-to-create-excel-file-xls-on-sap-application-server-using-open-dataset-command-708779

Regrads

Guru

Re: upload EXCEL from Application server

Former Member — Mon, 08 Sep 2008 06:22:21 GMT

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'

Re: upload EXCEL from Application server

kesavadas_thekkillath — Mon, 08 Sep 2008 06:31:12 GMT

Use dataset concepts.

Re: upload EXCEL from Application server

Former Member — Mon, 08 Sep 2008 06:36:44 GMT

Hi Ben,

Check this one for sample code:

Regards,

Chandra Sekhar

Re: upload EXCEL from Application server

Former Member — Mon, 08 Sep 2008 06:40:46 GMT

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.

Re: upload EXCEL from Application server

Former Member — Mon, 08 Sep 2008 06:41:46 GMT

Use Transaction code CG3Z

Re: upload EXCEL from Application server

Former Member — Mon, 08 Sep 2008 06:42:10 GMT

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.

Re: upload EXCEL from Application server

Former Member — Mon, 08 Sep 2008 07:32:18 GMT

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