Laboratoire ICAR » Plateforme TXM

import java.util.HashMap;

import java.util.List;

	public static ArrayList<HashMap<String, String>> toHashMap(File inputFile, String sheetname) throws Exception {

		SpreadsheetDocument spreadsheet = SpreadsheetDocument.loadDocument(inputFile);

		// the first access to the document causes a very long process

		int sheetCount = spreadsheet.getSheetCount();

		if (sheetCount < 1) {

			System.out.println("** ReadODS: no sheet found in file. Aborting.");

			return null;

		}

		Table table = null;

		if (sheetname != null) {

			table = spreadsheet.getSheetByName(sheetname);

		}

		if (table == null) {

			table = spreadsheet.getSheetByIndex(0);

		}

		ArrayList<HashMap<String, String>> data = new ArrayList<HashMap<String, String>>();

		List<Row> rows = table.getRowList();

		ArrayList<String> cols = new ArrayList<String>();

		for (int i = 0 ; i < 4 ; i++) {

			cols.add(rows.get(0).getCellByIndex(i).getStringValue());

		}

		//int rowCount = table.getRowCount();

		for (int iRow = 1 ; iRow < rows.size() ; iRow++) {

			Row row = rows.get(iRow);

			HashMap<String, String> dataline = new HashMap<String, String>();

			data.add(dataline);

			for (int j = 0 ; j < 4 ; j++) {

				String cell = row.getCellByIndex(j).getDisplayText();

				if (cell == null) {

					dataline.put(cols.get(j), "");

				} else {

					dataline.put(cols.get(j), cell);

				}

			}

		}

		return data;

	}