how to write this out using xmlwriter

[=?Utf-8?B?UGF1bA==?=]

Hi I have a .net application and am using the xml writer class to create an
xml file that opens as an excel file. I am trying to write out the following
but am having difficulty.
<Row>
<Cell ss:StyleID="s87 ">
<ss:Data ss: Type = "String">
<Font html:Color="#FF 0000">M90</Font>
<Font>/Thu</Font>
</ss:Data>
</Cell>
This produces a cell with text with part of the text being red the M90 and
the other part being black.
I also have the following strings set up in my code
string spreadsheetName space = "urn:schema s-microsoft-com:office:spre adsheet";
string officeNamespace = "urn:schema s-microsoft-com:office:offi ce";
string excelNamespace = "urn:schema s-microsoft-com:office:exce l";
string htmlNamespace = "http://www.w3.org/TR/REC-html40";

thanks.
--
Paul G
Software engineer.

[Martin Honnen]

Paul wrote:

Hi I have a .net application and am using the xml writer class to create an
xml file that opens as an excel file. I am trying to write out the following
but am having difficulty.
<Row>
<Cell ss:StyleID="s87 ">
<ss:Data ss: Type = "String">
<Font html:Color="#FF 0000">M90</Font>
<Font>/Thu</Font>
</ss:Data>
</Cell>
This produces a cell with text with part of the text being red the M90 and
the other part being black.
I also have the following strings set up in my code
string spreadsheetName space = "urn:schema s-microsoft-com:office:spre adsheet";
string officeNamespace = "urn:schema s-microsoft-com:office:offi ce";
string excelNamespace = "urn:schema s-microsoft-com:office:exce l";
string htmlNamespace = "http://www.w3.org/TR/REC-html40";

We need to know whether those elements (e.g. Row, Cell) are in a
namespace and which namespace URI that namespace has. And we need to
know which namespace URI the prefix ss is bound to.

--

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

[=?Utf-8?B?UGF1bA==?=]

Hi thanks for the response. When I write out the row I am using the following,
WriteStartEleme nt("Row");
WriteAttributeS tring("ss","Aut ofitHeight","Sp readsheetNamesp ace","0");
followed by other write statements for cells/data and closing tags.
So I am using the SpreadsheetName space for both rows and cells.
The SpreadsheetName space I have defined as
"urn:schema s-microsoft-com:office:spar eadsheet". I am using the "ss" prefix
whenever the SpreadsheetName space is used like in the WriteAttributeS tring
above. I am kind of new to xml but was trying to bind it to
urn:schemas-microsoft-com:office:spre adsheet. Do I need an additional line
of code to do this or is it implied by how I am using it?
Thanks again Paul.
--
Paul G
Software engineer.
"Martin Honnen" wrote:

Paul wrote:

Hi I have a .net application and am using the xml writer class to create an
xml file that opens as an excel file. I am trying to write out the following
but am having difficulty.
<Row>
<Cell ss:StyleID="s87 ">
<ss:Data ss: Type = "String">
<Font html:Color="#FF 0000">M90</Font>
<Font>/Thu</Font>
</ss:Data>
</Cell>
This produces a cell with text with part of the text being red the M90 and
the other part being black.
I also have the following strings set up in my code
string spreadsheetName space = "urn:schema s-microsoft-com:office:spre adsheet";
string officeNamespace = "urn:schema s-microsoft-com:office:offi ce";
string excelNamespace = "urn:schema s-microsoft-com:office:exce l";
string htmlNamespace = "http://www.w3.org/TR/REC-html40";

We need to know whether those elements (e.g. Row, Cell) are in a
namespace and which namespace URI that namespace has. And we need to
know which namespace URI the prefix ss is bound to.

--

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

[=?Utf-8?B?UGF1bA==?=]

Also I am using a namespace when i write out the string attribute for the
cells and rows. I am using the WriteStartEleme nt as described above to write
out the start tags for rows and cells. Thanks Paul.
--
Paul G
Software engineer.
"Paul" wrote:

Hi thanks for the response. When I write out the row I am using the following,
WriteStartEleme nt("Row");
WriteAttributeS tring("ss","Aut ofitHeight","Sp readsheetNamesp ace","0");
followed by other write statements for cells/data and closing tags.
So I am using the SpreadsheetName space for both rows and cells.
The SpreadsheetName space I have defined as
"urn:schema s-microsoft-com:office:spar eadsheet". I am using the "ss" prefix
whenever the SpreadsheetName space is used like in the WriteAttributeS tring
above. I am kind of new to xml but was trying to bind it to
urn:schemas-microsoft-com:office:spre adsheet. Do I need an additional line
of code to do this or is it implied by how I am using it?
Thanks again Paul.
--
Paul G
Software engineer.
"Martin Honnen" wrote:

Paul wrote:

Hi I have a .net application and am using the xml writer class to create an
xml file that opens as an excel file. I am trying to write out the following
but am having difficulty.
<Row>
<Cell ss:StyleID="s87 ">
<ss:Data ss: Type = "String">
<Font html:Color="#FF 0000">M90</Font>
<Font>/Thu</Font>
</ss:Data>
</Cell>
This produces a cell with text with part of the text being red the M90 and
the other part being black.
I also have the following strings set up in my code
string spreadsheetName space = "urn:schema s-microsoft-com:office:spre adsheet";
string officeNamespace = "urn:schema s-microsoft-com:office:offi ce";
string excelNamespace = "urn:schema s-microsoft-com:office:exce l";
string htmlNamespace = "http://www.w3.org/TR/REC-html40";

We need to know whether those elements (e.g. Row, Cell) are in a
namespace and which namespace URI that namespace has. And we need to
know which namespace URI the prefix ss is bound to.

--

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

[=?Utf-8?B?UGF1bA==?=]

Also under the Workbook I have the following
xmlns:ss = urn:schemas-microsoft-com:office:spre adsheet

--
Paul G
Software engineer.
"Paul" wrote:

Also I am using a namespace when i write out the string attribute for the
cells and rows. I am using the WriteStartEleme nt as described above to write
out the start tags for rows and cells. Thanks Paul.
--
Paul G
Software engineer.
"Paul" wrote:

Hi thanks for the response. When I write out the row I am using the following,
WriteStartEleme nt("Row");
WriteAttributeS tring("ss","Aut ofitHeight","Sp readsheetNamesp ace","0");
followed by other write statements for cells/data and closing tags.
So I am using the SpreadsheetName space for both rows and cells.
The SpreadsheetName space I have defined as
"urn:schema s-microsoft-com:office:spar eadsheet". I am using the "ss" prefix
whenever the SpreadsheetName space is used like in the WriteAttributeS tring
above. I am kind of new to xml but was trying to bind it to
urn:schemas-microsoft-com:office:spre adsheet. Do I need an additional line
of code to do this or is it implied by how I am using it?
Thanks again Paul.
--
Paul G
Software engineer.
"Martin Honnen" wrote:

Paul wrote:
Hi I have a .net application and am using the xml writer class to create an
xml file that opens as an excel file. I am trying to write out the following
but am having difficulty.
<Row>
<Cell ss:StyleID="s87 ">
<ss:Data ss: Type = "String">
<Font html:Color="#FF 0000">M90</Font>
<Font>/Thu</Font>
</ss:Data>
</Cell>
This produces a cell with text with part of the text being red the M90 and
the other part being black.
I also have the following strings set up in my code
string spreadsheetName space = "urn:schema s-microsoft-com:office:spre adsheet";
string officeNamespace = "urn:schema s-microsoft-com:office:offi ce";
string excelNamespace = "urn:schema s-microsoft-com:office:exce l";
string htmlNamespace = "http://www.w3.org/TR/REC-html40";
>
We need to know whether those elements (e.g. Row, Cell) are in a
namespace and which namespace URI that namespace has. And we need to
know which namespace URI the prefix ss is bound to.
>
--
>
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
>

[=?Utf-8?B?UGF1bA==?=]

additional information, the spreadsheet that I am trying to copy has the
following for the section of interest.
<Cell SS:StyleID="s87 ">
<ss:Data SS:Type="String " xmlns="http://www.w3.org/TR/REC-html40">
<Font html:Color="#FF 0000">M90</Font>
<Font/Thur<Font>
</ss:Data>
</Cell>

--
Paul G
Software engineer.
"Paul" wrote:

Hi I have a .net application and am using the xml writer class to create an
xml file that opens as an excel file. I am trying to write out the following
but am having difficulty.
<Row>
<Cell ss:StyleID="s87 ">
<ss:Data ss: Type = "String">
<Font html:Color="#FF 0000">M90</Font>
<Font>/Thu</Font>
</ss:Data>
</Cell>
This produces a cell with text with part of the text being red the M90 and
the other part being black.
I also have the following strings set up in my code
string spreadsheetName space = "urn:schema s-microsoft-com:office:spre adsheet";
string officeNamespace = "urn:schema s-microsoft-com:office:offi ce";
string excelNamespace = "urn:schema s-microsoft-com:office:exce l";
string htmlNamespace = "http://www.w3.org/TR/REC-html40";

thanks.
--
Paul G
Software engineer.

[Martin Honnen]

Paul wrote:

Also under the Workbook I have the following
xmlns:ss = urn:schemas-microsoft-com:office:spre adsheet

Here is some sample code that should help, you merely need to use the
WriteStartEleme nt, WriteElementStr ing and WriteAttributeS tring overloads
that allow you to specify prefix, local name, namespace and value:

const string spreadsheetName space =
"urn:schema s-microsoft-com:office:spre adsheet";
const string officeNamespace =
"urn:schema s-microsoft-com:office:offi ce";
const string excelNamespace =
"urn:schema s-microsoft-com:office:exce l";
const string htmlNamespace = "http://www.w3.org/TR/REC-html40";

XmlWriterSettin gs writerSettings = new XmlWriterSettin gs();
writerSettings. Indent = true;
using (XmlWriter xmlWriter = XmlWriter.Creat e("file.xml",
writerSettings) )
{
xmlWriter.Write StartElement("R ow", spreadsheetName space);
xmlWriter.Write StartElement("C ell", spreadsheetName space);
xmlWriter.Write AttributeString ("ss", "StyleID",
spreadsheetName space, "s87");
xmlWriter.Write StartElement("s s", "Data",
spreadsheetName space);
xmlWriter.Write AttributeString ("ss", "Type",
spreadsheetName space, "String");
xmlWriter.Write AttributeString (null, "xmlns", null,
htmlNamespace);
xmlWriter.Write StartElement("F ont", htmlNamespace);
xmlWriter.Write AttributeString ("html", "Color",
htmlNamespace, "#FF0000");
xmlWriter.Write String("M90");
xmlWriter.Write EndElement();
xmlWriter.Write ElementString(" Font", htmlNamespace,
"/Thu");
xmlWriter.Write EndElement();
xmlWriter.Write EndElement();
xmlWriter.Write EndElement();
}

Result is

<Row xmlns="urn:sche mas-microsoft-com:office:spre adsheet">
<Cell ss:StyleID="s87 "
xmlns:ss="urn:s chemas-microsoft-com:office:spre adsheet">
<ss:Data ss:Type="String " xmlns="http://www.w3.org/TR/REC-html40">
<Font html:Color="#FF 0000"
xmlns:html="htt p://www.w3.org/TR/REC-html40">M90</Font>
<Font>/Thu</Font>
</ss:Data>
</Cell>
</Row>

--

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

[=?Utf-8?B?UGF1bA==?=]

Hi, thanks for the response. I will give it a try.
--
Paul G
Software engineer.
"Martin Honnen" wrote:

Paul wrote:

Also under the Workbook I have the following
xmlns:ss = urn:schemas-microsoft-com:office:spre adsheet

Here is some sample code that should help, you merely need to use the
WriteStartEleme nt, WriteElementStr ing and WriteAttributeS tring overloads
that allow you to specify prefix, local name, namespace and value:

const string spreadsheetName space =
"urn:schema s-microsoft-com:office:spre adsheet";
const string officeNamespace =
"urn:schema s-microsoft-com:office:offi ce";
const string excelNamespace =
"urn:schema s-microsoft-com:office:exce l";
const string htmlNamespace = "http://www.w3.org/TR/REC-html40";

XmlWriterSettin gs writerSettings = new XmlWriterSettin gs();
writerSettings. Indent = true;
using (XmlWriter xmlWriter = XmlWriter.Creat e("file.xml",
writerSettings) )
{
xmlWriter.Write StartElement("R ow", spreadsheetName space);
xmlWriter.Write StartElement("C ell", spreadsheetName space);
xmlWriter.Write AttributeString ("ss", "StyleID",
spreadsheetName space, "s87");
xmlWriter.Write StartElement("s s", "Data",
spreadsheetName space);
xmlWriter.Write AttributeString ("ss", "Type",
spreadsheetName space, "String");
xmlWriter.Write AttributeString (null, "xmlns", null,
htmlNamespace);
xmlWriter.Write StartElement("F ont", htmlNamespace);
xmlWriter.Write AttributeString ("html", "Color",
htmlNamespace, "#FF0000");
xmlWriter.Write String("M90");
xmlWriter.Write EndElement();
xmlWriter.Write ElementString(" Font", htmlNamespace,
"/Thu");
xmlWriter.Write EndElement();
xmlWriter.Write EndElement();
xmlWriter.Write EndElement();
}

Result is

<Row xmlns="urn:sche mas-microsoft-com:office:spre adsheet">
<Cell ss:StyleID="s87 "
xmlns:ss="urn:s chemas-microsoft-com:office:spre adsheet">
<ss:Data ss:Type="String " xmlns="http://www.w3.org/TR/REC-html40">
<Font html:Color="#FF 0000"
xmlns:html="htt p://www.w3.org/TR/REC-html40">M90</Font>
<Font>/Thu</Font>
</ss:Data>
</Cell>
</Row>

--

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

[=?Utf-8?B?UGF1bA==?=]

Hi Martin, I integrated your example into my code and looks like it wrote out
the correct stuff when viewed with notepad but when I open the file in excel
for that cell I get M90 /Thur with empty spaces between the strings.
Also they are both colored black so seems like the Color #FF0000 is not
working. Any suggestions on what might be wrong? Thanks .
--
Paul G
Software engineer.
"Martin Honnen" wrote:

Paul wrote:

Also under the Workbook I have the following
xmlns:ss = urn:schemas-microsoft-com:office:spre adsheet

Here is some sample code that should help, you merely need to use the
WriteStartEleme nt, WriteElementStr ing and WriteAttributeS tring overloads
that allow you to specify prefix, local name, namespace and value:

const string spreadsheetName space =
"urn:schema s-microsoft-com:office:spre adsheet";
const string officeNamespace =
"urn:schema s-microsoft-com:office:offi ce";
const string excelNamespace =
"urn:schema s-microsoft-com:office:exce l";
const string htmlNamespace = "http://www.w3.org/TR/REC-html40";

XmlWriterSettin gs writerSettings = new XmlWriterSettin gs();
writerSettings. Indent = true;
using (XmlWriter xmlWriter = XmlWriter.Creat e("file.xml",
writerSettings) )
{
xmlWriter.Write StartElement("R ow", spreadsheetName space);
xmlWriter.Write StartElement("C ell", spreadsheetName space);
xmlWriter.Write AttributeString ("ss", "StyleID",
spreadsheetName space, "s87");
xmlWriter.Write StartElement("s s", "Data",
spreadsheetName space);
xmlWriter.Write AttributeString ("ss", "Type",
spreadsheetName space, "String");
xmlWriter.Write AttributeString (null, "xmlns", null,
htmlNamespace);
xmlWriter.Write StartElement("F ont", htmlNamespace);
xmlWriter.Write AttributeString ("html", "Color",
htmlNamespace, "#FF0000");
xmlWriter.Write String("M90");
xmlWriter.Write EndElement();
xmlWriter.Write ElementString(" Font", htmlNamespace,
"/Thu");
xmlWriter.Write EndElement();
xmlWriter.Write EndElement();
xmlWriter.Write EndElement();
}

Result is

<Row xmlns="urn:sche mas-microsoft-com:office:spre adsheet">
<Cell ss:StyleID="s87 "
xmlns:ss="urn:s chemas-microsoft-com:office:spre adsheet">
<ss:Data ss:Type="String " xmlns="http://www.w3.org/TR/REC-html40">
<Font html:Color="#FF 0000"
xmlns:html="htt p://www.w3.org/TR/REC-html40">M90</Font>
<Font>/Thu</Font>
</ss:Data>
</Cell>
</Row>

--

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

[=?Utf-8?B?UGF1bA==?=]

Thanks for the help, got it working. I had to write stuff out all on one
line to get rid of the spaces between M90 and /thur.

--
Paul G
Software engineer.
"Martin Honnen" wrote:

Paul wrote:

Also under the Workbook I have the following
xmlns:ss = urn:schemas-microsoft-com:office:spre adsheet

Here is some sample code that should help, you merely need to use the
WriteStartEleme nt, WriteElementStr ing and WriteAttributeS tring overloads
that allow you to specify prefix, local name, namespace and value:

const string spreadsheetName space =
"urn:schema s-microsoft-com:office:spre adsheet";
const string officeNamespace =
"urn:schema s-microsoft-com:office:offi ce";
const string excelNamespace =
"urn:schema s-microsoft-com:office:exce l";
const string htmlNamespace = "http://www.w3.org/TR/REC-html40";

XmlWriterSettin gs writerSettings = new XmlWriterSettin gs();
writerSettings. Indent = true;
using (XmlWriter xmlWriter = XmlWriter.Creat e("file.xml",
writerSettings) )
{
xmlWriter.Write StartElement("R ow", spreadsheetName space);
xmlWriter.Write StartElement("C ell", spreadsheetName space);
xmlWriter.Write AttributeString ("ss", "StyleID",
spreadsheetName space, "s87");
xmlWriter.Write StartElement("s s", "Data",
spreadsheetName space);
xmlWriter.Write AttributeString ("ss", "Type",
spreadsheetName space, "String");
xmlWriter.Write AttributeString (null, "xmlns", null,
htmlNamespace);
xmlWriter.Write StartElement("F ont", htmlNamespace);
xmlWriter.Write AttributeString ("html", "Color",
htmlNamespace, "#FF0000");
xmlWriter.Write String("M90");
xmlWriter.Write EndElement();
xmlWriter.Write ElementString(" Font", htmlNamespace,
"/Thu");
xmlWriter.Write EndElement();
xmlWriter.Write EndElement();
xmlWriter.Write EndElement();
}

Result is

<Row xmlns="urn:sche mas-microsoft-com:office:spre adsheet">
<Cell ss:StyleID="s87 "
xmlns:ss="urn:s chemas-microsoft-com:office:spre adsheet">
<ss:Data ss:Type="String " xmlns="http://www.w3.org/TR/REC-html40">
<Font html:Color="#FF 0000"
xmlns:html="htt p://www.w3.org/TR/REC-html40">M90</Font>
<Font>/Thu</Font>
</ss:Data>
</Cell>
</Row>

--

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