HR Master data download error

Dear all,

I am trying to download HR Master data using FM gui_download.

In case of downaloading all staff data, I am getting incorrect no

of records in xls file though no of records internal table is accurate.

Also some of the records values are corrupt or incorrupt values.

As analysed , when any value in a record ends with '#' as mentioned below, It is already considered as TAB separtion,thus

ends with incorrect values in certain records

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = fname

filetype = 'ASC'

WRITE_FIELD_SEPARATOR = 'X'

TABLES

DATA_TAB = table.

When I try with ' '( space ) as the separator in this FM , number of records are correct ,but not spread across in respective columns. I need to download in xls file with tab separation....

I appreciate your suggestion on this ....

Thanks

- MK