Check empty cell

[Beatriz]

I have a file in excel that already contains data, how do I know which is a last cell that is filled to paste the data into the next available cell?

[PrankurJoshi]

Hi @Beatriz

See this, it will help you

Get value from the last non empty cell in an excel row

@Sripadraj It would be easier to get it from Sheet1, before it’s split: foreach (row in dt) { string lastCell = row(0).ToString().Split(","c).Last() } @ranjith Probably you could, but I don’t think it’s worth the trouble. It’s clearer to just use a normal loop. That said: row(col) is nothing or row(col).Equals("") There’s a better way to test for null or empty: String.IsNullOrEmpty(row(col)) Another thing is that or operator tests both sides, which means that if your second check invo…

Thanks,
Prankur