Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // import statements
- public class POIforgfgRead {
- public static void main(String[] args)
- {
- try {
- FileInputStream file = new FileInputStream(new File("gfgcontribute.xlsx"));
- // Create Workbook instance holding reference to .xlsx file
- XSSFWorkbook workbook = new XSSFWorkbook(file);
- // Get first/desired sheet from the workbook
- XSSFSheet sheet = workbook.getSheetAt(0);
- // Iterate through each rows one by one
- Iterator<Row> rowIterator = sheet.iterator();
- while (rowIterator.hasNext()) {
- Row row = rowIterator.next();
- // For each row, iterate through all the columns
- Iterator<Cell> cellIterator = row.cellIterator();
- while (cellIterator.hasNext()) {
- Cell cell = cellIterator.next();
- // Check the cell type and format accordingly
- switch (cell.getCellType()) {
- case Cell.CELL_TYPE_NUMERIC:
- System.out.print(cell.getNumericCellValue() + "t");
- break;
- case Cell.CELL_TYPE_STRING:
- System.out.print(cell.getStringCellValue() + "t");
- break;
- }
- }
- System.out.println("");
- }
- file.close();
- }
- catch (Exception e) {
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement