Handling blank cells in Excel
I'm trying to enter values into a grid using DDT excel driver. The the rows have all the values there seem to be no problem but if one of the rows is missing a column value that throws and invalid identifier error.
I tried passing '' and also tried Null but always it throws errors.
Re: Handling blank cells in Excel
Check the type of values you obtain from Excel by using the aqObject.GetVarType method (see the "aqObject.GetVarType" help topic). If this method returns a value less than 2, the current cell is empty.