Unity 3D 创建和写入Excel

导入 EPPlus.dll

using System.IO;
using OfficeOpenXml;
using UnityEngine;

public class CreateAndWriteExcelMyTools : MonoBehaviour
{
    private void Start()
    {
        //--路径以及名称
        string filePath = Application.dataPath + "/../Excels/PlayersData.xlsx";
        string sheetName = "data";

        FileInfo fileInfo = new FileInfo(filePath);
        if (fileInfo.Exists)
        {
            fileInfo.Delete();
            fileInfo = new FileInfo(filePath);
        }

        using (ExcelPackage package = new ExcelPackage(fileInfo))
        {
            //在 excel 空文件添加新 sheet，并设置名称。
            ExcelWorksheet worksheet = package.Workbook.Worksheets.Add(sheetName);

            worksheet.Cells[1, 1].Value = "ID";
            worksheet.Cells[1, 2].Value = "name";
            worksheet.Cells[1, 3].Value = "age";

            worksheet.Cells[2, 1].Value = "1001";
            worksheet.Cells[2, 2].Value = "bob";
            worksheet.Cells[2, 3].Value = "20";

            worksheet.Cells[3, 1].Value = "1002";
            worksheet.Cells[3, 2].Value = "lily";
            worksheet.Cells[3, 3].Value = "18";

            package.Save();
        }
    }
}

编辑器模式

using System.IO;
using OfficeOpenXml;
using UnityEditor;
using UnityEngine;

public class CreateAndWriteExcelEditorMyTools
{
    [MenuItem("MyExcel/CreateAndWriteExcel", false, 1)]
    static void CreateAndWriteExcel()
    {
        //--路径以及名称
        string filePath = Application.dataPath + "/../Excels/PlayersData.xlsx";
        string sheetName = "data";

        FileInfo fileInfo = new FileInfo(filePath);
        if (fileInfo.Exists)
        {
            fileInfo.Delete();
            fileInfo = new FileInfo(filePath);
        }

        using (ExcelPackage package = new ExcelPackage(fileInfo))
        {
            //在 excel 空文件添加新 sheet，并设置名称。
            ExcelWorksheet worksheet = package.Workbook.Worksheets.Add(sheetName);

            worksheet.Cells[1, 1].Value = "ID";
            worksheet.Cells[1, 2].Value = "name";
            worksheet.Cells[1, 3].Value = "age";

            worksheet.Cells[2, 1].Value = "1001";
            worksheet.Cells[2, 2].Value = "bob";
            worksheet.Cells[2, 3].Value = "20";

            worksheet.Cells[3, 1].Value = "1002";
            worksheet.Cells[3, 2].Value = "lily";
            worksheet.Cells[3, 3].Value = "18";

            package.Save();
        }
    }
}

这个EPPlus.dll导致打包报错：

1.可能是DLL有问题这时可重新找一个试试。

2.API改为.net 2.0。