OPEN DATASET issues ,while creating excel file with internal table that has special characters

[Former Member]

Hi All,

I have used OPEN DATASET gv_fname FOR OUTPUT IN TEXT MODE ENCODING UTF-8.

for writing my internal table data into excel file however if some fields of my internal table

has special characters in it lets say a field like Item description which might have fields which

contains special character eg: # or '

In those cases the contents of the row is appearing in one cell or in next line, may be

beacause the special character # means tab in excel similarly other characters might

mean something else

How do I handle this issue.

Thanks,

Faiz

[Former Member]

Hi All,

I have used OPEN DATASET gv_fname FOR OUTPUT IN TEXT MODE ENCODING UTF-8.

for writing my internal table data into excel file however if some fields of my internal table

has special characters in it lets say a field like Item description which might have fields which

contains special character eg: # or '

In those cases the contents of the row is appearing in one cell or in next line, may be

beacause the special character # means tab in excel similarly other characters might

mean something else

How do I handle this issue.

Thanks,

Faiz

[rosenberg_eitan]

Hi,

If you want .CSV the follow the rules of csv see :

http://en.wikipedia.org/wiki/Comma-separated_values

http://en.wikipedia.org/wiki/Comma-separated_values#Basic_rules_and_examples

Or use .txt and use tab as separator.

( cl_abap_char_utilities=>horizontal_tab)

Regards.