Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting XML data (encoding question)
http://office.microsoft.com/en-us/ex...063961033.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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting XML data (encoding question)
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. "Ramil" wrote: http://office.microsoft.com/en-us/ex...063961033.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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
encoding | Excel Discussion (Misc queries) | |||
xls, txt encoding | Excel Discussion (Misc queries) | |||
UTF-8 encoding CSV | Excel Discussion (Misc queries) | |||
Another question about exporting charts | Excel Programming | |||
Exporting Data Question | Excel Programming |