Client/GameClient/Assets/Editor/Excel/ExcelReader.cs

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

namespace GFGEditor
{
    public class ExcelReader
    {
        public delegate void RowCollectionHandler(ExcelWorksheet rowCollection, string configName, string configArrayName);

        public static void ReadExcel(RowCollectionHandler rowCollectionHandler)
        {
            string[] files = Directory.GetFiles(ExcelConfig.excelsFolderPath);
            int totalCount = files.Length;
            string strCfgArrayDispose = "";
            for (int i = 0; i < totalCount; i++)
            {
                string filePath = files[i];
                string fileName = Path.GetFileNameWithoutExtension(filePath);
                if (!fileName.Contains("~"))
                {
                    ET.Log.Debug($"fileName {fileName}");
                    Stream stream = new FileStream(filePath, FileMode.Open, FileAccess.Read, FileShare.Read);
                    ExcelPackage excelPackage = new ExcelPackage(stream);
                    //IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
                    //DataSet result = excelReader.AsDataSet();

                    HandleTableCollection(excelPackage.Workbook.Worksheets, rowCollectionHandler, out string dispose);
                    strCfgArrayDispose = strCfgArrayDispose + dispose;
                }
            }
            string functionDispose = CodeTemplateFactory.FunctionDisposeTemplate;
            functionDispose = functionDispose.Replace("{StrCfgArrayDispose}", strCfgArrayDispose);
            string disposeAllCfgsCache = CodeTemplateFactory.DisposeAllCfgsCacheTemplate;
            disposeAllCfgsCache = disposeAllCfgsCache.Replace("{FunctionDispose}", functionDispose);
            //创建管理类代码
            using (StreamWriter sw = new StreamWriter(ExcelConfig.configDataDisposePath + "DisposeAllCfgsCache.cs"))
            {
                sw.Write(disposeAllCfgsCache);
            }
        }

        private static void HandleTableCollection(ExcelWorksheets Worksheets, RowCollectionHandler rowCollectionHandler, out string strCfgArrayDispose)
        {
            strCfgArrayDispose = "";
            for (int i = 1; i <= Worksheets.Count; i++)
            {
                ExcelWorksheet worksheet = Worksheets[i];
                string configArrayName = HandleTable(worksheet, rowCollectionHandler);
                if (string.IsNullOrEmpty(configArrayName)) continue;
                string dispose = CodeTemplateFactory.StrCfgArrayDisposeTemplate.Replace("{configArrayName}", configArrayName);
                strCfgArrayDispose = strCfgArrayDispose + "\n" + dispose;
            }
        }

        private static string HandleTable(ExcelWorksheet worksheet, RowCollectionHandler rowCollectionHandler)
        {
            string[] names = worksheet.Name.Split('_');
            if (names.Length < 2)
            {
                //未正确命名的表格
                return "";
            }
            if (worksheet.Name.Contains("#"))
            {
                //被注释的表格
                return "";
            }
            string configItemName = names[1];
            string managerTag = "";
            if (names.Length > 2)
            {
                managerTag = names[2];
            }
            //文件名及管理器名
            string configManagerName = string.Format(ExcelConfig.CONFIG_ARRAY_TEMPLATE, configItemName, managerTag);

            rowCollectionHandler(worksheet, configItemName, configManagerName);

            return configManagerName;
        }

    }
}