locked
Convert XML into Excel RRS feed

  • Question

  • User-1569779262 posted

    How Can one create Excel from XML. One more query: Can we write only certain tags in XML while creating XML? For Example: 

    I want to write say only 2 tags in XMLsay Name & Designation.
    I am creating XML like beow:
    System.Xml.Serialization.XmlSerializer serializerRA = new System.Xml.Serialization.XmlSerializer(typeof(UserBE));

    XmlWriterSettings settings = new XmlWriterSettings();
    settings.Encoding = new UnicodeEncoding(false, false);
    settings.Indent = true;
    settings.OmitXmlDeclaration = true;
    StringWriter textWriterRA = new StringWriter();

    if (UserLoginList != null)
    {
    foreach (UserBE xUserBE in UserLoginList)
    {
    using (XmlWriter xmlWriter = XmlWriter.Create(textWriterRA, settings))
    {
    serializerRA.Serialize(xmlWriter, xUserBE);
    }


    }
    }

    Monday, August 18, 2014 12:25 AM

All replies