Exporting XML data (encoding question)

[Ramil]

http://office.microsoft.com/en-us/excel/HA102063961033.aspx

Exporting XML data
You export XML data by exporting the contents of mapped cells on the
worksheet. When you export data, Excel applies the following rules to
determine what data to save and how to save it:

Empty items are not created when blank cells exist for an optional element, but empty items are created when blank cells exist for a required element.
Unicode Transformation Format-8 (UTF-8) encoding is used to write the data.

This is the snippet of the text found on the link above. I want to be able
to export the data using encoding of the raw data as it was imported into
excel which is "windows-1251". Is there a way around this?

 

[Erik Braten]

Hi,

I'm wondering about the exact same thing. Is it actually so that Excel
forces you to save XML files in UTF-8 encoding?
Even if I try to select some other encoding under "Web Options -> Encoding",
Excel seems to just ignore that.

I'm also wondering why Excel drops the link to XML Schema, but that is
another story.