datagridview打开excel报错:名为“ClampVal”的列已属于此 DataTable

Question

   foreach (String colname in split)
                    {
                        //名为“ClampVal”的列已属于此 DataTable。
                        table.Columns.Add(colname, System.Type.GetType("System.String"));
                     
                        i++;
                    }
报错:名为“ClampVal”的列已属于此 DataTable。难道列名相同就不能打开了吗? 有什么办法解决没?

Answer 1

Excel 里面的列名我又不能改.. 下面那代码要怎么改?       foreach (String colname in split)
                    {
                        //名为“ClampVal”的列已属于此 DataTable。
                        table.Columns.Add(colname, System.Type.GetType("System.String"));
                     
                        i++;
                    }                    int j = 0;
                    while (sr.Peek() > -1)
                    {
                        s = sr.ReadLine();                        j = 0;
                        row = table.NewRow();
                        split = s.Split(',');
                        foreach (String colname in split)
                        {
                            row[j] = colname;
                            j++;
                            if (j >= i) { break; }
                        }
                        table.Rows.Add(row);
                    }