topic Re: Upload Excel File in Application Development and Automation Discussions

Upload Excel File

Former Member — Mon, 03 Mar 2014 04:28:03 GMT

Hi Expert.

I need to Upload Excel file on Application server. So I can Use fm GUI_DOWNLOAD but by using this function module i got Error

'Access Denied'. Please help me....

Said Answer is with Example.

My Step : 1 ) Read all data from Database table in Internal table.

2) Try to Upload File to Application server Like

P_L_FILENAME = application server parth.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = P_L_FILENAME

FILETYPE = 'DAT'

APPEND = P_L_APPEND

WRITE_FIELD_SEPARATOR = 'X'

TABLES

DATA_TAB = P_I_DATATAB

EXCEPTIONS

FILE_WRITE_ERROR = 1

NO_BATCH = 2

GUI_REFUSE_FILETRANSFER = 3

INVALID_TYPE = 4

NO_AUTHORITY = 5

UNKNOWN_ERROR = 6

HEADER_NOT_ALLOWED = 7

SEPARATOR_NOT_ALLOWED = 8

FILESIZE_NOT_ALLOWED = 9

HEADER_TOO_LONG = 10

DP_ERROR_CREATE = 11

DP_ERROR_SEND = 12

DP_ERROR_WRITE = 13

UNKNOWN_DP_ERROR = 14

ACCESS_DENIED = 15

DP_OUT_OF_MEMORY = 16

DISK_FULL = 17

DP_TIMEOUT = 18

FILE_NOT_FOUND = 19

DATAPROVIDER_EXCEPTION = 20

CONTROL_FLUSH_ERROR = 21

OTHERS = 22.

IF SY-SUBRC NE 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Thanks & Regards.

Pradip Patel.

Re: Upload Excel File

former_member226419 — Mon, 03 Mar 2014 04:32:58 GMT

Hi,

Perhaps you don't have authorization to access and write a file to the presentation server directory.

Sumeet

Re: Upload Excel File

Former Member — Mon, 03 Mar 2014 04:58:49 GMT

Hi Sumeet.

Thanks for Reply. I know I have not authorization for Upload File. But I want to Upload.

Now at Development stage I have map network and upload file to Application server.

But I will not map All user local to to SAP Production Server when my Project Live.

anybody answer ?

Thanks.

Pradip Patel.

Re: Upload Excel File

nabheetscn — Mon, 03 Mar 2014 05:04:13 GMT

Hi Pradip

In case you want to write file to application server then you should use Open/Close dataset. GUI_DOWNLOAD is for presentation server.

Nabheet

Re: Upload Excel File

ThangaPrakash — Mon, 03 Mar 2014 05:04:24 GMT

Hello Sumeet,

GUI_DOWNLOAD is to Download an Internal Table to the PC.

You have to use OPEN DATASET, TRANSFER and CLOSE DATASET to create files in the application server.

Regards,

Thanga

Re: Upload Excel File

ThangaPrakash — Mon, 03 Mar 2014 05:08:00 GMT

Hello Pradip,

Use like below.

*- Open the files in Application server

OPEN DATASET p_afile FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

*Move the Internal table data to the file

LOOP AT itab INTO str.

TRANSFER str TO p_afile.

ENDLOOP.

*- Close the Opened File in the Application Server

CLOSE DATASET p_afile.

Regards,

Thanga

Re: Upload Excel File

mayur_priyan — Mon, 03 Mar 2014 05:08:08 GMT

Hi,

I need to Upload Excel file on Application server. So I can Use fm GUI_DOWNLOAD but by using this function module i got Error

'Access Denied'. Please help me...

GUI_DOWNLOAD is used to download the Data of an internal table to LOCAL File on to the Presentation server.

Inorder to update the internal table values on to the Application server you need to use OPEN DATASET statement.

Regards,

Mayur Priyan. S

Re: Upload Excel File

ThangaPrakash — Mon, 03 Mar 2014 05:11:20 GMT

There are plenty of posts available in SCN regarding this. Also refer to the below link

Upload Internal table to Application Server and Presntation Server - Contributor Corner - SCN Wiki

Regards,

Thanga

Re: Upload Excel File

Former Member — Mon, 03 Mar 2014 05:13:54 GMT

hello Thanga.

Thanks for Reply.

Please tell me the Type of str.

data : str type ????????

Thanks.

Pradip Patel.

Re: Upload Excel File

Former Member — Mon, 03 Mar 2014 05:14:42 GMT

Hi Pradip,

First of all you have to Upload your file from PC to Internal table in your report using GUI_UPLOAD.

After you get the records in your internal table use

1) OPEN DATASET <Application filepath> FOR OUTPUT IN TEXT MODE ENCODING <Code page>

2) Then use TRANSFER to transfer records from Internal table to application server.

3) CLOSE DATASET.

Thanks & Regards

Akshay

Re: Upload Excel File

mayur_priyan — Mon, 03 Mar 2014 05:18:39 GMT

here 'str' refers to the work area of the internal table itab.

Re: Upload Excel File

ThangaPrakash — Mon, 03 Mar 2014 05:22:49 GMT

str should be of the type as like the itab.

Regards,

Thanga

Re: Upload Excel File

Former Member — Mon, 03 Mar 2014 06:19:26 GMT

U can try FM TEXT_CONVERT_XLS_TO_SAP...

Re: Upload Excel File

Former Member — Mon, 03 Mar 2014 06:37:08 GMT

hI Thanga.

Thanks for Reply. Problem Solve....

thanks.

Pradip Patel.

Re: Upload Excel File

ThangaPrakash — Mon, 03 Mar 2014 06:53:52 GMT

Hello Pradip,

You are welcome

Please raise a discussion in SCN whenever any help required.

Regards,

Thanga