static void Main(string[] args)
{
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
var excelToJson = new ExcelToJson();
string json = excelToJson.OpenExcelAndToJson("../../../Res/Examples/ExampleData.xlsx");
Console.WriteLine(json);
}
private static void Init()
{
instance = GetWindow <ExcelToJson>();
pathRoot = Application.dataPath;
pathRoot = pathRoot.Substring(0, pathRoot.LastIndexOf("/"));
excelList = new List <string>();
scrollPos = new Vector2(instance.position.x, instance.position.y + 75);
}
static void DisplayerExcelToJsonWindow()
{
ExcelToJson excelToJsonWindow = EditorWindow.GetWindow <ExcelToJson>();//获取窗口对象
excelToJsonWindow.Show();
// 读取目录
ExcelObj = AssetDatabase.LoadAssetAtPath <UnityEngine.Object>(defaultExcelPath);
// 初始化输出目录
UnityEngine.Object outputObj = AssetDatabase.LoadAssetAtPath <UnityEngine.Object>(defaultJsonPath);
if (outputObj == null)
{
int endIndex = defaultJsonPath.LastIndexOf("/");
AssetDatabase.CreateFolder(defaultJsonPath.Substring(0, endIndex), defaultJsonPath.Substring(endIndex + 1));
outputObj = AssetDatabase.LoadAssetAtPath <UnityEngine.Object>(defaultJsonPath);
}
OutputDirectory = AssetDatabase.LoadAssetAtPath <UnityEngine.Object>(defaultJsonPath);
}
/// <summary>
/// 生成对应的CS文件
/// </summary>
void LoadCSVToCS()
{
foreach (string VARIABLE in ListOfFiles)
{
string result = Utility.LoacCSV(FilesPath + VARIABLE);
string FileName = VARIABLE.Remove(VARIABLE.Length - 4);
List <string> CaseList = new List <string>();
string[,] CSVresult = Utility.SplitCsvGrid(result);
Utility.DebugOutputGrid(CSVresult);
for (int i = 0; i < CSVresult.GetUpperBound(0) - 1; i++)
{
string ProPertyname = CSVresult[i, 0];
string ProPerty = CSVresult[i, 1];
string ProPertyString = "public {1} {0} __LK__ get; set; __RK__ ";
CaseList.Add("/// <summary>");
CaseList.Add("///" + ProPertyname);
CaseList.Add("/// <summary>");
CaseList.Add(string.Format(ProPertyString, ProPerty, "string"));
}
string CaseCode = string.Join("\r\n ", CaseList.ToArray());
string code = string.Format(BEHAVIOUR_FORMAT, FileName, CaseCode);
code = code.Replace("__LK__", "{");
code = code.Replace("__RK__", "}");
string path = Application.dataPath + UIVIEW_PATH;
string behaviourCodeFile = Path.Combine(path, FileName) + ".cs";
Utility.SaveStringToFile(behaviourCodeFile, code);
AssetDatabase.SaveAssets();
AssetDatabase.Refresh();
}
ExcelToJson.excelToJson();
}
