jdbc.FI.java Source code

Introduction

Here is the source code for jdbc.FI.java

Source

package jdbc;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.Iterator;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 *
 * @author tri
 */
public class FI {
    public static void main(String[] args)
            throws ClassNotFoundException, InstantiationException, IllegalAccessException, Exception {
        FI obj = new FI();
        System.out.println(obj.read_FI("AAA", 7, 2012));
    }

    String read_FI(String company, Integer rownumber, Integer data_year) { // colnumber > 1
        Integer rowindex = 2;
        Integer n = 0;
        Integer y = 0;
        Integer colindex = -1;//number of years in the file
        Integer max_year = 2014;
        String result = "N/A";
        DataFormatter fmt = new DataFormatter();
        try {
            FileInputStream file = new FileInputStream(
                    new File("C:\\Users\\tri\\Desktop\\busi\\data\\All\\" + company + "_FI.xlsx"));

            XSSFWorkbook workbook = new XSSFWorkbook(file);
            XSSFSheet sheet = workbook.getSheetAt(0);
            Iterator<Row> rowIterator = sheet.iterator();
            while (rowIterator.hasNext()) {

                Row row = rowIterator.next();
                if (rowindex > 3 && rowindex < 25) {
                    if (rowindex == 4) {
                        Iterator<Cell> cellIterator = row.cellIterator();
                        while (cellIterator.hasNext()) {
                            Cell cell = cellIterator.next();
                            colindex++;
                        }
                    }

                    if (rowindex == rownumber) {
                        Iterator<Cell> cellIterator = row.cellIterator();
                        if (data_year == 999) {
                            Cell cell = cellIterator.next();
                            result = fmt.formatCellValue(cell);

                            return result;
                        }
                        while (cellIterator.hasNext()) {
                            Cell cell = cellIterator.next();
                            y = colindex + data_year - max_year; //get the number of cells we need to jump 
                            if (y > 0) {
                                if (y == n) {//go through the cells till reach right one

                                    return result = fmt.formatCellValue(cell);
                                }
                                n++;
                            }

                        }

                    }
                }
                rowindex++;
            }
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if ("".equals(result) || "-".equals(result) || "N/A".equals(result)) {
                return "0.0";
            } else {
                return result;
            }
        }
    }

    String iport_FI(String company, Integer rownumber, Integer data_year) { // linenumber > 5
        Integer rowindex = 2;
        Integer n = 0;
        Integer y = 0;
        Integer colindex = -1;//number of years in the file
        Integer max_year = 2014;
        String result = "N/A";
        DataFormatter fmt = new DataFormatter();
        try {
            FileInputStream file = new FileInputStream(
                    new File("C:\\Users\\tri\\Desktop\\busi\\data\\All\\" + company + "_FI.xlsx"));

            XSSFWorkbook workbook = new XSSFWorkbook(file);
            XSSFSheet sheet = workbook.getSheetAt(0);
            Iterator<Row> rowIterator = sheet.iterator();
            while (rowIterator.hasNext()) {

                Row row = rowIterator.next();
                if (rowindex > 3 && rowindex < 30) {
                    if (rowindex == 4) {
                        Iterator<Cell> cellIterator = row.cellIterator();
                        while (cellIterator.hasNext()) {
                            Cell cell = cellIterator.next();
                            colindex++;
                        }
                    }

                    if (rowindex == rownumber) {
                        Iterator<Cell> cellIterator = row.cellIterator();
                        if (data_year == 999) {
                            Cell cell = cellIterator.next();
                            result = fmt.formatCellValue(cell);

                            return result;
                        }
                        while (cellIterator.hasNext()) {
                            Cell cell = cellIterator.next();
                            y = colindex + data_year - max_year; //get the number of cells we need to jump 
                            if (y > 0) {
                                if (y == n) {//go through the cells till reach right one

                                    return result = fmt.formatCellValue(cell);
                                }
                                n++;
                            }

                        }

                    }
                }
                rowindex++;
            }

        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            return result;
        }
    }
}