c# writing to spreadsheet using XmlWriter

I'm using an XmlWriter to create a spreadsheet and have been successful with the basic setup. The documentation is available here doc

and I'm trying to use some advanced features like making a cell span several columns, change font color, cell color, etc. I can see the xml tags needed for this but I dont know how to convert this to t开发者_JAVA百科he format that XmlWriter required. Can someone help me out a little.

XmlWriter is a serial way to write XML, I mean you write as if you were hand writing it.

So, if you can generate the XML, simply follow the steps that you require in order to use the XmlWriter.

Why you don't use a library like NPOI ?

http://npoi.codeplex.com/