title: Read excel content after get data from particular cell
body: <p>I have existing codes that work to get a particular cell from an excel sheet.
  is that possible to read particular content within the cell?</p>
  
  <p><strong>excel reader:</strong></p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>public String ReadCellData(int vRow, int vColumn)
   {
    String value=null;          //variable for storing the cell value
    Workbook wb=null;           //initialize Workbook null
    try
    {
     //reading data from a file in the form of bytes
        FileInputStream fis=new FileInputStream(RunConfiguration.getProjectDir() + "/Data Files/testmatrix.xlsx");
     //constructs an XSSFWorkbook object, by buffering the whole stream into the memory
     wb=new XSSFWorkbook(fis);
    }
    catch(FileNotFoundException e)
    {
     e.printStackTrace();
    }
    catch(IOException e1)
    {
     e1.printStackTrace();
    }
    Sheet sheet=wb.getSheetAt(0);   //getting the XSSFSheet object at given index
    Row row=sheet.getRow(vRow); //returns the logical row
    Cell cell=row.getCell(vColumn); //getting the cell representing the given column
    //value=cell.getStringCellValue();    //getting cell value
    //return value;               //returns the cell value
   }
  }</code></pre>
  </div>
  </div>
  </p>
  
  <p><strong>codes to get and print data</strong></p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>//read excel cell C11, ignore first row column A1. (int vRow, int vColumn)
  def exceldata = CustomKeywords.'test.readexcel.ReadCellData'(11, 2)
  
  String jsondata = JsonOutput.prettyPrint(exceldata.toString())
  
  println(jsondata)
  
  WebUI.delay(1)
  
  //call the object and post the above data as API HTTP request body
  def post = ((findTestObject('Object Repository/Web Service Request/test-service/Post')) as RequestObject)
  
  post.setBodyContent(new HttpTextBodyContent(jsondata))
  
  WebUI.delay(2)
  
  //POST and verification
  def response = WS.sendRequestAndVerify(post)
  
  println(response.statusCode)
  
  assert response.getStatusCode() == 201</code></pre>
  </div>
  </div>
  </p>
  
  <p><strong>excel data at Cell C11</strong></p>
  
  <p>I want to get the value of key testId.</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>{
    "testId": "test123",
    "created": "2020-02-06T17:02:39.257Z",
  }</code></pre>
  </div>
  </div>
  </p>