down load to excel sheet

[Former Member]

friends,

I have a requirement to down load a list which is displayed hierarchially into an excel sheet.

1000

18271218 qiuwiquw

289283 djksdjskd

1001

23232 ssdsdsd

[Former Member]

Hii Abhi,

you can use function 'GUI_DOWNLOAD' to generate excel file to your system.

you need to pass internal table and set other parameters.

Rewards if useful..............

-Maharshi

[Former Member]

i should get first record and the corresponding records of that in other columns and second record and its records and so on in one excel sheet

[Former Member]

All these modifications needs to be done in the interna table itself....and that internal table should be passed in the function module which will download into an excel sheet...

[Former Member]

Hii abhi,

can u explain your req. clearly.

i dont understand, why cant u use 'GUI_DOWNLOAD'.

do you want to have same data in excel file which is in your internal table?

explain your req. in detail.

-Maharshi

[Former Member]

i have used ws_download in my program.

But i got all the fields in one column of the excel sheet and also i should also display data heirarchially.

[Former Member]

check parameters.

and pass it according to your req,

like file name & type

separated by...!!

and atlast pass the formated internal table

and generate file.

reward if helpful

call function 'GUI_DOWNLOAD'

exporting

• BIN_FILESIZE =

filename = txtfile

filetype = 'ASC'

• APPEND = ' '

write_field_separator = 'X'

confirm_overwrite = 'X'

tables

data_tab = it2_oh

.

[Former Member]

Thank u maharshi

[Former Member]

Hi Abhi,

Try this.

Follow menu path

System --> List --> Save --> Local File --> spreadsheet.

Regards,

Mohaiyuddin

[Former Member]

Hi,

declare an internal table with string field.

append header record.

concatenate item record with comma delimiter and append to internal table. hence do the rest.

Use 'GUI_DOWNLOAD' specifing field separator as ',' (comma) and give the output file extension as '.csv'.

You can find header and item data according to ur requirement (in different columns).