I think they are the same - but Excel may not???

[David Thielen]

Hi;

This concerns Excel's SpreadsheetML format and how Excel writes it. Excel
saves an xml file as follows:

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<WindwardReports dt:dt="string">Version: 4.0.12</WindwardReports>
</CustomDocumentProperties>
...

While XmlTextWriter (the way I am calling it) creates the following:
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<o:CustomDocumentProperties>
<WindwardReports dt:dt="string">Version: 4.0.12</WindwardReports>
</o:CustomDocumentProperties>
...

Isn't o:CustomDocumentProperties the same thing as CustomDocumentProperties
xmlns="urn:schemas-microsoft-com:office:office"?

And if so, why does Excel include the xmlns, especially as it only does it
for a couple of nodes?

--
thanks - dave

[Kevin Yu [MSFT]]

Hi Dave,

No, they are different. o:CustomDocumentProperties is in the namespace
"urn:schemas-microsoft-com:office:office", while CustomDocumentProperties
is in the default namespace "urn:schemas-microsoft-com:office:spreadsheet".
In Xml, they are completely different.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

[David Thielen]

Does this mean:
<CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<WindwardReports dt:dt="string">Version: 4.0.12</WindwardReports>
</CustomDocumentProperties>

That CustomDocumentProperties is in the default namespace and
WindwardReports is in the namespace urn:schemas-microsoft-com:office:off
because the xmlns="urn:schemas-microsoft-com:office:office" means that is now
the default namespace for any children of CustomDocumentProperties - but not
for CustomDocumentProperties itself?

thanks - dave
--
thanks - dave
"Kevin Yu [MSFT]" wrote:

Hi Dave,

No, they are different. o:CustomDocumentProperties is in the namespace
"urn:schemas-microsoft-com:office:office", while CustomDocumentProperties
is in the default namespace "urn:schemas-microsoft-com:office:spreadsheet".
In Xml, they are completely different.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

[Martin Honnen]

David Thielen wrote:

Does this mean:
<CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<WindwardReports dt:dt="string">Version: 4.0.12</WindwardReports>
</CustomDocumentProperties>

That CustomDocumentProperties is in the default namespace and
WindwardReports is in the namespace urn:schemas-microsoft-com:office:off
because the xmlns="urn:schemas-microsoft-com:office:office" means that is now
the default namespace for any children of CustomDocumentProperties - but not
for CustomDocumentProperties itself?

No, with that markup as above the root element
<CustomDocumentProperties> is in the namespace
urn:schemas-microsoft-com:office:office and its child element
<WindwardReports> is in that namespace as well.

But the whole snippet lacks a binding for the prefix dt so it is not
well-formed XML with namespaces.
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[David Thielen]

Hello;

Either I am totally missing something or your and Kevin's emails contradict
each other. My original question was:

start =====>
This concerns Excel's SpreadsheetML format and how Excel writes it. Excel
saves an xml file as follows:

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<WindwardReports dt:dt="string">Version: 4.0.12</WindwardReports>
</CustomDocumentProperties>
...

While XmlTextWriter (the way I am calling it) creates the following:
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<o:CustomDocumentProperties>
<WindwardReports dt:dt="string">Version: 4.0.12</WindwardReports>
</o:CustomDocumentProperties>
...

Isn't o:CustomDocumentProperties the same thing as CustomDocumentProperties
xmlns="urn:schemas-microsoft-com:office:office"?

And if so, why does Excel include the xmlns, especially as it only does it
for a couple of nodes?
<=====end

Kevin said in the above "o:CustomDocumentProperties is in the namespace
"urn:schemas-microsoft-com:office:office", while CustomDocumentProperties
is in the default namespace "urn:schemas-microsoft-com:office:spreadsheet"."

But I believe you are saying:
<CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
"<CustomDocumentProperties> is in the namespace
urn:schemas-microsoft-com:office:office"

What am I missing here?

--
thanks - dave
"Martin Honnen" wrote:

David Thielen wrote:

Does this mean:
<CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<WindwardReports dt:dt="string">Version: 4.0.12</WindwardReports>
</CustomDocumentProperties>

That CustomDocumentProperties is in the default namespace and
WindwardReports is in the namespace urn:schemas-microsoft-com:office:off
because the xmlns="urn:schemas-microsoft-com:office:office" means that is now
the default namespace for any children of CustomDocumentProperties - but not
for CustomDocumentProperties itself?

No, with that markup as above the root element
<CustomDocumentProperties> is in the namespace
urn:schemas-microsoft-com:office:office and its child element
<WindwardReports> is in that namespace as well.

But the whole snippet lacks a binding for the prefix dt so it is not
well-formed XML with namespaces.
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Martin Honnen]

David Thielen wrote:

This concerns Excel's SpreadsheetML format and how Excel writes it. Excel
saves an xml file as follows:

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
So that <Workbook> element is in the namespace
urn:schemas-microsoft-com:office:spreadsheet.
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
That <CustomDocumentProperties> element is in the namespace
urn:schemas-microsoft-com:office:office.

While XmlTextWriter (the way I am calling it) creates the following:
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
That <Workbook> element is in the namespace
urn:schemas-microsoft-com:office:spreadsheet.
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<o:CustomDocumentProperties>

So that <CustomDocumentProperties> element (or
o:CustomDocumentProperties> element if you want) is in the namespace
urn:schemas-microsoft-com:office:office.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[David Thielen]

Hello;

That is how I interpreted it too. But doesn't that mean that both of the
ways listed are identical? Because in both cases "<CustomDocumentProperties>
element is in the namespace urn:schemas-microsoft-com:office:office"

Or is there a difference between the two approaches?

--
thanks - dave
"Martin Honnen" wrote:

David Thielen wrote:

This concerns Excel's SpreadsheetML format and how Excel writes it. Excel
saves an xml file as follows:

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

So that <Workbook> element is in the namespace
urn:schemas-microsoft-com:office:spreadsheet.

xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">

That <CustomDocumentProperties> element is in the namespace
urn:schemas-microsoft-com:office:office.

While XmlTextWriter (the way I am calling it) creates the following:
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

That <Workbook> element is in the namespace
urn:schemas-microsoft-com:office:spreadsheet.

xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<o:CustomDocumentProperties>

So that <CustomDocumentProperties> element (or
o:CustomDocumentProperties> element if you want) is in the namespace
urn:schemas-microsoft-com:office:office.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Martin Honnen]

David Thielen wrote:

But doesn't that mean that both of the
ways listed are identical? Because in both cases "<CustomDocumentProperties>
element is in the namespace urn:schemas-microsoft-com:office:office"

Yes, the namespace of the elements is the same in both cases. In terms
of XML with namespaces there is no difference. Only if someone wrote a
DTD where namespace support is poor or not existing the DTD might
prescribe to have a certain way.
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[David Thielen]

Thank you very very much.

--
thanks - dave
"Martin Honnen" wrote:

David Thielen wrote:

But doesn't that mean that both of the
ways listed are identical? Because in both cases "<CustomDocumentProperties>
element is in the namespace urn:schemas-microsoft-com:office:office"

Yes, the namespace of the elements is the same in both cases. In terms
of XML with namespaces there is no difference. Only if someone wrote a
DTD where namespace support is poor or not existing the DTD might
prescribe to have a certain way.
--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[David Thielen]

Hi;

I think these are different - but not as discussed. The difference is the
namespace for <WindwardReports as <CustomDocumentProperties
xmlns="urn:schemas-microsoft-com:office:office"> changes the default
namespace assigned to <WindwardReports while <o:CustomDocumentProperties>
does not.

So while CustomDocumentProperties is the same both ways, WindwardReports is
not.

Is that correct?

--
thanks - dave
"David Thielen" wrote:

Hi;

This concerns Excel's SpreadsheetML format and how Excel writes it. Excel
saves an xml file as follows:

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<WindwardReports dt:dt="string">Version: 4.0.12</WindwardReports>
</CustomDocumentProperties>
...

While XmlTextWriter (the way I am calling it) creates the following:
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<o:CustomDocumentProperties>
<WindwardReports dt:dt="string">Version: 4.0.12</WindwardReports>
</o:CustomDocumentProperties>
...

Isn't o:CustomDocumentProperties the same thing as CustomDocumentProperties
xmlns="urn:schemas-microsoft-com:office:office"?

And if so, why does Excel include the xmlns, especially as it only does it
for a couple of nodes?

--
thanks - dave