Excel and C#

Question

Hello I am trying to make an .NET application in C# together with Excel. What i am looking for is a function that can detect the last row in the excel document or a function that can tell me that this cell has no value that is is just empty not filled in. I have tried to something like : Excel.Range gegevens = (Excel.Range)((Excel.Worksheet)excelApp.ActiveWorkbook.Sheets[1]).get_Range(A2A2); if(gegevens.value2 = ) { ...... } but .NET doesn't accept this because an empty cell is not the same as just an empty string Please help me ;o) Thanks in advance!! Bye bye ;o)

mibuyt · Answer

Hi No problem. Glad you get it working. Cheers.

annicabaart · Answer

Thanks a lot !!! I was looking for it such a long time but this works!!!!! Thans again ! Bye bye ;o)

mibuyt · Answer

Hi Can you try this instead? if(gegevens.value2 = null) // change to null instead of  { ...... } I will try to get back to you tomorrow. I do not have vs.net 2003 with me now. Cheers.