| Groups | Blog | Home |
dotnet xml : how to write this out using xmlwriter
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="#FF0000">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 spreadsheetNamespace = "urn:schemas-microsoft-com:office:spreadsheet"; string officeNamespace = "urn:schemas-microsoft-com:office:office"; string excelNamespace = "urn:schemas-microsoft-com:office:excel"; string htmlNamespace = "http://www.w3.org/TR/REC-html40"; thanks. -- Paul G
[quoted text, click to view]
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="#FF0000">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 spreadsheetNamespace = "urn:schemas-microsoft-com:office:spreadsheet"; > string officeNamespace = "urn:schemas-microsoft-com:office:office"; > string excelNamespace = "urn:schemas-microsoft-com:office:excel"; > 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
Hi thanks for the response. When I write out the row I am using the following,
WriteStartElement("Row"); WriteAttributeString("ss","AutofitHeight","SpreadsheetNamespace","0"); followed by other write statements for cells/data and closing tags. So I am using the SpreadsheetNamespace for both rows and cells. The SpreadsheetNamespace I have defined as "urn:schemas-microsoft-com:office:spareadsheet". I am using the "ss" prefix whenever the SpreadsheetNamespace is used like in the WriteAttributeString above. I am kind of new to xml but was trying to bind it to urn:schemas-microsoft-com:office:spreadsheet. 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. [quoted text, click to view] "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="#FF0000">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 spreadsheetNamespace = "urn:schemas-microsoft-com:office:spreadsheet"; > > string officeNamespace = "urn:schemas-microsoft-com:office:office"; > > string excelNamespace = "urn:schemas-microsoft-com:office:excel"; > > 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/
Also I am using a namespace when i write out the string attribute for the
cells and rows. I am using the WriteStartElement as described above to write out the start tags for rows and cells. Thanks Paul. -- Paul G Software engineer. [quoted text, click to view] "Paul" wrote:
> Hi thanks for the response. When I write out the row I am using the following, > WriteStartElement("Row"); > WriteAttributeString("ss","AutofitHeight","SpreadsheetNamespace","0"); > followed by other write statements for cells/data and closing tags. > So I am using the SpreadsheetNamespace for both rows and cells. > The SpreadsheetNamespace I have defined as > "urn:schemas-microsoft-com:office:spareadsheet". I am using the "ss" prefix > whenever the SpreadsheetNamespace is used like in the WriteAttributeString > above. I am kind of new to xml but was trying to bind it to > urn:schemas-microsoft-com:office:spreadsheet. 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="#FF0000">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 spreadsheetNamespace = "urn:schemas-microsoft-com:office:spreadsheet"; > > > string officeNamespace = "urn:schemas-microsoft-com:office:office"; > > > string excelNamespace = "urn:schemas-microsoft-com:office:excel"; > > > 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/
Also under the Workbook I have the following
xmlns:ss = urn:schemas-microsoft-com:office:spreadsheet -- Paul G Software engineer. [quoted text, click to view] "Paul" wrote:
> Also I am using a namespace when i write out the string attribute for the > cells and rows. I am using the WriteStartElement 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, > > WriteStartElement("Row"); > > WriteAttributeString("ss","AutofitHeight","SpreadsheetNamespace","0"); > > followed by other write statements for cells/data and closing tags. > > So I am using the SpreadsheetNamespace for both rows and cells. > > The SpreadsheetNamespace I have defined as > > "urn:schemas-microsoft-com:office:spareadsheet". I am using the "ss" prefix > > whenever the SpreadsheetNamespace is used like in the WriteAttributeString > > above. I am kind of new to xml but was trying to bind it to > > urn:schemas-microsoft-com:office:spreadsheet. 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="#FF0000">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 spreadsheetNamespace = "urn:schemas-microsoft-com:office:spreadsheet"; > > > > string officeNamespace = "urn:schemas-microsoft-com:office:office"; > > > > string excelNamespace = "urn:schemas-microsoft-com:office:excel"; > > > > 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/
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="#FF0000">M90</Font> <Font/Thur<Font> </ss:Data> </Cell> -- Paul G Software engineer. [quoted text, click to view] "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="#FF0000">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 spreadsheetNamespace = "urn:schemas-microsoft-com:office:spreadsheet"; > string officeNamespace = "urn:schemas-microsoft-com:office:office"; > string excelNamespace = "urn:schemas-microsoft-com:office:excel"; > string htmlNamespace = "http://www.w3.org/TR/REC-html40"; > > thanks. > -- > Paul G
Hi, thanks for the response. I will give it a try.
-- Paul G Software engineer. [quoted text, click to view] "Martin Honnen" wrote:
> Paul wrote: > > Also under the Workbook I have the following > > xmlns:ss = urn:schemas-microsoft-com:office:spreadsheet > > Here is some sample code that should help, you merely need to use the > WriteStartElement, WriteElementString and WriteAttributeString overloads > that allow you to specify prefix, local name, namespace and value: > > const string spreadsheetNamespace = > "urn:schemas-microsoft-com:office:spreadsheet"; > const string officeNamespace = > "urn:schemas-microsoft-com:office:office"; > const string excelNamespace = > "urn:schemas-microsoft-com:office:excel"; > const string htmlNamespace = "http://www.w3.org/TR/REC-html40"; > > XmlWriterSettings writerSettings = new XmlWriterSettings(); > writerSettings.Indent = true; > using (XmlWriter xmlWriter = XmlWriter.Create("file.xml", > writerSettings)) > { > xmlWriter.WriteStartElement("Row", spreadsheetNamespace); > xmlWriter.WriteStartElement("Cell", spreadsheetNamespace); > xmlWriter.WriteAttributeString("ss", "StyleID", > spreadsheetNamespace, "s87"); > xmlWriter.WriteStartElement("ss", "Data", > spreadsheetNamespace); > xmlWriter.WriteAttributeString("ss", "Type", > spreadsheetNamespace, "String"); > xmlWriter.WriteAttributeString(null, "xmlns", null, > htmlNamespace); > xmlWriter.WriteStartElement("Font", htmlNamespace); > xmlWriter.WriteAttributeString("html", "Color", > htmlNamespace, "#FF0000"); > xmlWriter.WriteString("M90"); > xmlWriter.WriteEndElement(); > xmlWriter.WriteElementString("Font", htmlNamespace, > "/Thu"); > xmlWriter.WriteEndElement(); > xmlWriter.WriteEndElement(); > xmlWriter.WriteEndElement(); > } > > Result is > > <Row xmlns="urn:schemas-microsoft-com:office:spreadsheet"> > <Cell ss:StyleID="s87" > xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"> > <ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"> > <Font html:Color="#FF0000" > xmlns:html="http://www.w3.org/TR/REC-html40">M90</Font> > <Font>/Thu</Font> > </ss:Data> > </Cell> > </Row> > > -- > > Martin Honnen --- MVP XML > http://JavaScript.FAQTs.com/
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. [quoted text, click to view] "Martin Honnen" wrote:
> Paul wrote: > > Also under the Workbook I have the following > > xmlns:ss = urn:schemas-microsoft-com:office:spreadsheet > > Here is some sample code that should help, you merely need to use the > WriteStartElement, WriteElementString and WriteAttributeString overloads > that allow you to specify prefix, local name, namespace and value: > > const string spreadsheetNamespace = > "urn:schemas-microsoft-com:office:spreadsheet"; > const string officeNamespace = > "urn:schemas-microsoft-com:office:office"; > const string excelNamespace = > "urn:schemas-microsoft-com:office:excel"; > const string htmlNamespace = "http://www.w3.org/TR/REC-html40"; > > XmlWriterSettings writerSettings = new XmlWriterSettings(); > writerSettings.Indent = true; > using (XmlWriter xmlWriter = XmlWriter.Create("file.xml", > writerSettings)) > { > xmlWriter.WriteStartElement("Row", spreadsheetNamespace); > xmlWriter.WriteStartElement("Cell", spreadsheetNamespace); > xmlWriter.WriteAttributeString("ss", "StyleID", > spreadsheetNamespace, "s87"); > xmlWriter.WriteStartElement("ss", "Data", > spreadsheetNamespace); > xmlWriter.WriteAttributeString("ss", "Type", > spreadsheetNamespace, "String"); > xmlWriter.WriteAttributeString(null, "xmlns", null, > htmlNamespace); > xmlWriter.WriteStartElement("Font", htmlNamespace); > xmlWriter.WriteAttributeString("html", "Color", > htmlNamespace, "#FF0000"); > xmlWriter.WriteString("M90"); > xmlWriter.WriteEndElement(); > xmlWriter.WriteElementString("Font", htmlNamespace, > "/Thu"); > xmlWriter.WriteEndElement(); > xmlWriter.WriteEndElement(); > xmlWriter.WriteEndElement(); > } > > Result is > > <Row xmlns="urn:schemas-microsoft-com:office:spreadsheet"> > <Cell ss:StyleID="s87" > xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"> > <ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"> > <Font html:Color="#FF0000" > xmlns:html="http://www.w3.org/TR/REC-html40">M90</Font> > <Font>/Thu</Font> > </ss:Data> > </Cell> > </Row> > > -- > > Martin Honnen --- MVP XML > http://JavaScript.FAQTs.com/
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. [quoted text, click to view] "Martin Honnen" wrote:
> Paul wrote: > > Also under the Workbook I have the following > > xmlns:ss = urn:schemas-microsoft-com:office:spreadsheet > > Here is some sample code that should help, you merely need to use the > WriteStartElement, WriteElementString and WriteAttributeString overloads > that allow you to specify prefix, local name, namespace and value: > > const string spreadsheetNamespace = > "urn:schemas-microsoft-com:office:spreadsheet"; > const string officeNamespace = > "urn:schemas-microsoft-com:office:office"; > const string excelNamespace = > "urn:schemas-microsoft-com:office:excel"; > const string htmlNamespace = "http://www.w3.org/TR/REC-html40"; > > XmlWriterSettings writerSettings = new XmlWriterSettings(); > writerSettings.Indent = true; > using (XmlWriter xmlWriter = XmlWriter.Create("file.xml", > writerSettings)) > { > xmlWriter.WriteStartElement("Row", spreadsheetNamespace); > xmlWriter.WriteStartElement("Cell", spreadsheetNamespace); > xmlWriter.WriteAttributeString("ss", "StyleID", > spreadsheetNamespace, "s87"); > xmlWriter.WriteStartElement("ss", "Data", > spreadsheetNamespace); > xmlWriter.WriteAttributeString("ss", "Type", > spreadsheetNamespace, "String"); > xmlWriter.WriteAttributeString(null, "xmlns", null, > htmlNamespace); > xmlWriter.WriteStartElement("Font", htmlNamespace); > xmlWriter.WriteAttributeString("html", "Color", > htmlNamespace, "#FF0000"); > xmlWriter.WriteString("M90"); > xmlWriter.WriteEndElement(); > xmlWriter.WriteElementString("Font", htmlNamespace, > "/Thu"); > xmlWriter.WriteEndElement(); > xmlWriter.WriteEndElement(); > xmlWriter.WriteEndElement(); > } > > Result is > > <Row xmlns="urn:schemas-microsoft-com:office:spreadsheet"> > <Cell ss:StyleID="s87" > xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"> > <ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"> > <Font html:Color="#FF0000" > xmlns:html="http://www.w3.org/TR/REC-html40">M90</Font> > <Font>/Thu</Font> > </ss:Data> > </Cell> > </Row> > > -- > > Martin Honnen --- MVP XML > http://JavaScript.FAQTs.com/
[quoted text, click to view]
Paul wrote: > Also under the Workbook I have the following > xmlns:ss = urn:schemas-microsoft-com:office:spreadsheet Here is some sample code that should help, you merely need to use the WriteStartElement, WriteElementString and WriteAttributeString overloads that allow you to specify prefix, local name, namespace and value: const string spreadsheetNamespace = "urn:schemas-microsoft-com:office:spreadsheet"; const string officeNamespace = "urn:schemas-microsoft-com:office:office"; const string excelNamespace = "urn:schemas-microsoft-com:office:excel"; const string htmlNamespace = "http://www.w3.org/TR/REC-html40"; XmlWriterSettings writerSettings = new XmlWriterSettings(); writerSettings.Indent = true; using (XmlWriter xmlWriter = XmlWriter.Create("file.xml", writerSettings)) { xmlWriter.WriteStartElement("Row", spreadsheetNamespace); xmlWriter.WriteStartElement("Cell", spreadsheetNamespace); xmlWriter.WriteAttributeString("ss", "StyleID", spreadsheetNamespace, "s87"); xmlWriter.WriteStartElement("ss", "Data", spreadsheetNamespace); xmlWriter.WriteAttributeString("ss", "Type", spreadsheetNamespace, "String"); xmlWriter.WriteAttributeString(null, "xmlns", null, htmlNamespace); xmlWriter.WriteStartElement("Font", htmlNamespace); xmlWriter.WriteAttributeString("html", "Color", htmlNamespace, "#FF0000"); xmlWriter.WriteString("M90"); xmlWriter.WriteEndElement(); xmlWriter.WriteElementString("Font", htmlNamespace, "/Thu"); xmlWriter.WriteEndElement(); xmlWriter.WriteEndElement(); xmlWriter.WriteEndElement(); } Result is <Row xmlns="urn:schemas-microsoft-com:office:spreadsheet"> <Cell ss:StyleID="s87" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"> <ss:Data ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"> <Font html:Color="#FF0000" xmlns:html="http://www.w3.org/TR/REC-html40">M90</Font> <Font>/Thu</Font> </ss:Data> </Cell> </Row> -- Martin Honnen --- MVP XML
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |