导入 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。