Excel在unity中的读取

using System.Collections;
using System.Collections.Generic;
using System.IO;
using UnityEngine;
using System.Data;
using Excel;


public class Excel_test : MonoBehaviour {


    public string ExcelPathName;


    void Start()
    {
        GameReadExcel(ExcelPathName);
    }


    /// <summary>   
    /// 只读Excel方法   
    /// </summary>   
    /// <param name="ExcelPath"></param>   
    public static void GameReadExcel(string ExcelPath)
    {
        FileStream stream = File.Open(Application.dataPath +"/"+ ExcelPath, FileMode.Open, FileAccess.Read);




        //1. Reading from a binary Excel file ('97-2003 format; *.xls)
        //IExcelDataReader excelReader = ExcelReaderFactory.CreateBinaryReader(stream);
        //...
        //2. Reading from a OpenXml Excel file (2007 format; *.xlsx)
        //IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
        IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
        DataSet result = excelReader.AsDataSet();


        int columns = result.Tables[0].Columns.Count;//获取列数   
        print(columns);
        int rows = result.Tables[0].Rows.Count;//获取行数   
        print(rows);


        //从第二行开始读   
        for (int i = 1; i < rows; i++)
        {
            for (int j = 0; j < columns; j++)
            {
                string nvalue = result.Tables[0].Rows[i][j].ToString();            
                Debug.Log(nvalue);
            }
        }
        excelReader.Close();
    }
}