XmlDocument,XDocument相互转换

XmlDocument,XDocument相互转换

using System;
using System.Xml;
using System.Xml.Linq;
 
namespace MyTest
{
    internal class Program
    {
        private static void Main(string[] args)
        {
 
            var xmlDocument = new XmlDocument();
            xmlDocument.LoadXml("<Root><Child>Test</Child></Root>");
 
            var xDocument = xmlDocument.ToXDocument();
            var newXmlDocument = xDocument.ToXmlDocument();
            Console.ReadLine();
        }
    }
 
    public static class DocumentExtensions
    {
        public static XmlDocument ToXmlDocument(this XDocument xDocument)
        {
            var xmlDocument = new XmlDocument();
            using(var xmlReader = xDocument.CreateReader())
            {
                xmlDocument.Load(xmlReader);
            }
            return xmlDocument;
        }
 
        public static XDocument ToXDocument(this XmlDocument xmlDocument)
        {
            using (var nodeReader = new XmlNodeReader(xmlDocument))
            {
                nodeReader.MoveToContent();
                return XDocument.Load(nodeReader);
            }
        }
    }
}

如果您正在使用3.0或更低,您必须使用XmlDocument aka经典的DOM API。同样地,你会发现有一些其他api可以期待

如果你想要选择,我将彻底推荐使用LINQ to XML XDocument aka。这是更简单的创建文件和处理它们。例如,它的区别

XmlDocument doc = new XmlDocument();
XmlElement root = doc.CreateElement("root");
root.SetAttribute("name", "value");
XmlElement child = doc.CreateElement("child");
child.InnerText = "text node";
root.AppendChild(child);
doc.AppendChild(root);
and
 
XDocument doc = new XDocument(
    new XElement("root",
                 new XAttribute("name", "value"),
                 new XElement("child", "text node")));

Namespaces are pretty easy to work with in LINQ to XML, unlike any other XML API I've ever seen:

XNamespace ns = "http://somewhere.com";
XElement element = new XElement(ns + "elementName");
// etc

LINQ to XML also works really well with LINQ - its construction model allows you to build elements with sequences of sub-elements really easily:

// Customers is a List<Customer>
XElement customersElement = new XElement("customers",
    customers.Select(c => new XElement("customer",
        new XAttribute("name", c.Name),
        new XAttribute("lastSeen", c.LastOrder)
        new XElement("address",
            new XAttribute("town", c.Town),
            new XAttribute("firstline", c.Address1),
            // etc
    ));

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 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、付费专栏及课程。

余额充值