MS Excel Download Error

[Former Member]

Hi Experts,

I am trying to download the HR data ( Internal table records ) into spread sheets using the FM

call function 'GUI_DOWNLOAD'

exporting

filename = file_name

filetype = 'ASC'

append = 'X'

write_field_separator = 'X'

tables

data_tab = itab[].

What happens is , Exact number of records are not downloaded into spread sheet, Always lesser number of records are downloaded into spread sheet. Data too is messed up. Even whild downloading itab data in debugging , Same problem exist.

When I download as text file, The number of records are correct.

Is it generic problem while downloading to MS Excel. Any suggestion as how to download exact number of records.

Can you please help in resolving this issue.

Thanks

- M

[Former Member]

Hi Experts,

I am trying to download the HR data ( Internal table records ) into spread sheets using the FM

call function 'GUI_DOWNLOAD'

exporting

filename = file_name

filetype = 'ASC'

append = 'X'

write_field_separator = 'X'

tables

data_tab = itab[].

What happens is , Exact number of records are not downloaded into spread sheet, Always lesser number of records are downloaded into spread sheet. Data too is messed up. Even whild downloading itab data in debugging , Same problem exist.

When I download as text file, The number of records are correct.

Is it generic problem while downloading to MS Excel. Any suggestion as how to download exact number of records.

Can you please help in resolving this issue.

Thanks

- M

[Former Member]

Hi,

Try this

call function 'GUI_DOWNLOAD'

exporting

filename = file_name

filetype = 'DAT'

tables

data_tab = itab[].

BR,

Lokeswari.

[Former Member]

Hi Lokeshwari,

I have tried this option too downloading as .dat file type, Still downloading lesser number of records with messy data.

Even total number of records is less than 65,000 , There should not be problem in number of records from being dowloaded.

I am using latest version of MS office for downloading .

I appreciate ,if there is a way to resolve this problem.

Thanks

- M -

[mukundkansara]

Hi Try Lokeshwari reply, And if still problem exist then check number of records because in Old version of excel it takes only 65536 number of records.

[Former Member]

Dear Techies,

Solved it. Do you know why, it is all because of a record having a special character combination "_ as the value for one of the character fields in a info type.

before solved , While trying to download , data was messed up , Signicant number of records were missing.

Thanks friends for replies

- MK -