topic Re: Excel Sheet format in Application Development and Automation Discussions

Excel Sheet format

Former Member — Sat, 26 May 2007 03:29:28 GMT

Hi,

I need to download internal table data into application server in excel sheet format

how do i do it ?

can anybody help me regarding this issue.

Thanks

Sudha

Re: Excel Sheet format

amit_khare — Sat, 26 May 2007 03:31:13 GMT

use open dataset and directly put the extension as .XLS

Check the links -

Regards,

Amit

Reward all helpful replies.

Re: Excel Sheet format

Former Member — Sat, 26 May 2007 03:51:47 GMT

Hi,

Go through the following code

DATA FNAME(60) VALUE 'myfile'. " File name of applicationserver

TYPES: BEGIN OF TY_ITAB,

matnr TYPE matnr.

TYPES: END OF OF TY_ITAB

DATA : ITAB TYPE TABLE OF TY_ITAB.

DATA : WA LIKE LINE OF ITAB.

*Populate ITAB as per ur requirement

OPEN DATASET FNAME FOR OUTPUT IN TEXT MODE.

LOOP AT ITAB INTO WA.

TRANSFER WA TO FNAME.

ENDLOOP.

CLOSE DATASET FNAME.

Reward if useful.

thanks

Aneesh.

Re: Excel Sheet format

Former Member — Sat, 26 May 2007 04:19:05 GMT

I have done by using Open dataset but i had bad experience,it will have all junk data while downloading from internal table to xl file in application server.

so try to use below one and you will get good results

Try using FM MS_EXCEL_OLE_STANDARD_DAT there is a field in it FILE_NAME LIKE RLGRAP-FILENAME. Give the desired path of the application server. This will save your excel file on the server.

Now read that file again using another function module given above.

Reward Points if it is helpful

Thanks

Seshu

Re: Excel Sheet format

Former Member — Sat, 26 May 2007 04:38:06 GMT

Hi,

also , i need to give the extension as '.csv' in application server path .

if i use open data set and give the extension as .csv will i able download it into excel

Thanks

Sudha

Re: Excel Sheet format

Former Member — Sat, 26 May 2007 04:39:29 GMT

it should be and try it .

i belive it should work

Reward Points if it is helpful

Thanks

Seshu

Re: Excel Sheet format

amit_khare — Sat, 26 May 2007 04:40:29 GMT

No if you give the extension as .CSV it will not save in excel format but will be comma delimited format.

But this file can be easily open in excel.

Regards,

Amit

Reward all helpful replies.