Overview
In this post, we will discuss conditional statements and loops in the Java programming language. Conditional structures The sheet used in the below example:
Sample code to read an excel column
The sample method to retrieve a column from an excel sheet is shown below. For simplicity, I’m only validating string values.
public ArrayList<String> getMyColumn(int colindex,int sheetIndex) throws IOException
{
File file = null;
FileInputStream fis = null ;
XSSFWorkbook workbook = null;
XSSFSheet sheet = null;
ArrayList<String> column = null;
try {
file = new File("TDocs.xlsx");
fis = new FileInputStream(file);
workbook = new XSSFWorkbook(fis);
sheet = workbook.getSheetAt(sheetIndex);
Iterator<Row> rowIterator = sheet.iterator();
column = new ArrayList<String>();
while (rowIterator.hasNext()) {
Row row = rowIterator.next();
Iterator<Cell> cellIterator = row.cellIterator();
while (cellIterator.hasNext()) {
Cell cell = cellIterator.next();
if(row.getRowNum() > 0){
if(cell.getColumnIndex() == colindex){
switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING:
column.add(cell.getStringCellValue());
break;
}
}
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
finally{
fis.close();
}
return column;
}
Sample main method to pass parameters to the method. I would retrieve the 2nd column in the excel sheet as shown below:
public static void main(String... args) throws IOException
{
ArrayList<String> consume = new ArrayList<String>();
ReadXL readexcel = new ReadXL();
consume = readexcel.getMyColumn(1, 0);
System.out.println("**********OutPut************");
for(String s : consume)
{
System.out.println(s);
}
}
Output
The run output of the program below:
**********OutPut************
Intern
Potter
Man
Note that we can also use sheet names instead of index. If we want to read from a sheet with name we can use below method.
workbook.getSheet(sheetName);