Exemple #1
0
    private void DrawDataAreaUI()
    {
        EditorGUILayout.Space();

        GUIStyle helpBoxStyle = EditorStyleUtils.GetHelpBoxStyle();

        helpBoxStyle.richText = true;
        helpBoxStyle.fontSize = 15;

        EditorUtils.Horizontal(helpBoxStyle, () =>
        {
            EditorUtils.Vertical(helpBoxStyle, () => { DrawSheetNameList(); }, GUILayout.Width(m_LeftSheetWidth), GUILayout.ExpandHeight(true));
            EditorUtils.Vertical(helpBoxStyle, () => { DrawSheetList(); }, GUILayout.ExpandWidth(true), GUILayout.ExpandHeight(true));
        }, GUILayout.ExpandWidth(true), GUILayout.ExpandHeight(true));
    }
Exemple #2
0
    private void ShowExcelListArea()
    {
        m_SheetDataScrollPos = EditorGUILayout.BeginScrollView(m_SheetDataScrollPos);
        GUIStyle helpBoxStyle = EditorStyleUtils.GetHelpBoxStyle();

        EditorGUILayout.BeginVertical(helpBoxStyle);
        {
            for (int i = 0; i < m_ExcelPaths.Count; i++)
            {
                string path      = m_ExcelPaths[i];
                string excelName = m_ExcelPaths[i].Replace(m_ExcelOpenPath, "");
                bool   selected  = m_ExcelSelectedPaths.Contains(path);
                // GUI.color = Color.green;
                EditorGUILayout.BeginHorizontal();
                {
                    if (selected != EditorGUILayout.ToggleLeft(excelName, selected, GUILayout.Height(20)))
                    {
                        if (selected)
                        {
                            m_ExcelSelectedPaths.Remove(path);
                        }
                        else
                        {
                            m_ExcelSelectedPaths.Add(path);
                        }

                        EditorPrefs.SetBool(path, !selected);
                    }

                    if (GUILayout.Button("Review", GUILayout.Width(60), GUILayout.Height(20)))
                    {
                        EditorWindow.GetWindow <ExcelExporter>().titleContent =
                            new GUIContent(Path.GetFileNameWithoutExtension(path));
                        EditorWindow.GetWindow <ExcelExporter>().sheets = m_ExcelReader.Load(path);
                    }
                }
                EditorGUILayout.EndHorizontal();
                GUI.color = Color.white;
            }
        }
        EditorGUILayout.EndVertical();
        EditorGUILayout.EndScrollView();
    }
Exemple #3
0
    private void ShowDirectoryArea()
    {
        GUIStyle helpBoxStyle = EditorStyleUtils.GetHelpBoxStyle();

        EditorGUILayout.BeginVertical(helpBoxStyle);
        {
            GUIStyle textFieldStyle = EditorStyleUtils.GetTextFieldStyle();
            textFieldStyle.fontSize  = 13;
            textFieldStyle.alignment = TextAnchor.MiddleLeft;

            EditorGUILayout.BeginHorizontal();
            {
                EditorGUILayout.LabelField("Export Class : " + m_ExcelClassPath.Replace(Application.dataPath, "Assets"),
                                           textFieldStyle, GUILayout.Height(30));
            }
            EditorGUILayout.EndHorizontal();
            EditorGUILayout.BeginHorizontal();
            {
                EditorGUILayout.TextField(m_ExcelOpenPath, textFieldStyle, GUILayout.Height(30));
                // GUI.color = Color.green;
                if (GUILayout.Button("Load Excel Path", GUILayout.Width(120), GUILayout.Height(30)))
                {
                    string path = EditorUtility.OpenFolderPanel("Select Excel Path", "", "");
                    if (path != "")
                    {
                        m_ExcelOpenPath = path + "/";
                        EditorPrefs.SetString(m_ExcelOpenPathKey, m_ExcelOpenPath);
                        m_ExcelSelectedPaths.Clear();
                        m_ExcelPaths.Clear();
                        OpenExcelFolder();
                        EditorGUIUtility.ExitGUI();
                    }
                }

                GUI.color = Color.white;
            }
            EditorGUILayout.EndHorizontal();
            EditorGUILayout.BeginHorizontal();
            {
                EditorGUILayout.TextField(m_ExcelDataPath, textFieldStyle, GUILayout.Height(30));
                // GUI.color = Color.green;
                if (GUILayout.Button("Export Data Path", GUILayout.Width(120), GUILayout.Height(30)))
                {
                    string path = EditorUtility.OpenFolderPanel("Select Data Path", "", "");
                    if (path != "")
                    {
                        m_ExcelDataPath = path + "/";
                        EditorPrefs.SetString(m_ExcelDataPathKey, m_ExcelDataPath);
                    }
                }

                GUI.color = Color.white;
            }
            EditorGUILayout.EndHorizontal();
            EditorGUILayout.BeginHorizontal();
            {
                // GUI.color = Color.green;
                if (m_SelectedClearFolder !=
                    EditorGUILayout.ToggleLeft("Clear Folder", m_SelectedClearFolder, GUILayout.Height(20)))
                {
                    m_SelectedClearFolder = !m_SelectedClearFolder;
                    EditorPrefs.SetBool(m_SelectedClearFolderKey, m_SelectedClearFolder);
                }

                if (GUILayout.Button(EditorGUIUtility.FindTexture("Refresh"), GUILayout.Width(30),
                                     GUILayout.Height(30)))
                {
                    m_ExcelSelectedPaths.Clear();
                    m_ExcelPaths.Clear();
                    OpenExcelFolder();
                    EditorGUIUtility.ExitGUI();
                }

                if (GUILayout.Button("Select All", GUILayout.Width(80), GUILayout.Height(30)))
                {
                    for (int i = 0; i < m_ExcelPaths.Count; i++)
                    {
                        string path = m_ExcelPaths[i];
                        m_ExcelSelectedPaths.Add(path);
                        EditorPrefs.SetBool(path, true);
                    }
                }

                if (GUILayout.Button("Unselect All", GUILayout.Width(80), GUILayout.Height(30)))
                {
                    for (int i = 0; i < m_ExcelPaths.Count; i++)
                    {
                        string path = m_ExcelPaths[i];
                        m_ExcelSelectedPaths.Remove(path);
                        EditorPrefs.SetBool(path, false);
                    }
                }

                GUI.color = Color.white;
            }
            EditorGUILayout.EndHorizontal();
        }
        EditorGUILayout.EndVertical();
    }
Exemple #4
0
    private void ShowExecuteArea()
    {
        GUIStyle helpBoxStyle   = EditorStyleUtils.GetHelpBoxStyle();
        GUIStyle textFieldStyle = EditorStyleUtils.GetTextFieldStyle();

        textFieldStyle.fontSize  = 13;
        textFieldStyle.alignment = TextAnchor.MiddleLeft;

        EditorGUILayout.BeginVertical(helpBoxStyle);
        {
            // GUI.color = Color.green;
            EditorGUILayout.BeginHorizontal();
            {
                // GUI.color = Color.green;
                if (GUILayout.Button("Create Excel Class", GUILayout.Height(30)))
                {
                    if (m_SelectedClearFolder)
                    {
                        EditorUtils.DeleteDirectory(m_ExcelClassPath);
                    }

                    int sheetIndex = 0;
                    int count      = m_ExcelSelectedPaths.Count;
                    for (int i = 0; i < count; i++)
                    {
                        string   path           = m_ExcelSelectedPaths[i];
                        string   tableClassName = "";
                        string   tableNoteName  = "";
                        string[] tableName      = Path.GetFileNameWithoutExtension(path).Split('_');
                        tableClassName = tableName[0];
                        if (tableName.Length > 1)
                        {
                            tableNoteName = tableName[1];
                        }

                        Dictionary <string, List <List <ICell> > > sheets = m_ExcelReader.Load(path);
                        foreach (KeyValuePair <string, List <List <ICell> > > keyPair in sheets)
                        {
                            string sheetName = keyPair.Key;
                            EditorUtility.DisplayProgressBar("Info",
                                                             "Create Excel Class : " + (i + 1) + "/" + count + " " + tableClassName + ".cs",
                                                             ((i + 1) / count) * 100);
                            m_ExcelClassCreator.Create(sheetIndex, m_ExcelClassPath, tableClassName, tableNoteName,
                                                       sheetName, keyPair.Value);
                            sheetIndex++;
                        }
                    }

                    if (count > 0)
                    {
                        m_ExcelClassCreator.CreateManager(m_ExcelPaths, m_ExcelSelectedPaths, m_ExcelReader);
                        AssetDatabase.Refresh();
                        EditorUtility.ClearProgressBar();
                        EditorUtility.DisplayDialog("Success", "Create excel class successfully .", "OK");
                        EditorGUIUtility.ExitGUI();
                    }
                    else
                    {
                        EditorUtility.DisplayDialog("Worning", "Select some excel files(.xls or .xlsx) , please .",
                                                    "OK");
                    }
                }

                if (GUILayout.Button("Create Excel Data", GUILayout.Height(30)))
                {
                    if (m_SelectedClearFolder)
                    {
                        EditorUtils.DeleteDirectory(m_ExcelDataPath);
                    }

                    Directory.CreateDirectory(m_ExcelDataPath);
                    Assembly assembly = Assembly.Load("Assembly-CSharp");
                    for (int i = 0; i < m_ExcelSelectedPaths.Count; i++)
                    {
                        string   path           = m_ExcelSelectedPaths[i];
                        string[] tableName      = Path.GetFileNameWithoutExtension(path).Split('_');
                        string   tableClassName = tableName[0];
                        Dictionary <string, List <List <ICell> > > sheets = m_ExcelReader.Load(path);
                        foreach (KeyValuePair <string, List <List <ICell> > > keyPair in sheets)
                        {
                            string sheetName = keyPair.Key;

                            Type tableType = assembly.GetType(tableClassName);
                            UnityEngine.Object container = (UnityEngine.Object)Activator.CreateInstance(tableType);
                            FieldInfo          dataList  = tableType.GetField("dataList");

                            Type dataType  = assembly.GetType(tableClassName + "_Data");
                            var  modelList =
                                Activator.CreateInstance(typeof(List <>).MakeGenericType(new Type[] { dataType }));

                            AssetDatabase.CreateAsset(container,
                                                      m_ExcelDataPath.Replace(Application.dataPath, "Assets") + tableClassName + "_" +
                                                      sheetName + ".asset");

                            List <ICell> nameRow = keyPair.Value[0];
                            List <ICell> typeRow = keyPair.Value[1];
                            List <ICell> noteRow = keyPair.Value[2];
                            for (int row = 3; row < keyPair.Value.Count; row++)
                            {
                                UnityEngine.Object data       = (UnityEngine.Object)Activator.CreateInstance(dataType);
                                List <ICell>       contentRow = keyPair.Value[row];
                                for (int column = 0; column < nameRow.Count; column++)
                                {
                                    FieldInfo fieldInfo = dataType.GetField(nameRow[column].StringCellValue);
                                    object    value     = ExcelConvertUtility.GetCellValue(contentRow[column]);
                                    Debug.Log(tableClassName + "_" + sheetName + "_" + row + "_" + column + "_" +
                                              typeRow[column] + "_" + typeRow[column].StringCellValue);
                                    fieldInfo.SetValue(data,
                                                       ExcelConvertUtility.GetConvertType(typeRow[column].StringCellValue, value));
                                }

                                var addMethod = modelList.GetType().GetMethod("Add");
                                addMethod.Invoke(modelList, new object[] { data });
                                dataList.SetValue(container, modelList);

                                data.name = dataType.ToString();
                                AssetDatabase.AddObjectToAsset(data,
                                                               m_ExcelDataPath.Replace(Application.dataPath, "Assets") + tableClassName + "_" +
                                                               sheetName + ".asset");
                            }

                            EditorUtility.SetDirty(container);
                            EditorUtility.DisplayProgressBar("Info",
                                                             "Create Excel Data : " + (i + 1) + "/" + m_ExcelSelectedPaths.Count + " " +
                                                             tableClassName + "_" + sheetName, (i / m_ExcelSelectedPaths.Count) * 100);
                        }
                    }

                    AssetDatabase.SaveAssets();
                    AssetDatabase.Refresh();
                    EditorUtility.ClearProgressBar();
                    EditorUtility.DisplayDialog("Success", "Create excel data successfully .", "OK");
                    EditorGUIUtility.ExitGUI();
                }

                GUI.color = Color.white;
            }
            EditorGUILayout.EndHorizontal();
        }
        EditorGUILayout.EndVertical();
    }