Reading Selection Lists from Existing Spreadsheet

Topics: Developer Forum, User Forum
May 26, 2011 at 4:58 PM


I am working with an existing spreadsheet that has data validation on certain fields i.e. they only accept values from a pre-defined list in another worksheet.

Can someone please advise on how I should go about reading the permitted values of a cell i.e. the options in the list?




May 26, 2011 at 5:39 PM

The simplest way -- if you know where the options list is -- is to just load the options worksheet and iterate through those cells.

May 27, 2011 at 8:56 AM

Hi Scott,

I see.  Is there a way to determine the location of the selection list if I have the cell object that uses the list (getCellByColumnAndRow($c, $r))?

The reason I ask is that I am working with an Excel file provided by a third party and for some reason all the selection lists are tucked away in a hidden worksheet.