EXCEL NOt generating properly on FTP

[Former Member]

Hi All,

I am facing a problem in file creation on FTP.

The problem is .xls file is getting created but the data inside the file is not in the excel format its in text lines....

Iam Using FM

CALL FUNCTION 'FTP_R3_TO_SERVER'

EXPORTING

handle = hdl

fname = w_remfile

character_mode = 'X'

• blob_length = blob_length

TABLES

text = itab

EXCEPTIONS

tcpip_error = 1

command_error = 2

data_error = 3

OTHERS = 4.

IF sy-subrc = 0.

ENDIF.

PlZ Help

[Former Member]

But How can i Use this FM to create a file on FTP server????

[Former Member]

someone plz reply!!!!!!!

[Shabarish_Nair]

Bhatt,

this is a forum for PI. I guess for your requirement you could post the query in the ABAP forum to get better and faster replies.

[Former Member]

So What shoul be the solution for this ???

If you have Kindly provide...

[former_member192295]

Hi,

Current using function don't have that option,I think we can sortout your problem with WS_DOWNLOAD function also, please cehck with below link

http://www.sap-basis-abap.com/sapac011.htm

[former_member192295]

Hi,

I think the problem is due to space betwen columns. Between two columns Tab space should be there else we can't get proper format in xls file. Currently you are getting all columns data into one single column in xls file due to above problem.