Iterate through an Excel document

pom.xml:

    <dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi</artifactId>
	<version>3.9</version>
    </dependency>
    <dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi-ooxml</artifactId>
	<version>3.9</version>
    </dependency>

java

        Workbook wb=new XSSFWorkbook(new FileInputStream("test.xlsx"));
        Sheet ws=wb.getSheetAt(wb.getActiveSheetIndex());
        int rowIndex=1;
        while (ws.getRow(rowIndex)!=null && rowIndex<100){
            Row row=ws.getRow(rowIndex);
            System.out.println(row.getCell(0).getStringCellValue());
            rowIndex++;
        }

Java

29 Words

2013-07-29 08:51 +0000