I want to check the type of cell using a range:
But I know there is no data in the cell to begin with, so it always returns CellValueType.IsNull
I need to check the type of formatting on the cell, so I then know how to put my data into the cell, such as using:
Do I have to know ahead of time that myValue should be a date?
Can I just check the formatting on the cell even though there is no data in it yet, so I send in the right data type?