title: how to read a single cell from excel sheet into java program,
body: <p>I need to read a single cell, (example A1) into my java program. I am able to read out whole content into my program but how can i read only a specific cell?</p>
  
  <pre><code>import java.io.*;
  import java.util.Iterator;
  import org.apache.poi.hssf.usermodel.HSSFSheet;
  import org.apache.poi.hssf.usermodel.HSSFWorkbook;
  import org.apache.poi.ss.usermodel.Cell;
  import org.apache.poi.ss.usermodel.Row;
  import org.apache.poi.xssf.usermodel.XSSFSheet;
  import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  
  class JavaApplication2
  {
  static void readXlsx(File inputFile) 
  {
  try 
  {
      // Get the workbook instance for XLSX file
      XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(inputFile));
  
      // Get first sheet from the workbook
      XSSFSheet sheet = wb.getSheetAt(0);
  
      Row row;
      Cell cell;
  
      // Iterate through each rows from first sheet
      Iterator&lt;Row&gt; rowIterator = sheet.iterator();
  
      while (rowIterator.hasNext()) 
      {
              row = rowIterator.next();
  
              // For each row, iterate through each columns
              Iterator&lt;Cell&gt; cellIterator = row.cellIterator();
  
              while (cellIterator.hasNext()) 
              {
              cell = cellIterator.next();
  
              switch (cell.getCellType()) 
              {
  
              case Cell.CELL_TYPE_BOOLEAN:
                      System.out.println(cell.getBooleanCellValue());
                      break;
  
              case Cell.CELL_TYPE_NUMERIC:
                      System.out.println(cell.getNumericCellValue());
                      break;
  
              case Cell.CELL_TYPE_STRING:
                      System.out.println(cell.getStringCellValue());
                      break;
  
              case Cell.CELL_TYPE_BLANK:
                      System.out.println(" ");
                      break;
  
              default:
                      System.out.println(cell);
  
              }
              }
      }
  }
  catch (Exception e) 
  {
      System.err.println("Exception :" + e.getMessage());
  }
  }
  
  static void readXls(File inputFile) 
  {
  try 
  {
      // Get the workbook instance for XLS file
      HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(inputFile));
      // Get first sheet from the workbook
      HSSFSheet sheet = workbook.getSheetAt(0);
      Cell cell;
      Row row;
  
      // Iterate through each rows from first sheet
      Iterator&lt;Row&gt; rowIterator = sheet.iterator();
  
      while (rowIterator.hasNext()) 
      {
              row = rowIterator.next();
  
              // For each row, iterate through each columns
              Iterator&lt;Cell&gt; cellIterator = row.cellIterator();
  
              while (cellIterator.hasNext()) 
              {
              cell = cellIterator.next();
  
              switch (cell.getCellType()) 
              {
  
              case Cell.CELL_TYPE_BOOLEAN:
                      System.out.println(cell.getBooleanCellValue());
                      break;
  
              case Cell.CELL_TYPE_NUMERIC:
                      System.out.println(cell.getNumericCellValue());
                      break;
  
              case Cell.CELL_TYPE_STRING:
                      System.out.println(cell.getStringCellValue());
                      break;
  
              case Cell.CELL_TYPE_BLANK:
                      System.out.println(" ");
                      break;
  
              default:
                      System.out.println(cell);
              }
              }
      }
  
  } 
  
  catch (FileNotFoundException e) 
  {
      System.err.println("Exception" + e.getMessage());
  }
  catch (IOException e) 
  {
      System.err.println("Exception" + e.getMessage());
  }
  }
  
  public static void main(String[] args) 
  {
      File inputFile = new File("C://users/admin/Desktop/Content.xls");
  
      readXls(inputFile);
  
  }
  }
  </code></pre>
  
  <p>this is what I have done, I am reading the whole content but I need a specific cell</p>