title: How to get DataValidation in Apache POI 3.9?
body: <p>I am using <a href="http://poi.apache.org/" rel="nofollow noreferrer">Apache POI</a> to write and read excel files,my poi version is <strong>3.9</strong>,but now I faced a problem and do not find a good solution to solve it.</p>
  
  <p>First I am use poi to write some datas to the excel table and will use <strong><a href="https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/DataValidation.html" rel="nofollow noreferrer">DataValidation</a></strong> to add some prompt information in the table header,as the picture shown below:</p>
  
  <p>The value in the cell is <strong>ABSInterention</strong>,and the prompt title is <strong>wrxuoh</strong>.After the excel generated successfully,other users will add some modification to the data cell and I need to read and parse the excel file and I want to get the prompt value <strong>wrxuoh</strong> again.So my question is:</p>
  
  <p><strong>When I read excel file using POI3.9,how can I get all the DataValidations for the current sheet?</strong></p>
  
  <p>I am using <strong>HSSFWorkbook</strong> and <strong>HSSFSheet</strong>.I found there is a method called <strong>getDataValidations</strong> in the <strong><a href="http://poi.apache.org/apidocs/index.html" rel="nofollow noreferrer">POI Sheet</a></strong>,but I can not find this method in my poi3.9 jar file and also can not find it in the POI3.9 javadoc.</p>
  
  <p>any help would be grateful!</p>
  
  <p><img src="https://i.stack.imgur.com/ixiL0.jpg" alt="enter image description here"></p>