DataRow dr = dt.NewRow(); for (int iCol = 1; iCol <= iColCount; iCol++) { range = (Excel.Range)worksheet.Cells[iRow, iCol]; dr[iCol - 1] = (range.Value2 == null) ? “” : range.Text.ToString(); }

    System.Data.DataTabled = DataChangeExcel.ImportExcel(true); DataRowdr0 = d.Rows[0]; DataRowdr1 = d.Rows[1]; DataRowdr2 = d.Rows[2];