C#中Xml与对象Model的相互转换

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.IO;
using System.Xml.Serialization;
 
namespace OAServiceInvoke
{
    public class XMLSerialize
    {
        public static string XmlSerialize<T>(T obj)
        {
            using (StringWriter sw = new StringWriter())
            {
                Type t = obj.GetType();
                XmlSerializer serializer = new XmlSerializer(obj.GetType());
                serializer.Serialize(sw, obj);
                sw.Close();
                return sw.ToString();
            }
        }
 
        public static T DESerializer<T>(string strXML) where T:class
        {
            try
            {
                using (StringReader sr = new StringReader(strXML))
                {
                    XmlSerializer serializer = new XmlSerializer(typeof(T));
                    return serializer.Deserialize(sr) as T;
                }
            }
            catch
            {
                return null;
            }
        }
    }
}

例子:

<?xml version="1.0" encoding="utf-8" ?>
<envelope>
    <header>
        <version port="1111" host="www.baidu.com">successfuly</version>
        <timestamp>20211216081218</timestamp>
    </header>
    <response type="cities" product="hotel">
        <cities>
            <city>
                <code value="zg" />
                <city_tax value="true" />
                <names>
                    <name language="fr" value="ABANO TERME - PADOUE" />
                    <name language="en" value="ABANO TERME - PADUE" />
                    <name language="nl" value="ABANO TERME - PADUE" />
                </names>
            </city>
            <city>
                <code value="hk" />
                <city_tax value="false" />
                <names>
                    <name language="fr" value="ABBADIA SAN SALVATORE - SIENNE" />
                    <name language="en" value="ABBADIA SAN SALVATORE - SIENA" />
                    <name language="nl" value="ABBADIA SAN SALVATORE - SIENA" />
                </names>
            </city>
        </cities>
    </response>
</envelope>

对象:

namespace Practices.Models
{
    /// <summary>
    /// Envelope
    /// </summary>
    [XmlType(TypeName = "envelope")]
    public class CityDataModel
    {
        /// <summary>
        /// header
        /// </summary>
        [XmlElement("header")]
        public Header header { get; set; }
        
        /// <summary>
        /// response
        /// </summary>
        [XmlElement("response")]
        public Response response { get; set; }
    }

    /// <summary>
    /// Header
    /// </summary>
    [XmlType(TypeName = "header")]
    public class Header
    {
        /// <summary>
        /// version
        /// </summary>
        [XmlElement("version")]
        public Version version { get; set; }

        /// <summary>
        /// timestamp
        /// </summary>
        [XmlElement("timestamp")]
        public string timestamp { get; set; }
    }

    /// <summary>
    /// Version
    /// </summary>
    public class Version
    {
        /// <summary>
        /// port
        /// </summary>
        [XmlAttribute("port")]
        public string port { get; set; }

        /// <summary>
        /// host
        /// </summary>
        [XmlAttribute("host")]
        public string host { get; set; }

        /// <summary>
        /// value:XmlTextAttribute指示该属性作为XML文本处理
        /// </summary>
        [XmlTextAttribute()]
        public string value { get; set; }

    }

    /// <summary>
    /// Response
    /// </summary>
    [XmlType(TypeName = "response")]
    public class Response
    {
        /// <summary>
        /// type
        /// </summary>
        [XmlAttribute]
        public string type { get; set; }

        /// <summary>
        /// product
        /// </summary>
        [XmlAttribute]
        public string product { get; set; }

        /// <summary>
        /// cities
        /// </summary>
        [XmlArray("cities")]
        public List<City> cities { get; set; }

    }
 
    /// <summary>
    /// class: City
    /// </summary>
    [XmlType(TypeName = "city")]
    public class City
    {
        /// <summary>
        /// code
        /// </summary>
        [XmlElement("code")]
        public Code code { get; set; }

        /// <summary>
        /// city_tax
        /// </summary>
        [XmlElement("city_tax")]
        public City_tax city_tax { get; set; }

        /// <summary>
        /// names
        /// </summary>
        [XmlArray("names")]
        public List<Name> names { get; set; }
    }
 
    /// <summary>
    /// class: Code
    /// </summary>
    [XmlType(TypeName = "code")]
    public class Code
    {
        /// <summary>
        /// 
        /// </summary>
        [XmlAttribute("value")]
        public string value { get; set; }
    }
 
    /// <summary>
    /// class: City_tax
    /// </summary>
    [XmlType(TypeName = "city_tax")]
    public class City_tax
    {
        /// <summary>
        /// 
        /// </summary>
        [XmlAttribute("value")]
        public string value { get; set; }
    }
 
    /// <summary>
    /// class: Name
    /// </summary>
    [XmlType(TypeName = "name")]
    public class Name
    {
        /// <summary>
        /// 
        /// </summary>
        [XmlAttribute("language")]
        public string language { get; set; }
        
        /// <summary>
        /// 
        /// </summary>
        [XmlAttribute("value")]
        public string value { get; set; }
    }
}

可以使用Visual Studio自带的Xml对象模型类

1.首先Ctrl+C复制你需要生成的Xml文档内容

2.找到编辑=》选择性粘贴=》将Xml粘贴为类,这样就可以了

XmlType(TypeName=“”)为<>的开始Name

XmlAttribute为内部关键字

XmlText()是获取<>123</>123的Value

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
你可以使用 C# 的 `OpenXML` 库来实现 XML 和 Excel 文件之间的相互转换。下面是一个简单的示例代码,演示了如何将 XML 数据导出到 Excel 文件,并将 Excel 文件导入为 XML 数据。 首先,你需要添加对 `DocumentFormat.OpenXml` 和 `WindowsBase` 的引用。然后,你可以尝试以下代码: ```csharp using DocumentFormat.OpenXml; using DocumentFormat.OpenXml.Packaging; using DocumentFormat.OpenXml.Spreadsheet; using System; using System.IO; using System.Linq; using System.Xml.Linq; public static class XmlExcelConverter { public static void ExportXmlToExcel(string xmlFilePath, string excelFilePath) { XDocument xmlDocument = XDocument.Load(xmlFilePath); using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(excelFilePath, SpreadsheetDocumentType.Workbook)) { WorkbookPart workbookPart = spreadsheetDocument.AddWorkbookPart(); workbookPart.Workbook = new Workbook(); WorksheetPart worksheetPart = workbookPart.AddNewPart<WorksheetPart>(); worksheetPart.Worksheet = new Worksheet(new SheetData()); Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.AppendChild(new Sheets()); Sheet sheet = new Sheet() { Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "Sheet1" }; sheets.Append(sheet); var data = xmlDocument.Descendants("data").ToList(); for (int i = 0; i < data.Count; i++) { var rowData = data[i].Descendants("row").ToList(); for (int j = 0; j < rowData.Count; j++) { var cellData = rowData[j].Descendants("cell").ToList(); for (int k = 0; k < cellData.Count; k++) { var cell = new Cell() { DataType = CellValues.String, CellValue = new CellValue(cellData[k].Value) }; worksheetPart.Worksheet.GetFirstChild<SheetData>().AppendChild(new Row(new Cell[] { cell })); } } } workbookPart.Workbook.Save(); } } public static void ImportExcelToXml(string excelFilePath, string xmlFilePath) { XDocument xmlDocument = new XDocument(); using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(excelFilePath, false)) { WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart; WorksheetPart worksheetPart = workbookPart.WorksheetParts.First(); var rows = worksheetPart.Worksheet.GetFirstChild<SheetData>().Elements<Row>(); XElement rootElement = new XElement("root"); foreach (var row in rows) { XElement rowData = new XElement("row"); foreach (var cell in row.Elements<Cell>()) { var cellValue = GetCellValue(cell, workbookPart); XElement cellData = new XElement("cell", cellValue); rowData.Add(cellData); } rootElement.Add(rowData); } xmlDocument.Add(rootElement); } xmlDocument.Save(xmlFilePath); } private static string GetCellValue(Cell cell, WorkbookPart workbookPart) { if (cell.DataType == null) { return cell.CellValue.InnerText; } string value = cell.CellValue.InnerText; if (cell.DataType.Value == CellValues.SharedString) { var sharedStringTablePart = workbookPart.GetPartsOfType<SharedStringTablePart>().FirstOrDefault(); if (sharedStringTablePart != null) { return sharedStringTablePart.SharedStringTable.ChildElements[int.Parse(value)].InnerText; } } return value; } } ``` 使用此代码,你可以将指定的 XML 文件导出到 Excel 文件,或将 Excel 文件导入为 XML 文件。例如: ```csharp string xmlFilePath = "path/to/xml/file.xml"; string excelFilePath = "path/to/excel/file.xlsx"; // 将 XML 导出为 Excel XmlExcelConverter.ExportXmlToExcel(xmlFilePath, excelFilePath); // 将 Excel 导入为 XML XmlExcelConverter.ImportExcelToXml(excelFilePath, xmlFilePath); ``` 请确保指定的 XML 文件和 Excel 文件存在,并根据实际情况修改文件路径。希望这可以帮助到你!

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值