示例#1
0
        // Erstellt csv-Datei für eine TreeMap in R

        private void CreateTreeMapTable()
        {
            TreemapTable = Tabelle.Copy();

            AddLevelColumns(TreemapTable);

            DataRowCollection MapRows = TreemapTable.Rows;

            foreach (DataRow row1 in MapRows)
            {
                string Row1Title = (string)row1["Titel"];
                string Row1Pfad  = (string)row1["Pfad"];
                int    Row1Ebene = GetEbenefromPath(Row1Pfad);

                foreach (DataRow row2 in MapRows)
                {
                    string Row2Title = (string)row2["Titel"];
                    string Row2Pfad  = (string)row2["Pfad"];
                    int    Row2Ebene = GetEbenefromPath(Row2Pfad);

                    if (Row2Pfad.Length >= Row1Pfad.Length)
                    {
                        if (Row2Pfad.Substring(0, Row1Pfad.Length) == Row1Pfad)
                        {
                            row2[Row1Ebene + 9] = Row1Title;
                        }
                    }
                }
            }
            for (int i = 0; i < TreemapTable.Rows.Count; i++)
            {
                for (int j = 0; j < TreemapTable.Columns.Count; j++)
                {
                    if (TreemapTable.Rows[i][j] != null && string.IsNullOrEmpty(TreemapTable.Rows[i][j].ToString()))
                    {
                        TreemapTable.Rows[i][j] = "";
                    }
                }
            }
        }