count the number of cells which are blank in a excel column

[shantanu]

Dear All
My requirement is to count the number of cells which are
blank in a excel column, for that i am writing the following
code;;;;;;;;;;;;;;;;;

private void ValidateReviewComment()
{
//Range xlsRng = _sheet.get_Range("G1",Type.Missing).EntireColumn;
//MessageBox.Show(xlsRng.EntireColumn.Count.ToString ());
Range xlsRng = _sheet.UsedRange;
MessageBox.Show("xlsRng.Rows.Count "+xlsRng.Rows.Count.ToString());
for (int i = 2; i <= xlsRng.Rows.Count; i++)
{

if(xlsRng.Cells.Value2==null)
{
MessageBox.Show(i.ToString());
}
}
}

kindly assist me
thanks
shantanu

[Nicholas Paldino [.NET/C# MVP]]

Shantanu,

The Value property of the Range instance (for each individual cell)
should be null, or a Missing value. Either way, when you iterate through
the used cells in the column, it should stick out instantly when you look at
the value in the debugger.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"shantanu" <sh***********@gmail.comwrote in message
news:11**********************@n76g2000hsh.googlegr oups.com...

Dear All
My requirement is to count the number of cells which are
blank in a excel column, for that i am writing the following
code;;;;;;;;;;;;;;;;;

private void ValidateReviewComment()
{
//Range xlsRng = _sheet.get_Range("G1",Type.Missing).EntireColumn;
//MessageBox.Show(xlsRng.EntireColumn.Count.ToString ());
Range xlsRng = _sheet.UsedRange;
MessageBox.Show("xlsRng.Rows.Count "+xlsRng.Rows.Count.ToString());
for (int i = 2; i <= xlsRng.Rows.Count; i++)
{

if(xlsRng.Cells.Value2==null)
{
MessageBox.Show(i.ToString());
}
}
}

kindly assist me
thanks
shantanu

[shantanu]

On Apr 3, 8:13 pm, "Nicholas Paldino [.NET/C# MVP]"
<[e-mail]:

Shantanu,

The Value property of the Range instance (for each individual cell)
should be null, or a Missing value. Either way, when you iterate through
the used cells in the column, it should stick out instantly when you look at
the value in the debugger.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- [e-mail]

"shantanu" <[e-mail] in message

news:11**********************@n76g2000hsh.googlegr oups.com...

Dear All
My requirement is to count the number of cells which are
blank in a excel column, for that i am writing the following
code;;;;;;;;;;;;;;;;;

private void ValidateReviewComment()
{
//Range xlsRng = _sheet.get_Range("G1",Type.Missing).EntireColumn;
//MessageBox.Show(xlsRng.EntireColumn.Count.ToString ());
Range xlsRng = _sheet.UsedRange;
MessageBox.Show("xlsRng.Rows.Count "+xlsRng.Rows.Count.ToString());
for (int i = 2; i <= xlsRng.Rows.Count; i++)
{

if(xlsRng.Cells.Value2==null)
{
MessageBox.Show(i.ToString());
}
}
}

kindly assist me
thanks
shantanu- Hide quoted text -

- Show quoted text -

Thanx a lot i had the solution