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

[Bryan Hessey]

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

Hi,

Not sure if this is pointer, but the comment "You cannot actually create XML files in Excel." is at http://aspalliance.com/616_Editing_X...icrosoft_Excel
Another site that may be of interest to you is http://support.microsoft.com/kb/319180 - not directly related to your question, but may hold a few helpful pointers.

Are you using Excel 2007 ?

---