fork download

import java.io.BufferedInputStream;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Iterator;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFRow;
 
public class ReadExcel {
 
    public static void main( String [] args ) {
        try {
 
            InputStream input = new BufferedInputStream(new FileInputStream("C:/Users/zcheung/Desktop/DATA/sample.xls"));
            POIFSFileSystem fs = new POIFSFileSystem( input );
            HSSFWorkbook wb = new HSSFWorkbook(fs);
            HSSFSheet sheet = wb.getSheetAt(0);
 
 
            Iterator rows = sheet.rowIterator();
            while( rows.hasNext() ) {  
                HSSFRow row = (HSSFRow) rows.next();
                System.out.println("\n");
                Iterator cells = row.cellIterator();
                while( cells.hasNext() ) {
 
                    HSSFCell cell = (HSSFCell) cells.next();
                    if(HSSFCell.CELL_TYPE_NUMERIC==cell.getCellType())
                    System.out.print( cell.getNumericCellValue()+"     " );
                    else
                    if(HSSFCell.CELL_TYPE_STRING==cell.getCellType())
                        System.out.print( cell.getStringCellValue()+"     " );
                    else
                        if(HSSFCell.CELL_TYPE_BOOLEAN==cell.getCellType())
                        System.out.print( cell.getBooleanCellValue()+"     " );
                        else
                            if(HSSFCell.CELL_TYPE_BLANK==cell.getCellType())
                                System.out.print( "BLANK     " );
                                else
                            System.out.print("Unknown cell type");
 
                }
 
 
            }
 
 
        } catch ( IOException ex ) {
            ex.printStackTrace();
        }
    }
 
}

Main.java:12: error: class ReadExcel is public, should be declared in a file named ReadExcel.java
public class ReadExcel {
       ^
Main.java:6: error: package org.apache.poi.poifs.filesystem does not exist
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
                                      ^
Main.java:7: error: package org.apache.poi.hssf.usermodel does not exist
import org.apache.poi.hssf.usermodel.HSSFCell;
                                    ^
Main.java:8: error: package org.apache.poi.hssf.usermodel does not exist
import org.apache.poi.hssf.usermodel.HSSFSheet;
                                    ^
Main.java:9: error: package org.apache.poi.hssf.usermodel does not exist
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
                                    ^
Main.java:10: error: package org.apache.poi.hssf.usermodel does not exist
import org.apache.poi.hssf.usermodel.HSSFRow;
                                    ^
Main.java:18: error: cannot find symbol
            POIFSFileSystem fs = new POIFSFileSystem( input );
            ^
  symbol:   class POIFSFileSystem
  location: class ReadExcel
Main.java:18: error: cannot find symbol
            POIFSFileSystem fs = new POIFSFileSystem( input );
                                     ^
  symbol:   class POIFSFileSystem
  location: class ReadExcel
Main.java:19: error: cannot find symbol
            HSSFWorkbook wb = new HSSFWorkbook(fs);
            ^
  symbol:   class HSSFWorkbook
  location: class ReadExcel
Main.java:19: error: cannot find symbol
            HSSFWorkbook wb = new HSSFWorkbook(fs);
                                  ^
  symbol:   class HSSFWorkbook
  location: class ReadExcel
Main.java:20: error: cannot find symbol
            HSSFSheet sheet = wb.getSheetAt(0);
            ^
  symbol:   class HSSFSheet
  location: class ReadExcel
Main.java:25: error: cannot find symbol
                HSSFRow row = (HSSFRow) rows.next();
                ^
  symbol:   class HSSFRow
  location: class ReadExcel
Main.java:25: error: cannot find symbol
                HSSFRow row = (HSSFRow) rows.next();
                               ^
  symbol:   class HSSFRow
  location: class ReadExcel
Main.java:30: error: cannot find symbol
                    HSSFCell cell = (HSSFCell) cells.next();
                    ^
  symbol:   class HSSFCell
  location: class ReadExcel
Main.java:30: error: cannot find symbol
                    HSSFCell cell = (HSSFCell) cells.next();
                                     ^
  symbol:   class HSSFCell
  location: class ReadExcel
Main.java:31: error: cannot find symbol
                    if(HSSFCell.CELL_TYPE_NUMERIC==cell.getCellType())
                       ^
  symbol:   variable HSSFCell
  location: class ReadExcel
Main.java:34: error: cannot find symbol
                    if(HSSFCell.CELL_TYPE_STRING==cell.getCellType())
                       ^
  symbol:   variable HSSFCell
  location: class ReadExcel
Main.java:37: error: cannot find symbol
                        if(HSSFCell.CELL_TYPE_BOOLEAN==cell.getCellType())
                           ^
  symbol:   variable HSSFCell
  location: class ReadExcel
Main.java:40: error: cannot find symbol
                            if(HSSFCell.CELL_TYPE_BLANK==cell.getCellType())
                               ^
  symbol:   variable HSSFCell
  location: class ReadExcel
19 errors

Standard output is empty