Excel表格和Unity

1.配置

下载EPPlus.dll

链接：https://pan.baidu.com/s/1l0FYTf8nATrPdEt6fXJ6Kg?pwd=1111
提取码：1111

将dll文件拖拽到Assets/Plugins

Assets下新建文件夹Editor，右键Editor点击Show in Explorer，新建Excel表格文件（后缀.xlsx），表格文件放在Assete/Editor中。

2.读取表格

引入命名空间 ：using OfficeOpenXml ; using System.IO;

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using OfficeOpenXml;
using System.IO;
public class NewRead : MonoBehaviour
{
    // Start is called before the first frame update
    void Start()
    {
        string filepath = Application.dataPath + "/Editor/内容.xlsx";
        //获取Excel文件的信息
        FileInfo fileInfo = new FileInfo(filepath);
        //通过Excel表格的文件信息，打开Excel表格
        using (ExcelPackage excelPackage = new ExcelPackage(fileInfo))
        {
            //对文件操作

            //取得第一张表
            ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets[1];
            //
            for (int i = worksheet.Dimension.Start.Row; i <= worksheet.Dimension.End.Row; i++)
            {
                for (int j = worksheet.Dimension.Start.Column; j <= worksheet.Dimension.End.Column; j++)
                {
                    string s = worksheet.Cells[i, j].Value.ToString();
                    Debug.Log(s);
                }
            }
        }//关闭文件
    }
}

ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets[1];读取第一个表格

worksheet为如图所示，且从1开始，不是从0开始。

3.写入表格

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using OfficeOpenXml;
using System.IO;
public class NewRead : MonoBehaviour
{
    // Start is called before the first frame update
    void Start()
    {
        string filepath = Application.dataPath + "/Editor/内容.xlsx";
        //获取Excel文件的信息
        FileInfo fileInfo = new FileInfo(filepath);
        //通过Excel表格的文件信息，打开Excel表格
        using (ExcelPackage excelPackage = new ExcelPackage(fileInfo))
        {
        	//对文件操作
 			worksheet.Cells[1, 1].Value = 20；
            //保存
            excelPackage.Save();
        }//关闭文件
    }
}

4.创建Excel表格

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using OfficeOpenXml;
using System.IO;
public class NewRead : MonoBehaviour
{
    // Start is called before the first frame update
    void Start()
    {
        string filepath = Application.dataPath + "/Editor/内容.xlsx";
        //获取Excel文件的信息
        FileInfo fileInfo = new FileInfo(filepath);
        //通过Excel表格的文件信息，打开Excel表格
        using (ExcelPackage excelPackage = new ExcelPackage(fileInfo))
        {
        	//对文件操作
        	//创建表
            ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("sheet1");
            excelPackage.Workbook.Worksheets.Add("sheet2");
            excelPackage.Workbook.Worksheets.Add("sheet3");
            //删除表
            ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Delete("sheet1");
            //保存
            excelPackage.Save();
        }//关闭文件
    }
}

5.打包

如果dll文件再Editor下，unity打包不会打包Editor内容。不会报错。

如果不在，则需要将unity的.net2.0子集改为.net2.0,打包才不会出错。