i need to create an excel sheet list validation on cell and drop down list should contain the custom values
I tried using DataValidation, but I need to specify range of value
Is there any way i can give custom values in the list as in the excel sheet
Data->validation->Allow:List ?
Is this feature available in any other
java API which create excel sheet?