using System; using System.Linq; using System.Collections; using System.Collections.Generic; using System.Xml; using System.Xml.Xsl; using System.IO; using System.Xml.Linq; public class MainClass { public static void Main() { XDocument xDocument = new XDocument( new XElement("Books", new XElement("Book", new XAttribute("type", "Author"), new XElement("FirstName", "A"), new XElement("LastName", "B")), new XElement("Book", new XAttribute("type", "Author"), new XElement("FirstName", "C"), new XElement("LastName", "D")))); XDocument transformedDoc = new XDocument(); using (XmlWriter writer = transformedDoc.CreateWriter()) { XslCompiledTransform transform = new XslCompiledTransform(); transform.Load(XmlReader.Create(new StringReader("c:your.xls"))); transform.Transform(xDocument.CreateReader(), writer); } Console.WriteLine(transformedDoc); } }