Solution
A cell can contain a value and/or a formula. To check if a cell is empty use the Cell.Value and Cell.Formula properties to look for the following conditions:
| XLS Files | XLSX and XLSM Files | |||
|---|---|---|---|---|
| Language | Cell.Value | Cell.Formula | Cell.Value | Cell.Formula |
| C# | null | (empty string) | (empty string) OR null | (empty string) |
| VB.NET | Nothing | Nothing | (empty string) OR Nothing | Nothing |
| ASP/COM * | (empty string) | (empty string) | (empty string) | (empty string) |
Example
//--- myCell is a Cell object
if (string.IsNullOrEmpty(myCell.Value) && string.IsNullOrEmpty(myCell.Formula))
{
//--- Cell is empty
}
|