读取xml并将节点保存到Excal

using NPOI.HPSF;

using NPOI.HSSF.UserModel;

using NPOI.SS.UserModel;

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.IO;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Xml;

using System.Xml.Schema;

namespace myXMLReader

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void button1_Click(object sender, EventArgs e)

        {

            treeResult.Nodes.Clear();

            readXml();

        }

        private void readXml()

        {

            // todo

            String sourcePath = "f:/test.xml";

            System.Xml.XmlDocument sourceXml = new XmlDocument();

            try

            {

                sourceXml.Load(sourcePath);

            }

            catch (XmlException e)

            {

                StringBuilder sb = addRootToXml(sourcePath);

                sourceXml.LoadXml(sb.ToString());

            }

            catch (Exception e)

            {

                return;

            }

            foreach (XmlNode rootNode in sourceXml.ChildNodes)

            {

                if (rootNode.NodeType == XmlNodeType.Element)

                {

                    TreeNode tNode = new TreeNode(rootNode.Name);

                    readChildNode(rootNode, tNode);

                    treeResult.Nodes.Add(tNode);

                }

            }

            creatToExcel();

        }

        private void readChildNode(XmlNode node, TreeNode tNode)

        {

            foreach (XmlNode childNode in node.ChildNodes)

            {

                if (childNode.NodeType != XmlNodeType.Element)

                {

                    continue;

                }

                TreeNode tChildNode = new TreeNode(childNode.Name);

                tNode.Nodes.Add(tChildNode);

                if (childNode.HasChildNodes)

                {

                    readChildNode(childNode, tChildNode);

                }

            }

        }

        private StringBuilder addRootToXml(string path)

        {

            TextReader reader = File.OpenText(path);

            StringBuilder sb = new StringBuilder(reader.ReadToEnd());

            sb.Insert(, "<XML>");

            sb.Append("</XML>");

            return sb;

        }

        private int writeRowIndex = ;

        private void creatToExcel()

        {

            int startColumn = ;

            HSSFWorkbook hssfworkbook = new HSSFWorkbook();

            DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation();

            dsi.Company = "NPOI Team";

            hssfworkbook.DocumentSummaryInformation = dsi;

            SummaryInformation si = PropertySetFactory.CreateSummaryInformation();

            si.Subject = "NPOI SDK Example";

            hssfworkbook.SummaryInformation = si;

            ISheet sheet = hssfworkbook.CreateSheet("Sheet1");

            writeNodeToExcel(sheet, treeResult.Nodes[], startColumn);

            FileStream file = new FileStream(@"f:/test.xls", FileMode.Create);

            hssfworkbook.Write(file);

            file.Close();

        }

        private void writeNodeToExcel(ISheet sheet, TreeNode node, int columnIndex)

        {

            IRow row = sheet.CreateRow(getRow());

            ICell cell = row.CreateCell(columnIndex);

            cell.SetCellValue(node.Text);

            for (int i = ; i < node.Nodes.Count; i++)

            {

                writeNodeToExcel(sheet, node.Nodes[i], columnIndex + );

            }

        }

        private int getRow()

        {

            return writeRowIndex++;

        }

    }

}

最近需要一个读取xml，将节点写入Excel的功能，还没有完善，暂时记录一下。