Get Cell Value from a DataTable in C#

.net, c#, datatable

Solution

The `DataRow` has also an indexer:

Object cellValue = dt.Rows[i][j];

But i would prefer the strongly typed `Field` extension method which also supports nullable types:

int number = dt.Rows[i].Field<int>(j);

or even more readable and less error-prone with the name of the column:

double otherNumber = dt.Rows[i].Field<double>("DoubleColumn");

Problem

Here is a DataTable dt, which has lots of data. I want to get the specific Cell Value from the DataTable, say Cell[i,j]. Where, i -> Rows and j -> Columns. I will iterate i,j's value with two `forloops`. But I can't figure out how I can call a cell by its index. Here's the code: ``` for (i = 0; i <= dt.Rows.Count - 1; i++) { for (j = 0; j <= dt.Columns.Count - 1; j++) { var cell = dt.Rows[i][j]; xlWorkSheet.Cells[i + 1, j + 1] = cell; } } ```

Original source