io.github.oliviercailloux.j_voting.profiles.management.TestODS Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of j-voting Show documentation

General classes for dealing with social choice theory.

The newest version!

package io.github.oliviercailloux.j_voting.profiles.management;

import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;

import org.odftoolkit.simple.SpreadsheetDocument;
import org.odftoolkit.simple.table.Cell;
import org.odftoolkit.simple.table.Column;
import org.odftoolkit.simple.table.Table;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import io.github.oliviercailloux.j_voting.Alternative;
import io.github.oliviercailloux.j_voting.Voter;

/**
 * Simplified from odftoolkit
 * doc.
 *
 * @author Olivier Cailloux, modified by Quentin Sauvage
 *
 */
public class TestODS {

	private static final Logger LOGGER = LoggerFactory.getLogger(TestODS.class);

	public static void main(String[] args) throws Exception {
		new TestODS().generateSpreadsheetDocument();
	}

	public void generateSpreadsheetDocument() throws Exception {
		try (InputStream inputStream = TestODS.class.getResourceAsStream("demo9_data.ods");
				SpreadsheetDocument spreadsheetDoc = SpreadsheetDocument.loadDocument(inputStream)) {
			List tables = spreadsheetDoc.getTableList();
			for (Table table : tables) {
				List voters = new ArrayList<>();
				for (Column column : table.getColumnList()) {
					List alternatives = new ArrayList<>();
					String firstCellText = column.getCellByIndex(0).getDisplayText();
					voters.add(Voter.withId(Integer.parseInt(
							firstCellText.substring(firstCellText.length() - 1, firstCellText.indexOf(' ')))));
					for (int alt = Integer.parseInt(column.getCellByIndex(1).getDisplayText()); alt < column
							.getCellCount(); alt++) {
						alternatives.add(Alternative.withId(alt));
					}
				}
			}
			Cell positionCell = spreadsheetDoc.getTableByName("B").getCellByPosition("E1");
			LOGGER.info("Found: {}.", positionCell.getDisplayText());
			positionCell.setStringValue("ploum");
			spreadsheetDoc.save("demo9s.ods");
		}
	}
}
    

    







    © 2015 - 2025 Weber Informatics LLC | Privacy Policy