• Post Reply Bookmark Topic Watch Topic
  • New Topic

Reading from Excel  RSS feed

 
Bindu Kumar
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!