416 lines
15 KiB
C#
416 lines
15 KiB
C#
|
||
using System.Collections.Generic;
|
||
using UnityEngine;
|
||
using UnityEditor;
|
||
using System.Data;
|
||
using Excel;
|
||
using System.IO;
|
||
using LitJson;
|
||
using System.Text;
|
||
using System.Text.RegularExpressions;
|
||
using System;
|
||
using System.Reflection;
|
||
using System.CodeDom;
|
||
using System.CodeDom.Compiler;
|
||
|
||
namespace ZXKFrameworkEditor
|
||
{
|
||
public class ExcelToJson : EditorWindow
|
||
{
|
||
private string JsonPath;
|
||
string CSharpPath;
|
||
string JsonName;
|
||
List<string> dataDoc = new List<string>();
|
||
List<string> dataType = new List<string>();
|
||
List<string> dataName = new List<string>();
|
||
List<string[]> ExcelDateList = new List<string[]>();
|
||
List<string> allDataClassName = new List<string>();//所有类名
|
||
StringBuilder allFindUnc = new StringBuilder();
|
||
string nameSpace = "";
|
||
|
||
[UnityEditor.MenuItem("ZXKFramework/ExcelToJson")]
|
||
static void ExceltoJson()
|
||
{
|
||
ExcelToJson toJson = (ExcelToJson)EditorWindow.GetWindow(typeof(ExcelToJson), true, "ExcelToJson");
|
||
toJson.Show();
|
||
}
|
||
|
||
private void OnGUI()
|
||
{
|
||
GUILayout.Label("---配表代码自动生成---", EditorStyles.boldLabel);
|
||
GUILayout.BeginHorizontal();
|
||
GUILayout.Label("命名空间:(选填，用于代码隔离)");
|
||
nameSpace = GUILayout.TextField(nameSpace, GUILayout.Width(300));
|
||
GUILayout.EndHorizontal();
|
||
if (GUILayout.Button("选择需要转换的excel文件"))
|
||
{
|
||
GetAllExcelPath();
|
||
}
|
||
}
|
||
|
||
#region Excel文件处理
|
||
void GetAllExcelPath()
|
||
{
|
||
EditorTools.CreateDirectory(Application.dataPath + "/Resources/ExcelData/Excel");
|
||
EditorTools.CreateDirectory(Application.dataPath + "/Resources/ExcelData/CSharpPath");
|
||
EditorTools.CreateDirectory(Application.dataPath + "/Resources/ExcelData/ExcelToJson");
|
||
|
||
string loPath = Application.dataPath + "/Resources/ExcelData/Excel";
|
||
DirectoryInfo dir = new DirectoryInfo(loPath);
|
||
FileInfo[] fil = dir.GetFiles();
|
||
allDataClassName.Clear();
|
||
foreach (FileInfo f in fil)
|
||
{
|
||
if (f.FullName.EndsWith(".meta"))
|
||
{
|
||
continue;
|
||
}
|
||
Debug.Log(f.FullName);
|
||
ReadExcel(f.FullName.Replace("\\", "/"), Path.GetFileNameWithoutExtension(f.Name));
|
||
}
|
||
CreatCSharpExcelData();
|
||
AssetDatabase.Refresh();
|
||
Debug.Log("生成成功");
|
||
}
|
||
|
||
/// <summary>
|
||
/// 读取Excel
|
||
/// </summary>
|
||
/// <param name="path">excel路径</param>
|
||
/// <param name="columnNum">列</param>
|
||
/// <param name="rowNum">行</param>
|
||
void ReadExcel(string path, string fileName)
|
||
{
|
||
FileStream stream = File.Open(path, FileMode.Open, FileAccess.Read, FileShare.Read);
|
||
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
|
||
DataSet data = excelReader.AsDataSet();
|
||
|
||
dataDoc.Clear();
|
||
dataName.Clear();
|
||
dataType.Clear();
|
||
ExcelDateList.Clear();
|
||
|
||
//读取Excel的所有页签
|
||
for (int i = 0; i < data.Tables.Count; i++)
|
||
{
|
||
//i代表每一页，一般只有一页，下面为每一页的每一行 每一列
|
||
DataRowCollection dataRow = data.Tables[i].Rows; // 每行
|
||
DataColumnCollection dataColumn = data.Tables[i].Columns; // 每列
|
||
|
||
string tableName = fileName;
|
||
JsonName = fileName + ".json";
|
||
JsonPath = UnityEngine.Application.dataPath + "/Resources/ExcelData/ExcelToJson/" + JsonName;
|
||
//循环，第一行
|
||
for (int rowNum = 0; rowNum < data.Tables[i].Rows.Count; rowNum++)
|
||
{
|
||
//第一行的每一列
|
||
string[] table = new string[data.Tables[i].Columns.Count];
|
||
for (int columnNum = 0; columnNum < data.Tables[i].Columns.Count; columnNum++)
|
||
{
|
||
if (rowNum == 0)
|
||
{
|
||
//第一行：解释说明
|
||
}
|
||
else if (rowNum == 1)
|
||
{
|
||
dataDoc.Add(data.Tables[i].Rows[rowNum][columnNum].ToString());
|
||
}
|
||
else if (rowNum == 2)
|
||
{
|
||
dataType.Add(data.Tables[i].Rows[rowNum][columnNum].ToString());
|
||
}
|
||
else if (rowNum == 3)
|
||
{
|
||
dataName.Add(data.Tables[i].Rows[rowNum][columnNum].ToString());
|
||
}
|
||
else
|
||
{
|
||
//Debug.Log(data.Tables[i].Rows[rowNum][columnNum].ToString() + "\n");
|
||
table[columnNum] = data.Tables[i].Rows[rowNum][columnNum].ToString();
|
||
}
|
||
}
|
||
if (rowNum > 3)
|
||
{
|
||
//将一行数据存入list
|
||
ExcelDateList.Add(table);
|
||
}
|
||
}
|
||
CreatJsonFile();
|
||
//CreatCSharp(tableName);
|
||
CreatCSharpString(tableName);
|
||
allDataClassName.Add(tableName);
|
||
|
||
for (int j = 0; j < dataName.Count; j++)
|
||
{
|
||
string fangFaBase = @"
|
||
public # Get#*(% *)
|
||
{
|
||
for (int i = 0; i < all#.Count; i++)
|
||
{
|
||
if (all#[i].* == *)
|
||
{
|
||
return all#[i];
|
||
}
|
||
}
|
||
Debug.LogError(*);
|
||
return null;
|
||
}
|
||
|
||
public List<%> GetList#*()
|
||
{
|
||
List<%> res = new List<%>();
|
||
for (int i = 0; i < all#.Count; i++)
|
||
{
|
||
if (!res.Contains(all#[i].*))
|
||
{
|
||
res.Add(all#[i].*);
|
||
}
|
||
}
|
||
return res;
|
||
}
|
||
|
||
";
|
||
fangFaBase = fangFaBase.Replace("#", tableName);
|
||
fangFaBase = fangFaBase.Replace("*", dataName[j]);
|
||
fangFaBase = fangFaBase.Replace("%", dataType[j]);
|
||
allFindUnc.AppendLine(fangFaBase);
|
||
|
||
List<string> res = new List<string>();
|
||
|
||
}
|
||
}
|
||
}
|
||
|
||
#endregion
|
||
|
||
#region Excel转json
|
||
void CreatJsonFile()
|
||
{
|
||
if (File.Exists(JsonPath))
|
||
{
|
||
File.Delete(JsonPath);
|
||
}
|
||
JsonData jsonDatas = new JsonData();
|
||
jsonDatas.SetJsonType(JsonType.Array);
|
||
for (int i = 0; i < ExcelDateList.Count; i++)
|
||
{
|
||
JsonData jsonData = new JsonData();
|
||
for (int j = 0; j < dataName.Count; j++)
|
||
{
|
||
string tempData = dataType[j].Trim();
|
||
string loData = ExcelDateList[i][j].Trim();
|
||
//Debug.Log("类型 " + tempData + " " + loData);
|
||
try
|
||
{
|
||
switch (tempData)
|
||
{
|
||
case "int":
|
||
int resInt = 0;
|
||
if (!string.IsNullOrEmpty(loData))
|
||
{
|
||
resInt = Int32.Parse(loData);
|
||
}
|
||
jsonData[dataName[j]] = resInt;
|
||
break;
|
||
case "float":
|
||
float resFloat = 0;
|
||
if (!string.IsNullOrEmpty(loData))
|
||
{
|
||
resFloat = float.Parse(loData);
|
||
}
|
||
jsonData[dataName[j]] = resFloat;
|
||
break;
|
||
case "double":
|
||
double resDouble = 0;
|
||
if (!string.IsNullOrEmpty(loData))
|
||
{
|
||
resDouble = double.Parse(loData);
|
||
}
|
||
jsonData[dataName[j]] = resDouble;
|
||
break;
|
||
case "bool":
|
||
bool resBool = false;
|
||
if (!string.IsNullOrEmpty(loData))
|
||
{
|
||
resBool = bool.Parse(loData);
|
||
}
|
||
jsonData[dataName[j]] = resBool;
|
||
break;
|
||
default:
|
||
jsonData[dataName[j]] = loData;
|
||
break;
|
||
}
|
||
}
|
||
catch (Exception e)
|
||
{
|
||
Debug.LogError(e);
|
||
return;
|
||
}
|
||
}
|
||
jsonDatas.Add(jsonData);
|
||
}
|
||
string json = jsonDatas.ToJson();
|
||
//防止中文乱码
|
||
Regex reg = new Regex(@"(?i)\\[uU]([0-9a-f]{4})");
|
||
StreamWriter writer = new StreamWriter(JsonPath, false, Encoding.GetEncoding("UTF-8"));
|
||
writer.WriteLine(reg.Replace(json, delegate (Match m)
|
||
{
|
||
return ((char)Convert.ToInt32(m.Groups[1].Value, 16)).ToString();
|
||
}));
|
||
writer.Flush();
|
||
writer.Close();
|
||
//System.Diagnostics.Process.Start("explorer.exe", JsonPath.Replace("/", "\\"));
|
||
}
|
||
#endregion
|
||
|
||
//#region 创建C#代码
|
||
//void CreatCSharp(string name)
|
||
//{
|
||
// CSharpPath = UnityEngine.Application.dataPath + "/Resources/ExcelData/CSharpPath/" + name + ".cs";
|
||
// if (File.Exists(CSharpPath)) File.Delete(CSharpPath);
|
||
|
||
// //CodeTypeDeclaration 代码类型声明类
|
||
// CodeTypeDeclaration CSharpClass = new CodeTypeDeclaration(name);
|
||
// CSharpClass.IsClass = true;
|
||
// CSharpClass.TypeAttributes = TypeAttributes.Public;
|
||
|
||
// //设置成员的自定义属性
|
||
// //CodeAttributeDeclaration代码属性声明
|
||
// //CodeTypeReference代码类型引用类
|
||
// //System.Serializable 给脚本打上[System.Serializable()]标签，将 成员变量 在Inspector中显示
|
||
// CSharpClass.CustomAttributes.Add(new CodeAttributeDeclaration(new CodeTypeReference("System.Serializable")));
|
||
|
||
// for (int i = 0; i < dataName.Count; i++)
|
||
// {
|
||
// // 创建字段
|
||
// //CodeMemberField 代码成员字段类 => (Type, string name)
|
||
// CodeMemberField member = new CodeMemberField(GetTypeForExcel(dataType[i]), dataName[i] + ";//" + dataDoc[i]);
|
||
// member.Attributes = MemberAttributes.Public;
|
||
// CSharpClass.Members.Add(member);
|
||
// }
|
||
|
||
// // 获取C#语言的实例
|
||
// CodeDomProvider provider = CodeDomProvider.CreateProvider("CSharp");
|
||
// //代码生成器选项类
|
||
// CodeGeneratorOptions options = new CodeGeneratorOptions();
|
||
// //设置支撑的样式
|
||
// options.BracingStyle = "C";
|
||
// //在成员之间插入空行
|
||
// options.BlankLinesBetweenMembers = true;
|
||
// StreamWriter writer = new StreamWriter(CSharpPath, false, Encoding.GetEncoding("UTF-8"));
|
||
// //生成最终代码
|
||
// provider.GenerateCodeFromType(CSharpClass, writer, options);
|
||
// writer.Flush();
|
||
// writer.Close();
|
||
// //System.Diagnostics.Process.Start("explorer.exe", CSharpPath.Replace("/", "\\"));
|
||
//}
|
||
|
||
StringBuilder str = new StringBuilder();
|
||
void CreatCSharpString(string name)
|
||
{
|
||
string fangFaBase = @"
|
||
namespace ZXKFramework
|
||
{
|
||
public class $
|
||
{
|
||
*
|
||
}
|
||
}
|
||
";
|
||
if (!string.IsNullOrEmpty(nameSpace))
|
||
{
|
||
fangFaBase = fangFaBase.Replace("ZXKFramework", nameSpace);
|
||
}
|
||
fangFaBase = fangFaBase.Replace("$", name);
|
||
str.Length = 0;
|
||
for (int i = 0; i < dataName.Count; i++)
|
||
{
|
||
str.Append("//" + dataDoc[i]);
|
||
str.Append("\n\r");
|
||
str.Append("public " + dataType[i] + " " + dataName[i] + ";");
|
||
str.Append("\n\r");
|
||
}
|
||
fangFaBase = fangFaBase.Replace("*", str.ToString());
|
||
string loPath = Application.dataPath + "/Resources/ExcelData/CSharpPath/" + name + ".cs";
|
||
if (File.Exists(loPath)) File.Delete(loPath);
|
||
File.WriteAllText(loPath, fangFaBase, Encoding.UTF8);
|
||
}
|
||
|
||
Type GetTypeForExcel(string Type)
|
||
{
|
||
if (Type == "int")
|
||
return typeof(Int32);
|
||
if (Type == "float")
|
||
return typeof(Single); //float关键字是System.Single的别名
|
||
if (Type == "double")
|
||
return typeof(Double);
|
||
if (Type == "bool")
|
||
return typeof(Boolean);
|
||
return typeof(String);
|
||
}
|
||
|
||
public static string classPath = "_Scripts/ExcelData.cs";
|
||
private static string classTemp =
|
||
@"
|
||
using System.Collections.Generic;
|
||
using UnityEngine;
|
||
namespace ZXKFramework
|
||
{
|
||
public class ExcelData
|
||
{
|
||
//@ShuXing
|
||
public void Init()
|
||
{
|
||
//@FuZhi
|
||
}
|
||
//@FangFa
|
||
}
|
||
}
|
||
";
|
||
|
||
public void CreatCSharpExcelData()
|
||
{
|
||
StringBuilder sx = new StringBuilder();
|
||
StringBuilder fz = new StringBuilder();
|
||
StringBuilder ff = new StringBuilder();
|
||
|
||
for (int i = 0; i < allDataClassName.Count; i++)
|
||
{
|
||
string dataName = allDataClassName[i];
|
||
sx.AppendLine($"public List<{dataName}> all{dataName} = null;");
|
||
fz.AppendLine($"all{dataName} = ExcelDataTools.GetDataList<{dataName}>();");
|
||
|
||
string fangFaBase = @"
|
||
public # Get#(int id)
|
||
{
|
||
for (int i = 0; i < all#.Count; i++)
|
||
{
|
||
if (all#[i].id == id)
|
||
{
|
||
return all#[i];
|
||
}
|
||
}
|
||
Debug.LogError(id);
|
||
return null;
|
||
}";
|
||
fangFaBase = fangFaBase.Replace("#", dataName);
|
||
ff.AppendLine(fangFaBase);
|
||
};
|
||
|
||
ff.AppendLine(allFindUnc.ToString());
|
||
allFindUnc.Length = 0;
|
||
|
||
string codeClass = classTemp.Replace("//@ShuXing", sx.ToString());
|
||
codeClass = codeClass.Replace("//@FuZhi", fz.ToString());
|
||
codeClass = codeClass.Replace("//@FangFa", ff.ToString());
|
||
if (!string.IsNullOrEmpty(nameSpace))
|
||
{
|
||
codeClass = codeClass.Replace("ZXKFramework", nameSpace);
|
||
}
|
||
string path = Path.Combine(Application.dataPath, classPath);
|
||
File.WriteAllText(path, codeClass, Encoding.UTF8);
|
||
Debug.Log($"ExcelData生成完毕");
|
||
}
|
||
|
||
}
|
||
} |