示例#1
0
    public void LoadGoogleSheetsPalette(string url)
    {
        //Download CSV from Public Google Sheets
        string csvurl = "";

        if (url.Substring(url.LastIndexOf("/")).Length < 25)
        {
            csvurl = url.Substring(0, url.LastIndexOf("/")) + "/export?format=csv&gid=0";
        }
        else
        {
            csvurl = url + "/export?format=csv&gid=0";
        }
        Debug.Log(csvurl);
        WWW data = new WWW(csvurl);

        while (!data.isDone)
        {
        }
        //Load CSV
        string[][] table = CsvParser2.Parse(data.text);
        string     title = GetGoogleSheetTitle(url);

        LoadPalette(table, title);
    }
    public static string Generate(string csvText, string className)
    {
        if (string.IsNullOrEmpty(csvText))
        {
            return(null);
        }

        string[][] grid = CsvParser2.Parse(csvText);
        if (grid.Length < 1)
        {
            return(null);
        }

        string rowMemberCode = "";
        string rowReadCode   = "";
        string findCode      = "";

        for (int i = 0; i < grid[0].Length; i++)
        {
            rowMemberCode += string.Format("\t\tpublic string {0};\n", grid[0][i]);
            rowReadCode   += string.Format("\t\t\trow.{0} = grid[i][{1}];\n", grid[0][i], i);
            findCode      += findCodeTemplate.Replace("$COLUMN", grid[0][i]);
        }

        string code = codeTemplate;

        code = code.Replace("$CLASS", className);
        code = code.Replace("$ROW_MEMBER_CODE", rowMemberCode);
        code = code.Replace("$ROW_READ_CODE", rowReadCode);
        code = code.Replace("$FIND_CODE", findCode);

        return(code);
    }
示例#3
0
    void OnGUI()
    {
        TextAsset newCsv = EditorGUILayout.ObjectField("CSV", csv, typeof(TextAsset), false) as TextAsset;

        if (newCsv != csv)
        {
            csv = newCsv;
            arr = CsvParser2.Parse(csv.text);
        }
        if (GUILayout.Button("Refresh") && csv != null)
        {
            arr = CsvParser2.Parse(csv.text);
        }

        if (csv == null)
        {
            return;
        }

        if (arr == null)
        {
            arr = CsvParser2.Parse(csv.text);
        }

        for (int i = 0; i < arr.Length; i++)
        {
            EditorGUILayout.BeginHorizontal();
            for (int j = 0; j < arr[i].Length; j++)
            {
                EditorGUILayout.TextField(arr[i][j]);
            }
            EditorGUILayout.EndHorizontal();
        }
    }
示例#4
0
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.id         = grid[i][0];
            row.health1    = grid[i][1];
            row.health2    = grid[i][2];
            row.maxspd     = grid[i][3];
            row.accel      = grid[i][4];
            row.jumpheight = grid[i][5];
            row.jumpforce  = grid[i][6];
            row.atk1       = grid[i][7];
            row.atk2       = grid[i][8];
            row.atkrate1   = grid[i][9];
            row.atkrate2   = grid[i][10];
            row.numlives   = grid[i][11];
            row.playerno   = grid[i][12];
            row.mobno      = grid[i][13];
            row.addno      = grid[i][14];
            row.bossno     = grid[i][15];

            rowList.Add(row);
        }
        isLoaded = true;
    }
示例#5
0
        /// <summary>
        /// Loads stage from a csv file.
        /// </summary>
        /// <param name="filename">File to be loaded.</param>
        /// <returns></returns>
        public static StageModel LoadStageFromFile(string filename)
        {
            var path = _stagesPath + filename;

            if (!File.Exists(path))
            {
                throw new FileNotFoundException($"Stage file '{path}' not found!");
            }

            var data = FileManager.ReadAllLines(path);

            CleanData(ref data, path);

            var stageHeader = $"{data[0]}\n{data[1]}";
            var grid        = CsvParser2.Parse(stageHeader);

            var stageInfo = new StageModel
            {
                //header
                Id                  = int.Parse(grid[1][0]),
                Phase               = int.Parse(grid[1][1]),
                Level               = int.Parse(grid[1][2]),
                ObjectSpeedFactor   = Parsers.Float(grid[1][3]),
                HeightIncrement     = Parsers.Float(grid[1][4]),
                HeightUpThreshold   = int.Parse(grid[1][5]),
                HeightDownThreshold = int.Parse(grid[1][6]),
                SizeIncrement       = Parsers.Float(grid[1][7]),
                SizeUpThreshold     = int.Parse(grid[1][8]),
                SizeDownThreshold   = int.Parse(grid[1][9]),
                Loops               = int.Parse(grid[1][10]),
            };

            stageInfo.Loops = stageInfo.Loops == 0 ? 1 : stageInfo.Loops;

            var template = "ObjectType;DifficultyFactor;PositionYFactor;PositionXSpacing";

            // Read each line from the file to get objects to spawn
            for (int i = 2; i < data.Length; i++)
            {
                if (data[i].StartsWith("%") || string.IsNullOrEmpty(data[i]))
                {
                    continue;
                }

                var modelGrid = CsvParser2.Parse($"{template}\n{data[i]}");

                var model = new ObjectModel
                {
                    Id               = i,
                    Type             = (StageObjectType)Enum.Parse(typeof(StageObjectType), (modelGrid[1][0])),
                    DifficultyFactor = Parsers.Float(modelGrid[1][1]),
                    PositionYFactor  = Parsers.Float(modelGrid[1][2]),
                    PositionXSpacing = Parsers.Float(modelGrid[1][3]),
                };

                stageInfo.ObjectModels.Add(model);
            }

            return(stageInfo);
        }
    public static string Generate(string csvText, string className)
    {
        if (string.IsNullOrEmpty(csvText))
        {
            return(null);
        }

        var grid = CsvParser2.Parse(csvText);

        if (grid.Length < 1)
        {
            return(null);
        }

        var rowMemberCode = "";
        var rowReadCode   = "";
        var findCode      = "";

        for (var i = 0; i < grid[0].Length; i++)
        {
            rowMemberCode += $"\t\tpublic string {grid[0][i]};\n";
            rowReadCode   += $"\t\t\trow.{grid[0][i]} = grid[i][{i}];\n";
            findCode      += findCodeTemplate.Replace("$COLUMN", grid[0][i]);
        }

        var code = codeTemplate;

        code = code.Replace("$CLASS", className);
        code = code.Replace("$ROW_MEMBER_CODE", rowMemberCode);
        code = code.Replace("$ROW_READ_CODE", rowReadCode);
        code = code.Replace("$FIND_CODE", findCode);

        return(code);
    }
示例#7
0
    private void OnGUI()
    {
        var newCsv = EditorGUILayout.ObjectField("CSV", csv, typeof(TextAsset), false) as TextAsset;

        if (newCsv != csv)
        {
            csv = newCsv;
            arr = CsvParser2.Parse(csv.text);
        }

        if (GUILayout.Button("Refresh") && csv != null)
        {
            arr = CsvParser2.Parse(csv.text);
        }

        if (csv == null)
        {
            return;
        }

        if (arr == null)
        {
            arr = CsvParser2.Parse(csv.text);
        }

        foreach (var t in arr)
        {
            EditorGUILayout.BeginHorizontal();
            foreach (var t1 in t)
            {
                EditorGUILayout.TextField(t1);
            }
            EditorGUILayout.EndHorizontal();
        }
    }
示例#8
0
        private void ImportRows(DatablockDetectionInfo datablockDetectionInfo)
        {
            using (TextReader reader = File.OpenText(csvFilePath))
            {
                var parser = new CsvParser2();
                parser.TrimTrailingEmptyLines = true;
                string[][] parsed = parser.Parse(reader);

                for (int i = 1; i < parsed.GetLength(0); i++)
                {
                    string[] row = parsed[i];

                    string    datablockName = row[nameIndex];
                    Datablock datablock     = GetNamedDatablock(datablockDetectionInfo, datablockName);

                    for (int index = 0; index < parsed[i].Length; index++)
                    {
                        if (index == headers.Count)
                        {
                            break;
                        }

                        string fieldValue = parsed[i][index];
                        string fieldName  = headers[index];

                        ProcessRawField(datablockDetectionInfo, fieldName, datablock, fieldValue);
                    }
                }

                Debug.Log("Imported " + (parsed.GetLength(0) - 1) + " datablocks.");
            }
        }
 public void Load(string text)
 {
     rowList.Clear();
     string[][] grid = CsvParser2.Parse(text);
     for (int i = 1; i < grid.Length; i++)
     {
         Row row = new Row();
         row.type       = grid[i][0];
         row.difficulty = grid[i][1];
         row.english    = grid[i][2];
         row.german     = grid[i][3];
         row.french     = grid[i][4];
         row.dutch      = grid[i][5];
         rowList.Add(row);
     }
     foreach (Row row in rowList)
     {
         if (row.difficulty == "easy")
         {
             wordsEasy.Add(row);
         }
         if (row.difficulty == "medium")
         {
             wordsMedium.Add(row);
         }
         if (row.difficulty == "hard")
         {
             wordsHard.Add(row);
         }
     }
     isLoaded = true;
 }
示例#10
0
    public void Load()
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(file.text);
        for (int i = 1; i < grid.Length; i++)
        {
            int           j   = 0;
            MyPlayerEvent row = new MyPlayerEvent();
            try
            {
                j               = 0;
                row.eventtype   = EnumUtil.EnumFromString <PlayerEvent>(grid[i][j++], PlayerEvent.Null);
                row.attribute_1 = grid[i][j++];
                row.attribute_2 = grid[i][j++];
                row.metric_1    = (grid[i][j].Equals(""))? 0 : float.Parse(grid[i][j]);
                j++;
                row.metric_2 = (grid[i][j].Equals("")) ? 0 : float.Parse(grid[i][j]);
                j++;
                row.wave_time = (grid[i][j].Equals("")) ? 0 : float.Parse(grid[i][j]);
                j++;
                row.eventtime = DateTime.Parse(grid[i][j]);
            }
            catch (Exception e)
            {
                Debug.Log("Could not parse " + String.Join(" | ", grid[i]) + " j " + j + " " + e.Message + "\n");
            }
            rowList.Add(row);
        }

        rowList.Sort();

        isLoaded = true;
    }
示例#11
0
    private void ImportRows(DatablockDetectionInfo datablockDetectionInfo)
    {
        using (TextReader reader = File.OpenText(csvFilePath))
        {
            var parser = new CsvParser2();
            parser.TrimTrailingEmptyLines = true;
            string[][] parsed = parser.Parse(reader);

            for (int i = 1; i < parsed.GetLength(0); i++)
            {
                string[] row = parsed[i];

                string datablockName = row[nameIndex];
                Datablock datablock = GetNamedDatablock(datablockDetectionInfo, datablockName);

                for (int index = 0; index < parsed[i].Length; index++)
                {
                    if (index == headers.Count)
                        break;

                    string fieldValue = parsed[i][index];
                    string fieldName = headers[index];

                    ProcessRawField(datablockDetectionInfo, fieldName, datablock, fieldValue);
                }
            }

            Debug.Log("Imported " + (parsed.GetLength(0) - 1) + " datablocks.");
        }
    }
示例#12
0
    /// <summary>
    /// Loads all the information
    /// </summary>
    /// <param name="csv"></param>
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.Player             = grid[i][0];
            row.TotalPitchesThrown = grid[i][1];
            row.TotalFastballs     = grid[i][2];
            row.TotalCurveballs    = grid[i][3];
            row.TotalChangeups     = grid[i][4];
            row.TotalSliders       = grid[i][5];
            row.TotalSinkers       = grid[i][6];
            row.FB_R = grid[i][7];
            row.FB_L = grid[i][8];
            row.CV_R = grid[i][9];
            row.CV_L = grid[i][10];
            row.CH_R = grid[i][11];
            row.CH_L = grid[i][12];
            row.SL_R = grid[i][13];
            row.SL_L = grid[i][14];
            row.SI_R = grid[i][15];
            row.SI_L = grid[i][16];

            rowList.Add(row);
        }
        isLoaded = true;
    }
    IEnumerator LoadData(string url)
    {
        loadDataResult = new List <List <string> >();

        using (UnityWebRequest req = UnityWebRequest.Get(url))
        {
            req.timeout = 5;
            yield return(req.SendWebRequest());

            if (req.isNetworkError || req.isHttpError)
            {
                Debug.Log(req.error);
                errorOnWebRequest = true;
            }

            else
            {
                foreach (var line in CsvParser2.Parse(req.downloadHandler.text))
                {
                    loadDataResult.Add(line.ToList());
                }
            }
        }
        yield return(null);
    }
示例#14
0
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.Phrase = grid[i][0];

            rowList.Add(row);
        }
        isLoaded = true;
    }
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.id           = grid[i][0];
            row.hip          = grid[i][1];
            row.hd           = grid[i][2];
            row.hr           = grid[i][3];
            row.gl           = grid[i][4];
            row.bf           = grid[i][5];
            row.proper       = grid[i][6];
            row.ra           = grid[i][7];
            row.dec          = grid[i][8];
            row.dist         = grid[i][9];
            row.pmra         = grid[i][10];
            row.pmdec        = grid[i][11];
            row.rv           = grid[i][12];
            row.mag          = grid[i][13];
            row.absmag       = grid[i][14];
            row.spect        = grid[i][15];
            row.ci           = grid[i][16];
            row.x            = grid[i][17];
            row.y            = grid[i][18];
            row.z            = grid[i][19];
            row.vx           = grid[i][20];
            row.vy           = grid[i][21];
            row.vz           = grid[i][22];
            row.rarad        = grid[i][23];
            row.decrad       = grid[i][24];
            row.pmrarad      = grid[i][25];
            row.pmdecrad     = grid[i][26];
            row.bayer        = grid[i][27];
            row.flam         = grid[i][28];
            row.con          = grid[i][29];
            row.comp         = grid[i][30];
            row.comp_primary = grid[i][31];
            row._base        = grid[i][32];
            row.lum          = grid[i][33];
            row.var          = grid[i][34];
            row.var_min      = grid[i][35];
            row.var_max      = grid[i][36];

            rowList.Add(row);
        }
        isLoaded = true;
    }
示例#16
0
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.Level        = grid[i][0];
            row.MaxExp       = grid[i][1];
            row.MissileCount = grid[i][2];

            rowList.Add(row);
        }
        isLoaded = true;
    }
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Drug row = new Drug();
            row.ID       = int.Parse(grid[i][0]);
            row.DrugName = grid[i][1];

            if (grid[i][2] != "")
            {
                row.Concentration = float.Parse(grid[i][2]);
            }
            else
            {
                row.Concentration = null;
            }

            row.ConcentrationUnit = grid[i][3];
            row.AdditionalText    = grid[i][4];
            row.Unit      = grid[i][5];
            row.IsSyringe = (grid[i][6] == "1");

            row.FullLabelText = row.DrugName + " " + row.Concentration + " " + row.ConcentrationUnit + " " + row.AdditionalText + " " + row.Unit;

            if (grid[i][7] != "")
            {
                row.PrimaryColor = new Color32(byte.Parse(grid[i][7]), byte.Parse(grid[i][8]), byte.Parse(grid[i][9]), 255);
            }
            else
            {
                row.PrimaryColor = new Color32(255, 255, 255, 255);
            }

            if (grid[i][10] != "")
            {
                row.SecondaryColor = new Color32(byte.Parse(grid[i][10]), byte.Parse(grid[i][11]), byte.Parse(grid[i][12]), 255);
            }
            else
            {
                row.SecondaryColor = row.PrimaryColor;
            }

            rowList.Add(row);
        }
        Loaded = true;
    }
示例#18
0
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.FindItem = new List <string>(grid[i][2].Split(","[0]));
            row.ID       = grid[i][0];
            row.MapName  = grid[i][1];
            row.Reward   = grid[i][3];

            rowList.Add(row);
        }
        isLoaded = true;
    }
示例#19
0
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.IDMini  = grid[i][0];
            row.Mapname = grid[i][1];
            row.IDItem  = grid[i][2];
            row.Detail  = grid[i][3];

            rowList.Add(row);
        }
        isLoaded = true;
    }
示例#20
0
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.ID        = grid[i][0];
            row.Name      = grid[i][1];
            row.MeshPath  = grid[i][2];
            row.ImagePath = grid[i][3];

            rowList.Add(row);
        }
        isLoaded = true;
    }
 public void Load(string text)
 {
     rowList.Clear();
     string[][] grid = CsvParser2.Parse(text);
     for (int i = 0; i < grid.Length; i++)
     {
         Row row = new Row();
         row.key     = grid[i][0];
         row.english = grid[i][1];
         row.german  = grid[i][2];
         row.french  = grid[i][3];
         row.dutch   = grid[i][4];
         rowList.Add(row);
     }
     isLoaded = true;
 }
示例#22
0
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.WardNumber       = grid[i][0];
            row.HouseholdNum     = grid[i][1];
            row.UniverstiyDegree = grid[i][2];
            row.Employed         = grid[i][3];

            rowList.Add(row);
        }
        isLoaded = true;
    }
示例#23
0
 public void Load(string text)
 {
     rowList.Clear();
     string[][] grid = CsvParser2.Parse(text);
     for (int i = 0; i < grid.Length; i++)
     {
         Row row = new Row();
         row.startingbudget = grid[i][0];
         row.minplayers     = grid[i][1];
         row.gameendtime    = grid[i][2];
         row.utopiarate     = grid[i][3];
         row.mayorlevel     = grid[i][4];
         row.minigametime   = grid[i][5];
         rowList.Add(row);
     }
     isLoaded = true;
 }
示例#24
0
 public void Load(string text)
 {
     rowList.Clear();
     string[][] grid = CsvParser2.Parse(text);
     for (int i = 0; i < grid.Length; i++)
     {
         Row row = new Row();
         row.rank              = grid[i][0];
         row.unlock            = grid[i][1];
         row.influencegoal     = grid[i][2];
         row.environmentplayer = grid[i][3];
         row.socialplayer      = grid[i][4];
         row.financeplayer     = grid[i][5];
         rowList.Add(row);
     }
     isLoaded = true;
 }
示例#25
0
    public List <Row> Load(TextAsset csv)
    {
        List <Row> rowList = new List <Row>();

        string[][] grid = CsvParser2.Parse(csv.text);

        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.time         = int.Parse(grid[i][0]);
            row.danmakuType  = int.Parse(grid[i][1]);
            row.danmakuCount = int.Parse(grid[i][2]);

            rowList.Add(row);
        }
        return(rowList);
    }
示例#26
0
        private void LoadGlobals()
        {
            var data = FileManager.ReadCsv(Application.streamingAssetsPath + @"/Constants.csv");
            var grid = CsvParser2.Parse(data);

            CapacityMultiplier        = Parsers.Float(grid[1][0]);
            LevelUnlockScoreThreshold = Mathf.Clamp(Parsers.Float(grid[1][1]), 0.5f, 1f);
            Pitaco.AirViscosity       = Parsers.Float(grid[1][2]);
            Pitaco.Lenght             = Parsers.Float(grid[1][3]);
            Pitaco.Radius             = Parsers.Float(grid[1][4]);
            Mano.AirViscosity         = Parsers.Float(grid[1][5]);
            Mano.Lenght        = Parsers.Float(grid[1][6]);
            Mano.Radius        = Parsers.Float(grid[1][7]);
            Cinta.AirViscosity = Parsers.Float(grid[1][8]);
            Cinta.Lenght       = Parsers.Float(grid[1][9]);
            Cinta.Radius       = Parsers.Float(grid[1][10]);
        }
示例#27
0
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.name       = grid[i][0];
            row.greeting   = grid[i][1];
            row.timeFactor = grid[i][2];
            row.combo      = grid[i][3];
            row.points     = grid[i][4];

            rowList.Add(row);
        }
        isLoaded = true;
    }
示例#28
0
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.Date  = grid[i][0];
            row.Time  = grid[i][1];
            row.User  = grid[i][2];
            row.Pages = grid[i][3];
            row.Title = grid[i][4];

            rowList.Add(row);
        }
        isLoaded = true;
    }
示例#29
0
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.Avenue   = grid[i][0];
            row.num      = grid[i][1];
            row.Building = grid[i][2];
            row.Floors   = grid[i][3];
            row.Tenant   = grid[i][4];

            rowList.Add(row);
        }
        isLoaded = true;
    }
示例#30
0
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.Year        = grid[i][0];
            row.Make        = grid[i][1];
            row.Model       = grid[i][2];
            row.Description = grid[i][3];
            row.Price       = grid[i][4];

            rowList.Add(row);
        }
        isLoaded = true;
    }
示例#31
0
    public void Load(TextAsset csv)
    {
        rowList.Clear();
        string[][] grid = CsvParser2.Parse(csv.text);
        for (int i = 1; i < grid.Length; i++)
        {
            Row row = new Row();
            row.lieu        = grid[i][0];
            row.lng         = grid[i][2];
            row.lat         = grid[i][1];
            row.description = grid[i][3];
            row.fichier     = grid[i][4];

            rowList.Add(row);
        }
        isLoaded = true;
    }