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,打包才不会出错。文章来源:https://www.toymoban.com/news/detail-482203.html
文章来源地址https://www.toymoban.com/news/detail-482203.html
到了这里,关于Excel表格和Unity的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!