Web here i am creating one excel template using [apache poi] in that user can fill data.

How to create dependent drop down list in excel using java. In that two drop down list are there. Ctdatavalidations ctdatavalidations = ( (xssfsheet) sheet).getctworksheet ().getdatavalidations (); Web here are the steps to create a dependent drop down list in excel:

Web create a data validation rule for the dependent dropdown list with a custom formula based on the indirect function: Select the cell where you want the first (main) drop down list. Web list the items for the dependent list, and then select the cells.

= indirect (b5) in this formula, indirect simply evaluates. Web putting all the above pieces together, we get the following formula for the dependent drop down validation rule: =indirect (substitute (a2&b2, ,)) where a2 and b2 contain the first and second dropdowns,.

Web you can try getting the data of dropdowns from the below : Web for example, in cell c2, the data validation formula would be: This places the cells in a group so that you can name the group.

Web go to the data tab and click on data validation in the data tools group. Web here i have created 'hiddendepartment' as hidden sheet which will be used to show drop down, which will be applied on a1 cell to a10 cell. With the cells selected, go up to the.