Getting index out of range exception if cell is empty in Excel

Question

I am reading a Excel file with 60 columns. Problem is if the cell is empty it just throws index out of range exception and if cell contains some data then it reads the value. Any idea how can I read the empty cell. I am using the following code to do so. It works fine for empty cells for other types of data but these cells contain date values.

List<string> depDates = new List<string>();
        for (int j = 54; j < 58; j++)
        {
            if (tableData.DataRows[0][j] == string.Empty)
            {
                depDates.Add("null");
            }
            else
            {
                depDates.Add(tableData.DataRows[0][j]);
            }
        }

The format of these columns in Excel is Text. Please guide.

score 1 · Accepted Answer · 2014-04-17 15:15:35Z

1

You can try this :

  if (tableData.DataRows[0][j] == null ||tableData.DataRows[0][j].Trim() == string.Empty)
        {
            depDates.Add("null");
        }

edited Apr 17, 2014 at 15:15

answered Apr 17, 2014 at 9:49

user3383479

Sign up to request clarification or add additional context in comments.

3 Comments

Andrew Over a year ago

what about white spaces? Any case string.IsNullOrEmpty() and string.IsNullOrWhitespace() are designed for this purpose.

user3383479 Over a year ago

I think if there is white space it will be different of null.

Andrew Over a year ago

exactly, it will not be null and it will not be string.Empty. you'll end up adding something like " " to collection of depDates. and that is why I've used string.IsNullOrWhitespace to answer this question

Andrew · Accepted Answer · 2014-04-17 09:46:20Z

1

Possibly there are whitespaces in cells, check cells like following:

if (string.IsNullOrWhitespace(tableData.DataRows[0][j])) ...

answered Apr 17, 2014 at 9:46

Andrew

3,8261 gold badge18 silver badges29 bronze badges

Collectives™ on Stack Overflow

Getting index out of range exception if cell is empty in Excel

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related