Forum Discussion

shilpi_agarwal's avatar
shilpi_agarwal
Contributor
9 years ago

problem when reading blank from excel file

  Script is reading first two records correctly but when blank appears on excel file, script does not read and throw an error- Vb-Script Run Time error Type Mismatch: 'uName.Keys'   This is my e...
  • tristaanogre's avatar
    tristaanogre
    9 years ago

    I would suggest, also, wrapping your calls to the cell data with aqConvert.VarToStr(). That will ensure that a "blank" excel field will actually return a "blank" rather than a NULL value. 

Marsha_R's avatar
Marsha_R
Moderator

We have never had luck with blank spaces in Excel.  If there's not going to be real data in all the cells, then we use a period and check for 

 

If not equal to '.'

instead of if not blank

tristaanogre's avatar
tristaanogre
Esteemed Contributor
9 years ago

I would suggest, also, wrapping your calls to the cell data with aqConvert.VarToStr(). That will ensure that a "blank" excel field will actually return a "blank" rather than a NULL value.