topic down load into excel file in Application Development and Automation Discussions

down load into excel file

Former Member — Wed, 28 Mar 2007 09:54:06 GMT

Hi gurus,

I wanna generate a report that should download the data from the internal table to the presentation server in word formart, but the length of the word file should not be greater than 156 characters as the downloaded data is sent to RBI.

Thanks and Regards,

Alson.

Re: down load into excel file

Former Member — Wed, 28 Mar 2007 09:59:03 GMT

Hi,

In a report once you generate and ALV output, you can alwys download it to EXCEL file or WORD file from the button available there...

but this is done only if u use ALV output.

<b>

Reward points for helpful answer,</b>

Regards,

Tejas

Re: down load into excel file

Former Member — Wed, 28 Mar 2007 10:09:33 GMT

hi teja,

thanks for the reply.i know that v can download from ALV output. But the length of the file in word documnt should not exceed 156 character each line.

tell me is it possible bcz as i mentioned earlier the word document will be sent to RBI format.

Regards,

Alson

Re: down load into excel file

Former Member — Wed, 28 Mar 2007 10:13:22 GMT

Hi,

I think u can do it by populating the data into ur internal table ina string of length 156. Append the whole data to th eitab, and then use this for downlaoding purpose.

sudha

Re: down load into excel file

Former Member — Wed, 28 Mar 2007 11:16:13 GMT

Hi Alson,

you can wrap the text to a length of 156 chars using the function module:-

CALL FUNCTION 'RKD_WORD_WRAP'

for eg if u have any variable v_text which is 1000 chars long then u can give the outputlen = 100. This way u can split 1000 chars into 1000/100 = 10 rows. you can either store these lines in an internal table or it is also possible to store these as separate variables each of length 100 chars .

you can refer to the following code:-

CALL FUNCTION 'RKD_WORD_WRAP'

EXPORTING

textline = v_text

DELIMITER = ' '

outputlen = 156

TABLES

out_lines = i_long_text

EXCEPTIONS

outputlen_too_large = 1

OTHERS = 2.

Plz reward points if useful.

Thanks

Rahul

Re: down load into excel file

Former Member — Wed, 28 Mar 2007 11:29:55 GMT

Hi..,

hope it helps u...

you can use ole object and have a referrence to the following code：

DATA: L_COLUMN TYPE OLE2_OBJECT, " COLUMN OBJECT

L_FONT TYPE OLE2_OBJECT. " FONT OBJECT

L_COLUMN = 1.

set column properties

CALL METHOD OF V_EXCEL 'Columns' = L_COLUMN

EXPORTING

#1 = L_SERIAL.

PERFORM FRM_ERR_HDL.

SET PROPERTY OF L_COLUMN 'ColumnWidth' = L_WIDTH.