Excel and C#

annicabaart

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("A2","A2"); 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)

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

mibuyt21y ago
Hi, No problem. Glad you get it working. Cheers.
annicabaart21y ago
Thanks a lot !!! I was looking for it such a long time but this works!!!!! Thans again ! Bye bye ;o)
mibuyt21y ago
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.