I am trying to read from an excel having 2 rows & 3 columns. The 3rd column is validated to take values from the list ['hre','admin','dm']. We I say emp_sheet = workbook.getSheet(0); it gives the following message in the console :
Warning: Cell at C3 not present - adding a blank Warning: Some cells exceeded the specified bounds. Resizing sheet dimensions from 3x2 to 3x3
and when I say emp_sheet.getRows() it gives me 3 instead of 2 rows. So I end up reading an empty row !!
It works fine when I remove the validation for the 3rd column. Any clue why this happens ?