Howto export columns with '#', '$' to XLS?

Question

Hello Team!

I've got an empty file when I export to Excel datasoure like next:

select 1 as my_col#, 's' as my_col$ from dual;

And all is ok if I replace column names with

'my_col_nr', 'my_col_tx'

Are these chars unsupported?

Best regards, Andrew

Accepted Answer

0	Hi Andrew, Unfortunately, these characters are not supported currently. In fact, a column name which is not a valid XML element name is not supported. Regards, Ibrahim link answered 12 Feb '15, 10:52 Ibrahim Sand... ♦♦ 1.5k●5 accept rate: 25%