Excel data export

[tomaszdurka]

Hi all,

I need to save data from XLS format as XML.

I need to keep all text formatting and foreign characters.

It all looks fine when opening exported XML file with Excel. However when it's opened in text editor all foreign chars are read incorrectly. I guess that's because Excel sets encoding for each cell separately.

Is there any way to save as XML file but using UTF-8 encoding?

Or export all foreign characters as HTML entities somehow?

Or last solution - can anyone explain how the separate encoding is stored? I found something like x:charset=238. Is this some track?

Thanks,

Tomasz