php excel validation from a cell downwards

Topics: Developer Forum, User Forum
Apr 4, 2013 at 9:19 PM
i am using php excel to generate an excel sheet , now for the columns i want to be able to restrict the user input based

on the data i have on my database e.g

cities

new york
paris

franc e.t.c

now in my excel sheet i want to be able to load all the cities in a select box and render it on a column , the select box

will have all the cities from the database column and be rendered on the excel sheet from a particular cell downwards e.g

from c4 downwards to c5 , c6 till the user has no more records to add on the next row, please how do i go about it ?