topic Re: down load to excel sheet in Application Development and Automation Discussions

down load to excel sheet

Former Member — Tue, 15 Jan 2008 04:50:17 GMT

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

Re: down load to excel sheet

Former Member — Tue, 15 Jan 2008 05:32:44 GMT

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

Re: down load to excel sheet

Former Member — Tue, 15 Jan 2008 05:35:10 GMT

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

Re: down load to excel sheet

Former Member — Tue, 15 Jan 2008 05:42:15 GMT

Hi Abhi,

Try this.

Follow menu path

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

Regards,

Mohaiyuddin

Re: down load to excel sheet

Former Member — Tue, 15 Jan 2008 05:42:38 GMT

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...

Re: down load to excel sheet

Former Member — Tue, 15 Jan 2008 06:03:45 GMT

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

Re: down load to excel sheet

Former Member — Tue, 15 Jan 2008 06:08:57 GMT

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.

Re: down load to excel sheet

Former Member — Tue, 15 Jan 2008 06:10:57 GMT

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).

Re: down load to excel sheet

Former Member — Tue, 15 Jan 2008 06:18:19 GMT

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

Re: down load to excel sheet

Former Member — Tue, 15 Jan 2008 06:35:27 GMT

Thank u maharshi