Downloading internal table data into excel sheet.

[Former Member]

Hi All,

I want to download internal table data into excel sheet as it is. For that i am using 'GUI_DOWNLOAD'. This is creating a file at the specified location but the problem is that all the data is coming into one column where as my internal table has 18 different columns. So accordingly i want the data in the excel sheet in the 18 different columns. So please guide me how this can be achieved.

[Former Member]

Hi All,

I want to download internal table data into excel sheet as it is. For that i am using 'GUI_DOWNLOAD'. This is creating a file at the specified location but the problem is that all the data is coming into one column where as my internal table has 18 different columns. So accordingly i want the data in the excel sheet in the 18 different columns. So please guide me how this can be achieved.

[Former Member]

hi,

check this parameter in the func module.

FILETYPE = 'DBF'.

[Former Member]

To Pass value 'X' to write_field_separator.

Edited by: Arunachalam, Selvapandian on Jan 3, 2008 3:39 PM

[Former Member]

Hiiiiiiiiiiiiiii,

make field_separator indicator in fm "gui_download" as 'x'.

Edited by: nakul agarwal on Jan 3, 2008 11:12 AM

[Former Member]

hi,

Though this function module downloads the contents onto the Excel sheet, there cannot be any column headings or we cannot differentiate the primary keys just by seeing the Excel sheet. For this purpose, we can use the function module XXL_FULL_API. The Excel sheet which is generated by this function module contains the column heading

Hope this is helpful, Do reward.