Esempio n. 1
0
        public List <object> ReadList(ISheet sheet)
        {
            Schema       schema = EDSchemaReader.ReadSchema(sheet);
            EDDataReader reader = new EDDataReader();

            return(EDDataReader.ReadList(sheet, schema));
        }
Esempio n. 2
0
        void DoLoad()
        {
            var xlsFile = EditorUtility.OpenFilePanel("load excel file", "", "xls;*.xlsx;");

            if (xlsFile.Length != 0)
            {
                m_Workbook = ExcelHelper.Load(xlsFile);
                //第一张表
                ISheet sheet = m_Workbook.GetSheetAt(0);

                m_Schema = EDSchemaReader.ReadSchema(sheet);

                //第一列为Key,其它为语言
                List <LangItem> list = new List <LangItem>();

                for (int i = 1; i < m_Schema.fields.Count; ++i)
                {
                    LangItem item = new LangItem();
                    item.name        = m_Schema.fields[i].name;
                    item.convertable = true;
                    list.Add(item);
                }

                m_LangItems = list.ToArray();
            }
        }
Esempio n. 3
0
        public static void TestData3()
        {
            string fileName = Application.dataPath + "/Tests/Editor/Gacha3.xlsx";

            IWorkbook    workbook = ExcelHelper.Load(fileName);
            ISheet       sheet    = workbook.GetSheetAt(0);
            Schema       schema   = EDSchemaReader.ReadSchema(sheet);
            EDDataReader reader   = new EDDataReader();

            List <object> dataList = EDDataReader.ReadList(sheet, schema);

            Debug.Log(dataList.Count);

            foreach (Dictionary <string, object> iter in dataList)
            {
                Debug.LogFormat("{0},{1},{2}", iter["name"], iter["probability"], iter["items"]);
                List <float> items = iter["items"] as List <float>;
                string       o     = "";
                foreach (float s in items)
                {
                    o += s + ",";
                }

                Debug.Log(o);
            }
        }
Esempio n. 4
0
        void ConvertSheet(ISheet sheet, string savePath, string tableName, string keyName)
        {
            Schema       schema = EDSchemaReader.ReadSchema(sheet);
            EDDataReader reader = new EDDataReader();
            object       dict   = EDDataReader.ReadDictionary(sheet, schema, keyName);

            string filename = Path.Combine(savePath, (string.IsNullOrEmpty(tableName) ? schema.name : tableName) + ".json");

            SaveToJsonFile(filename, dict);
        }
Esempio n. 5
0
        void ConvertSheet(ISheet sheet, string savePath, string schemaName)
        {
            Schema schema = EDSchemaReader.ReadSchema(sheet);

            schema.name = schemaName;

            CodeGen gen = new CodeGen();

            gen.ns = m_GenNamespace;
            gen.GenClass(schema, savePath);
        }
Esempio n. 6
0
        public static object GetLinkDict(ICell cell, string keyField, bool removeKeyFieldInElement = false)
        {
            if (cell == null || cell.StringCellValue == "")
            {
                return(null);
            }
            string       linkWhere = cell.StringCellValue;
            CellPosition cp;
            string       linkSheetName = ParseLinkCell(cell, out cp);

            ISheet linkSheet = cell.Sheet.Workbook.GetSheet(linkSheetName);
            Schema schema    = EDSchemaReader.ReadSchema(linkSheet);

            //内容要跳过2个头
            return(EDDataReader.ReadDictionary(linkSheet, schema, keyField, cp.row + EDConstance.SchemaDataRow, cp.col, null, removeKeyFieldInElement));
        }
Esempio n. 7
0
 //获取数组数据
 static object GetArrayData(ISheet sheet, int rowIndex, int colIndex, Type t)
 {
     if (t == typeof(int) || t == typeof(int?))
     {
         return(GetListInt(sheet, rowIndex, colIndex).ToArray());
     }
     else if (t == typeof(long) || t == typeof(long?))
     {
         return(GetListLong(sheet, rowIndex, colIndex).ToArray());
     }
     else if (t == typeof(float) || t == typeof(float?))
     {
         return(GetListFloat(sheet, rowIndex, colIndex).ToArray());
     }
     else if (t == typeof(double) || t == typeof(double?))
     {
         return(GetListDouble(sheet, rowIndex, colIndex).ToArray());
     }
     else if (t == typeof(string))
     {
         return(GetListString(sheet, rowIndex, colIndex).ToArray());
     }
     else if (t == typeof(bool) || t == typeof(bool?))
     {
         return(GetListBool(sheet, rowIndex, colIndex).ToArray());
     }
     else if (t == typeof(object))
     {
         Schema schema = EDSchemaReader.ReadSchema(sheet);
         return(EDDataReader.ReadList(sheet, schema).ToArray());
     }
     else
     {
         return(null);
     }
 }