for (int Cnum = 1; Cnum <= ShtRange.Columns.Count; Cnum++) { if (Cnum == 1) { dt.Columns.Add((ShtRange.Cells[1, Cnum] as Excel.Range).Value2.ToString()); for (int Rnum = 1; Rnum <= 9; Rnum++) { dt.Rows.Add((ShtRange.Cells[Rnum, 1] as Excel.Range).Value2.ToString()); } } else if (Cnum == 2) { dt.Columns.Add((ShtRange.Cells[1, Cnum] as Excel.Range).Value2.ToString()); for (int Rnum = 1; Rnum <= 9; Rnum++) { dt.Rows.Add((ShtRange.Cells[Rnum, Cnum] as Excel.Range).Value2); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)