将多个表格合并为一个表格的功能
首先需要配套的dll:
EPPlus.dll,Excel.dll,ICSharpCode,SharpZipLib.dll(版本适合很重要)
下面就是两个脚本的编辑:
- ExcelReadEditor
using OfficeOpenXml;
using System.IO;
using UnityEditor;
using UnityEngine;
public class ExcelReadEditor : Editor
{
static int num=5;
public static readonly string filePath = Application.streamingAssetsPath + "/Excel";
[MenuItem("Excel/读取测试数据")]
public static void CreateSignInData()
{
Data manager = CreateInstance<Data>(); //数据载体
string path = Application.streamingAssetsPath + "/AllExcel.xlsx";
FileInfo newFile = new FileInfo(path);
if (newFile.Exists)
{
//创建一个新的excel文件
newFile.Delete();
newFile = new FileInfo(path);
}
using (ExcelPackage package = new ExcelPackage(newFile))
{
ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("AllExcel");
int addNum = 2;
for (int n = 1; n <= num; n++)
{
manager.goods = ExcelRead.ReadGoodsExcel(filePath + n + ".xlsx");
//定义每一列的内容
worksheet.Cells[1, 1].Value =