Read data from excel file

[Siva Masilamani]

Hi

I am assigned with a task to read data from the excel file.

I am using Apache POI api 3.6 to read the date.

Please find below the code:

public class ExcelReader {

    private static InputStream inputStream = null;
    private static boolean initialized;
    private List<String> columnName = null;
    private List<ExcelData> dataList = null;

    private static void init() {
        try {
            String xlsPath = System.getProperty("XLSX_FILE_PATH");
            inputStream = new FileInputStream(xlsPath);
            initialized = true;
        } catch (FileNotFoundException fnfe) {
            System.out.println("File not found in the specified path.");
            fnfe.printStackTrace();
        } catch (IOException ioe) {
            ioe.printStackTrace();
        }
    }

    public ExcelReader() {
        if (!initialized) {
            init();
        }
        loadFromExcel();
    }

    private void loadFromExcel() {
        try {
            XSSFWorkbook workBook = new XSSFWorkbook(inputStream);
            dataList = new ArrayList<ExcelData>();
            for (int i = 0; i < workBook.getNumberOfSheets(); i++) {
                XSSFSheet sheet = workBook.getSheetAt(i);
                Iterator<Row> rowIterator = sheet.rowIterator();
                Iterator<Cell> columnIterator = null;
                if (rowIterator.hasNext()) {
                    columnIterator = ((XSSFRow) rowIterator.next()).cellIterator();
                    getCoulmnName(columnIterator);
                }
                while (rowIterator.hasNext()) {
                    columnIterator = rowIterator.next().cellIterator();
                    ExcelData data = new ExcelData(); //Value Object with getter and setter field with all the fields are of String.
                    data.setPeriod(convertNumericToString(columnIterator.next().getNumericCellValue()));
                    data.setAsOfDate(convertDateToString(columnIterator.next().getDateCellValue()));
                    data.setSite(columnIterator.next().getStringCellValue());
                    data.setBranch(columnIterator.next().getStringCellValue());
                    data.setParentCode(convertNumericToString(columnIterator.next().getNumericCellValue()));
                    data.setCurrency(columnIterator.next().getStringCellValue());
                    data.setPoolParent(columnIterator.next().getStringCellValue());
                    dataList.add(data);
                }
            }
        } catch (IOException ioe) {
            ioe.printStackTrace();
        }
    }

    private void getCoulmnName(Iterator<Cell> columnIterator) {
        columnName = new ArrayList<String>();
        while (columnIterator.hasNext()) {
            columnName.add(((XSSFCell) columnIterator.next()).getStringCellValue());
        }
    }

    private String convertNumericToString(Double dataInNumeric) {
        return ((Integer) dataInNumeric.intValue()).toString();
    }

    private String convertDateToString(Date date) {
        DateFormat dateFormat = new SimpleDateFormat("mm/dd/yyyy");
        String dateString = dateFormat.format(date);
        return dateString;
    }

    public List<ExcelData> getDataList() {
        return dataList;
    }
} 

The code is working fine but i just wanted to know that if there is any room for code improvement,efficiency etc.

Please help me with your suggesstion.