【Unity3D日常】使用Unity3D读取Json、XML、Excel文件

<note>
<note1>
<id>1</id>
<name>tom</name>
<score>95</score> 
</note1>
<note2>
<id>2</id>
<name>jay</name>
<score>98</score> 
</note2>
</note>
复制代码

using System.IO;
using UnityEngine;
public class Parse_Json : MonoBehaviour
{
    void Start()
    {
        ParseJson();
    }
    public void ParseJson()
    {
        //获取到Json文件的路径
        string filePath = Application.dataPath + "/Resources/test.json";
        //string类型的数据常量
        string readData = "";
        //读取文件
        StreamReader str = File.OpenText(filePath);
        //数据保存
        readData = str.ReadToEnd();
        str.Close();
        //数据解析并把数据保存到m_PersonData1 变量中
        DataClassList dataClass = JsonUtility.FromJson<DataClassList>(readData);
        foreach (var item in dataClass.Data_Class)
        {
            Debug.Log(item.Id);
            Debug.Log(item.Name);
            Debug.Log(item.Score);
        }
    }
}
复制代码

[System.Serializable]
public class Data_Class 
{
    public string Id;
    public string Name;
    public string Score; 
}
[System.Serializable]
public class DataClassList
{
    public Data_Class[] Data_Class;
}
复制代码

using System.Collections;
using System.Collections.Generic;
using System.IO;
using System.Xml;
using UnityEngine;
public class Parse_Xml : MonoBehaviour
{
    void Start()
    {
        ParseXML();
    }
    public void ParseXML()
    {
        //获取到XML文件的路径
        string filePath = Application.dataPath + "/Resources/test.xml";
        if (File.Exists(filePath))
        {
            //创建一个数据类集合
            List<Data_Class> dataList = new List<Data_Class>();
            //创建一个XML文件解析对象
            XmlDocument xmlDoc = new XmlDocument();
            //加载XML
            xmlDoc.Load(filePath);
            //获取根节点
            XmlNode rootNode = xmlDoc.FirstChild;
            //获取根节点下面所有的子节点
            XmlNodeList nodeList = rootNode.ChildNodes;
            //遍历节点
            foreach (XmlElement item in nodeList)
            {
                Data_Class dataClass = new Data_Class();
                dataClass.Id = item.ChildNodes.Item(0).InnerText;
                dataClass.Name = item.ChildNodes.Item(1).InnerText;
                dataClass.Score = item.ChildNodes.Item(2).InnerText;
                dataList.Add(dataClass);
            }
            //打印数据
            foreach (Data_Class item in dataList)
            {
                Debug.Log(item.Id);
                Debug.Log(item.Name);
                Debug.Log(item.Score);
            }
        }
    }
}
复制代码

[System.Serializable]
public class Data_Class 
{
    public string Id;
    public string Name;
    public string Score; 
}
复制代码

using UnityEngine;
using System.Collections.Generic;
using Excel;
using System.IO;
using System.Data;
public class Parse_Excel : MonoBehaviour
{
    void Start()
    {
        ParseExcel();
    }
    public void ParseExcel()
    {
        //获取到Json文件的路径
        string filePath = Application.dataPath + "/Resources/test.xlsx";
        FileStream fs = File.Open(filePath, FileMode.Open, FileAccess.Read, FileShare.Read);
        IExcelDataReader iExcelDR = ExcelReaderFactory.CreateOpenXmlReader(fs);
        DataSet ds = iExcelDR.AsDataSet();
        List<TableData> data = new List<TableData>();
        int columns = ds.Tables[0].Columns.Count;   //总列数，Tables[0]为表1
        int rows = ds.Tables[0].Rows.Count;         //总行数
        for (int i = 1; i < rows; i++)
        {
            TableData td = new TableData();
            td.Id = ds.Tables[0].Rows[i][0].ToString();//ds.Tables[0].Rows[i][0]是Object，需强行转换为String型
            td.Name = ds.Tables[0].Rows[i][1].ToString();
            td.Score = ds.Tables[0].Rows[i][2].ToString();
            Debug.Log(td.Id + "  " + td.Name + "   " + td.Score);
            data.Add(td);
        }
    }
}
复制代码