title: Java | How to find a value (row and column number) in range of google spreadsheet using API?
body: <p>I am using the Java API (V4) to read and edit the data from a google sheet. So far, I am able to read and edit the data based on the row and column number (index). </p>
  
  <ul>
  <li><strong>What I am want to do is to localise a data by its specific value ( I want to get the row and the column number of a specific cell using its value).</strong> </li>
  </ul>
  
  <p>So far this is a part of the working code I used to edit the data: </p>
  
  <pre><code>  // Copy the format from A1:C1 and paste it into A2:C5, so the data in 
  // each column has the same background.             
  requests.add(new Request()
                          .setCopyPaste(new CopyPasteRequest()
                                  .setSource(new GridRange()
                                          .setSheetId(0)
                                          .setStartRowIndex(0)
                                          .setEndRowIndex(1)
                                          .setStartColumnIndex(0)
                                          .setEndColumnIndex(3))
                                  .setDestination(new GridRange()
                                          .setSheetId(0)
                                          .setStartRowIndex(1)
                                          .setEndRowIndex(6)
                                          .setStartColumnIndex(0)
                                          .setEndColumnIndex(3))
                                  .setPasteType("PASTE_FORMAT")));
  
                  BatchUpdateSpreadsheetRequest batchUpdateRequest = new BatchUpdateSpreadsheetRequest()
                          .setRequests(requests);
  </code></pre>
  
  <p>Can anyone please help me?
  Thank you in advance.</p>