import java.io.InputStream;
import java.io.IOException;
import java.util.Iterator;
import java.util.Properties;
import java.io.FileInputStream;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;



// linux
//private final static String PATH = "/home/username/GroIMP/../";
private final static String PATH = "/home/../../";
// windows
//private final static String PATH = "c:\\...\\GroIMP\\..";

// data file
private final static String DATA_FILE_NAME = "data.xls";


//** Variables **
// data set
protected static float[] DATA;

public static void initParameters() {
	loadDataFile(PATH + DATA_FILE_NAME);
}

// excel file reader **********************************************************/

private static float getNumeric(Cell cell) {
	if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
			return (float)cell.getNumericCellValue();
	}
	return -1;
}

private static void loadDataFile(String inFile) {
	InputStream inp = new FileInputStream(inFile);
	Workbook wb = WorkbookFactory.create(inp);
	Sheet sheet = wb.getSheetAt(0);
		
	// data to arrays
	DATA = new float[sheet.getLastRowNum()+1];
	int i = 0;
	for (Iterator rit = sheet.rowIterator(); rit.hasNext();) {
		Row row = (Row)rit.next();
		Iterator cit = row.cellIterator(); cit.hasNext();
		
		DATA[i] = getNumeric((Cell)cit.next());
		i++;
	}
}