topic Re: Uploading Excel from Application Server in Application Development and Automation Discussions

Uploading Excel from Application Server

pintoo_d — Wed, 24 Dec 2008 13:57:55 GMT

Hi Experts,

Wishing you Mery X-mas and happy new year.

I have a question. I have to upload XLS file from AS to SAP Sytem. Its not working fine.

I use TXT and it works perfect.

I am trying to use read dataset to read data in both cases.

Does it mean that AS doesnt support uploading file in XLS format or is there any other way to do it?

I hv tried alot and then asking you all for your support.

Thank You,

Temesh

Re: Uploading Excel from Application Server

Former Member — Wed, 24 Dec 2008 14:04:39 GMT

Hi,

please use function module TEXT_CONVERT_XLS_TO_SAP, ordinary GUI_UPLOAD does not work fine.

Regards,

Prosenjit.

Re: Uploading Excel from Application Server

pintoo_d — Wed, 24 Dec 2008 14:25:14 GMT

U mean from Application Server ?

i tried TEXT_CONVERT_XLS_TO_SAP, no data is been copied to internal table.

Re: Uploading Excel from Application Server

Former Member — Wed, 24 Dec 2008 14:29:05 GMT

Use Tcode CG3Y and CG3Z for uploading download from AS.

Re: Uploading Excel from Application Server

pintoo_d — Wed, 24 Dec 2008 14:36:35 GMT

Well. this is my requirement.

I need to upload data from AS to SAP System by calling BAPI.

that excel has multiple records which i need to map to individual bapi structure.

so i guess T-code is ruled out for that.

any other suggestions ??

Re: Uploading Excel from Application Server

Former Member — Wed, 24 Dec 2008 14:40:59 GMT

AS to SAP System

Than it depends on which kind of Data you want to upload.There are so many BAPI we have which works for Different-2 Purpose.

But Before calling BAPI you must take data into internal table,With open data set for input/output commands.

Re: Uploading Excel from Application Server

pintoo_d — Wed, 24 Dec 2008 14:51:57 GMT

I will b using BAPI_MATERIAL_SAVEDATA to upload into SAP System.

Fields are frm MARA, MARC, MARD, MVKE, MBEW.

Excel file has almost 40 records which needs to be uploaded.

I tried reading dataset and mapping to custom defined types structure for every record in excel.

but it doesnt have those records after execution.

same data in text works fine for me with tab delimited spaces.

so i m not sure what could be done. Some explained that excel might not work frm AS. so they advised me to make use of TXT, but i hv to give a shot wth XLS.

Re: Uploading Excel from Application Server

Former Member — Wed, 24 Dec 2008 17:25:41 GMT

Hi,

data extract from excel and text file is different ..

why is the option of text file ruled out in your case when you say that its working fine ?Why is excel option preferred .

//I tried reading dataset and mapping to custom defined types structure for every record in excel.

but it doesnt have those records after execution.

How is data from excel in AS being fetched ,,i dont think its possible ..

Vijay

Re: Uploading Excel from Application Server

Former Member — Wed, 24 Dec 2008 18:10:57 GMT

use this method. just mention the source and destination file paths.


DATA : p_source TYPE string,
           p_dest TYPE string. 

CALL METHOD cl_gui_frontend_services=>file_copy
  EXPORTING
    SOURCE               = p_source
    destination           = p_dest
    overwrite             = SPACE
    .