Example usage for org.apache.poi.xssf.usermodel XSSFSheet getRow

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFSheet getRow.

Prototype

@Override
public XSSFRow getRow(int rownum) 

Source Link

Document

Returns the logical row ( 0-based).

Usage

From source file:se.nrm.dina.dina.inventory.logic.dyntaxa.DyntaxaDumpLogic.java

public void uploadSuperfamily() {

    logger.info("uploadSuperfamily - excel file path : {}", EXCEL_FILE_PATH);

    initBaseData();//  w  w w .jav a2 s .  c o m
    superfamilyTreeDefItem = initData(RANK_SUPERFAMILY_ID);

    XSSFSheet sheet = getExcelSheet();
    int rowEndNumber = sheet.getLastRowNum();
    IntStream.range(1, rowEndNumber + 1).forEach(nbr -> {
        XSSFRow row = sheet.getRow(nbr);
        String theRank = row.getCell(1).getStringCellValue();
        if (theRank.equals("Order") || theRank.equals("Suborder") || theRank.equals("Infraorder")) {
            taxonName = row.getCell(2).getStringCellValue().trim();
            currentRankId = getRankId(theRank);
        } else if (theRank.equals("Superfamily")) {
            if (currentParent == null || !currentParent.getFullName().equals(taxonName)) {
                currentParent = getTaxon(taxonName, currentRankId);
            }
            smtpDao.create(createTaxon(row, currentParent, RANK_SUPERFAMILY_ID, superfamilyTreeDefItem));
        }
    });
}

---

From source file:se.nrm.dina.dina.inventory.logic.dyntaxa.DyntaxaDumpLogic.java

public void uploadFamily() {
    logger.info("uploadFamily - excel file path : {}", EXCEL_FILE_PATH);

    List<Taxon> list = new ArrayList();
    initBaseData();// w  ww.j a  v  a2 s.com
    familyTreeDefItem = initData(RANK_FAMILY_ID);

    XSSFSheet sheet = getExcelSheet();
    int rowEndNumber = sheet.getLastRowNum();
    IntStream.range(1, rowEndNumber + 1).forEach(nbr -> {
        XSSFRow row = sheet.getRow(nbr);
        String theRank = row.getCell(1).getStringCellValue();
        if (theRank.equals("Order") || theRank.equals("Suborder") || theRank.equals("Infraorder")
                || theRank.equals("Superfamily")) {
            taxonName = row.getCell(2).getStringCellValue().trim();
            currentRankId = getRankId(theRank);
        } else if (theRank.equals("Family")) {
            if (currentParent == null || !currentParent.getFullName().equals(taxonName)) {
                currentParent = getTaxon(taxonName, currentRankId);
            }
            list.add(createTaxon(row, currentParent, RANK_FAMILY_ID, familyTreeDefItem));
            //                        smtpDao.create(createTaxon(row, currentParent, RANK_FAMILY_ID, familyTreeDefItem)); 
        }
    });
    smtpDao.bacthCreate(list);
}

---

From source file:se.nrm.dina.dina.inventory.logic.dyntaxa.DyntaxaDumpLogic.java

public void uploadSubfamily() {
    logger.info("uploadSubfamily - excel file path : {}", EXCEL_FILE_PATH);

    List<Taxon> list = new ArrayList();
    initBaseData();//from w w w .  j  ava 2s. c om
    subfamilyTreeDefItem = initData(RANK_SUBFAMILY_ID);

    XSSFSheet sheet = getExcelSheet();
    int rowEndNumber = sheet.getLastRowNum();
    IntStream.range(1, rowEndNumber + 1).forEach(nbr -> {
        XSSFRow row = sheet.getRow(nbr);
        String theRank = row.getCell(1).getStringCellValue();
        if (theRank.equals("Family")) {
            taxonName = row.getCell(2).getStringCellValue().trim();
        } else if (theRank.equals("Subfamily")) {
            if (familyTaxon == null || !familyTaxon.getFullName().equals(taxonName)) {
                familyTaxon = getTaxon(taxonName, RANK_FAMILY_ID);
            }
            list.add(createTaxon(row, familyTaxon, RANK_SUBFAMILY_ID, subfamilyTreeDefItem));
            //                        smtpDao.create(createTaxon(row, familyTaxon, RANK_SUBFAMILY_ID, subfamilyTreeDefItem)); 
        }
    });
    smtpDao.bacthCreate(list);
}

---

From source file:se.nrm.dina.dina.inventory.logic.dyntaxa.DyntaxaDumpLogic.java

public void uploadTribe() {
    logger.info("uploadTribe - excel file path : {}", EXCEL_FILE_PATH);

    List<Taxon> list = new ArrayList();
    initBaseData();/* w ww  .  ja va2 s . c om*/
    tribeTreeDefItem = initData(RANK_TRIBE_ID);

    XSSFSheet sheet = getExcelSheet();
    int rowEndNumber = sheet.getLastRowNum();
    IntStream.range(1, rowEndNumber + 1).forEach(nbr -> {
        XSSFRow row = sheet.getRow(nbr);
        String theRank = row.getCell(1).getStringCellValue();
        if (theRank.equals("Superfamily") || theRank.equals("Family") || theRank.equals("Subfamily")) {
            taxonName = row.getCell(2).getStringCellValue().trim();
            currentRankId = getRankId(theRank);
        } else if (theRank.equals("Tribe")) {
            if (currentParent == null || !currentParent.getFullName().equals(taxonName)) {
                currentParent = getTaxon(taxonName, currentRankId);
            }
            list.add(createTaxon(row, currentParent, RANK_TRIBE_ID, tribeTreeDefItem));
            //                        smtpDao.create(createTaxon(row, currentParent, RANK_TRIBE_ID, tribeTreeDefItem));
        }
    });
    smtpDao.bacthCreate(list);
}

---

From source file:se.nrm.dina.dina.inventory.logic.dyntaxa.DyntaxaDumpLogic.java

public void uploadSubtribe() {
    logger.info("uploadSubtribe - excel file path : {}", EXCEL_FILE_PATH);

    List<Taxon> list = new ArrayList();
    initBaseData();//from ww w .j  av  a  2  s  . c  om
    subtribeTreeDefItem = initData(RANK_SUBTRIBE_ID);

    XSSFSheet sheet = getExcelSheet();
    int rowEndNumber = sheet.getLastRowNum();
    IntStream.range(1, rowEndNumber + 1).forEach(nbr -> {
        XSSFRow row = sheet.getRow(nbr);
        String theRank = row.getCell(1).getStringCellValue();
        if (theRank.equals("Tribe")) {
            taxonName = row.getCell(2).getStringCellValue().trim();
        } else if (theRank.equals("Subtribe")) {
            if (tribeTaxon == null || !tribeTaxon.getFullName().equals(taxonName)) {
                tribeTaxon = getTaxon(taxonName, RANK_TRIBE_ID);
            }
            //                        smtpDao.create(createTaxon(row, tribeTaxon, RANK_SUBTRIBE_ID, subtribeTreeDefItem)); 
            list.add(createTaxon(row, tribeTaxon, RANK_SUBTRIBE_ID, subtribeTreeDefItem));
        }
    });
    smtpDao.bacthCreate(list);
}

---

From source file:se.nrm.dina.dina.inventory.logic.dyntaxa.DyntaxaDumpLogic.java

public void uploadGenus() {
    logger.info("uploadGenus - excel file path : {}", EXCEL_FILE_PATH);

    List<Taxon> list = new ArrayList();
    initBaseData();//  ww w .  ja v  a  2 s.c o  m
    genusTreeDefItem = initData(RANK_GENUS_ID);

    XSSFSheet sheet = getExcelSheet();
    int rowEndNumber = sheet.getLastRowNum();
    IntStream.range(1, rowEndNumber + 1).forEach(nbr -> {
        XSSFRow row = sheet.getRow(nbr);
        String theRank = row.getCell(1).getStringCellValue();
        if (theRank.equals("Family") || theRank.equals("Subfamily") || theRank.equals("Tribe")
                || theRank.equals("Subtribe")) {
            taxonName = row.getCell(2).getStringCellValue().trim();
            currentRankId = getRankId(theRank);
        } else if (theRank.equals("Genus")) {
            if (currentParent == null || !currentParent.getFullName().equals(taxonName)) {
                currentParent = getTaxon(taxonName, currentRankId);
            }

            list.add(createTaxon(row, currentParent, RANK_GENUS_ID, genusTreeDefItem));
            if (list.size() % 1000 == 0) {
                smtpDao.bacthCreate(list);
                list.clear();
            }
        }
    });
    logger.info("list size : {}", list.size());
    if (!list.isEmpty()) {
        smtpDao.bacthCreate(list);
    }
    logger.info("Number of rows : {}", rowEndNumber);
}

---

From source file:se.nrm.dina.dina.inventory.logic.dyntaxa.DyntaxaDumpLogic.java

public void uploadSubgenus() {
    logger.info("uploadSubgenus - excel file path : {}", EXCEL_FILE_PATH);

    List<Taxon> list = new ArrayList();
    initBaseData();/*from   w ww . ja  va 2  s  . c  o  m*/
    subgenusTreeDefItem = initData(RANK_SUBGENUS_ID);

    XSSFSheet sheet = getExcelSheet();
    int rowEndNumber = sheet.getLastRowNum();
    IntStream.range(1, rowEndNumber + 1).forEach(nbr -> {
        XSSFRow row = sheet.getRow(nbr);
        String theRank = row.getCell(1).getStringCellValue();

        if (theRank.equals("Genus")) {
            taxonName = row.getCell(2).getStringCellValue().trim();
        } else if (theRank.equals("Subgenus")) {
            if (genusTaxon == null || !genusTaxon.getFullName().equals(taxonName)) {
                genusTaxon = getTaxon(taxonName, RANK_GENUS_ID);
            }
            list.add(createTaxon(row, genusTaxon, RANK_SUBGENUS_ID, subgenusTreeDefItem));
            if (list.size() % 1000 == 0) {
                smtpDao.bacthCreate(list);
                list.clear();
            }
        }
    });
    logger.info("list size : {}", list.size());
    if (!list.isEmpty()) {
        smtpDao.bacthCreate(list);
    }
    logger.info("Number of rows : {}", rowEndNumber);
}

---

From source file:se.nrm.dina.dina.inventory.logic.dyntaxa.DyntaxaDumpLogic.java

public void uploadSubspecies() {
    logger.info("uploadSubspecies - excel file path : {}", EXCEL_FILE_PATH);

    List<Taxon> list = new ArrayList();

    initBaseData();//from  w ww.j a v a  2 s  .c o m
    subspeciesTreeDefItem = initData(RANK_SUBSPECIES_ID);

    XSSFSheet sheet = getExcelSheet();
    int rowEndNumber = sheet.getLastRowNum();
    IntStream.range(1, rowEndNumber + 1).forEach(nbr -> {
        XSSFRow row = sheet.getRow(nbr);
        String theRank = row.getCell(1).getStringCellValue();
        if (theRank.equals("Species")) {
            taxonName = row.getCell(2).getStringCellValue().trim();
        } else if (theRank.equals("Subspecies")) {
            if (speciesTaxon == null || !speciesTaxon.getFullName().equals(taxonName)) {
                speciesTaxon = getTaxon(taxonName, RANK_SPECIES_ID);
            }
            list.add(createTaxon(row, speciesTaxon, RANK_SUBSPECIES_ID, subspeciesTreeDefItem));
            if (list.size() % 1000 == 0) {
                smtpDao.bacthCreate(list);
                list.clear();
            }
        }
    });

    logger.info("list size : {}", list.size());
    if (!list.isEmpty()) {
        smtpDao.bacthCreate(list);
    }
    logger.info("Number of rows : {}", rowEndNumber);
}

---

From source file:se.nrm.dina.dina.inventory.logic.dyntaxa.DyntaxaDumpLogic.java

public void uploadSpeciesOnSubgenus() {
    logger.info("uploadSubgenus - excel file path : {}", EXCEL_FILE_PATH);

    List<Taxon> list = new ArrayList();

    initBaseData();/*from  ww  w. j a v a2  s  .  com*/
    speciesTreeDefItem = initData(RANK_SPECIES_ID);
    XSSFSheet sheet = getExcelSheet();
    int rowEndNumber = sheet.getLastRowNum();
    IntStream.range(1, rowEndNumber + 1).forEach(nbr -> {
        XSSFRow row = sheet.getRow(nbr);
        String theRank = row.getCell(1).getStringCellValue();
        if (theRank.equals("Genus") || theRank.equals("Subgenus")) {
            currentRankId = getRankId(theRank);
            if (currentRankId == RANK_SUBGENUS_ID) {
                taxonName = row.getCell(2).getStringCellValue().trim();
            }
        } else if (theRank.equals("Species")) {
            if (currentRankId == RANK_SUBGENUS_ID) {
                if (subgenusTaxon == null || !subgenusTaxon.getFullName().equals(taxonName)) {
                    subgenusTaxon = getTaxon(taxonName, RANK_SUBGENUS_ID);
                }
                list.add(createTaxon(row, subgenusTaxon, RANK_SPECIES_ID, speciesTreeDefItem));
                if (list.size() % 1000 == 0) {
                    smtpDao.bacthCreate(list);
                    list.clear();
                }
            }
        }
    });
    logger.info("list size : {}", list.size());
    if (!list.isEmpty()) {
        smtpDao.bacthCreate(list);
    }
    logger.info("Number of rows : {}", rowEndNumber);
}

---

From source file:se.nrm.dina.dina.inventory.logic.dyntaxa.DyntaxaDumpLogic.java

public void uploadSpeciesOnGenus() {
    logger.info("uploadSubgenus - excel file path : {}", EXCEL_FILE_PATH);

    List<Taxon> list = new ArrayList();

    initBaseData();//from w ww.j  a va  2s  .c  o  m
    speciesTreeDefItem = initData(RANK_SPECIES_ID);
    XSSFSheet sheet = getExcelSheet();
    int rowEndNumber = sheet.getLastRowNum();
    IntStream.range(1, rowEndNumber + 1).forEach(nbr -> {
        XSSFRow row = sheet.getRow(nbr);
        String theRank = row.getCell(1).getStringCellValue();

        if (theRank.equals("Genus") || theRank.equals("Subgenus")) {
            currentRankId = getRankId(theRank);
            if (currentRankId == RANK_GENUS_ID) {
                taxonName = row.getCell(2).getStringCellValue().trim();
            }
        } else if (theRank.equals("Species")) {
            if (currentRankId == RANK_GENUS_ID) {
                if (genusTaxon == null || !genusTaxon.getFullName().equals(taxonName)) {
                    genusTaxon = getTaxon(taxonName, RANK_GENUS_ID);
                }
                list.add(createTaxon(row, genusTaxon, RANK_SPECIES_ID, speciesTreeDefItem));
                if (list.size() % 1000 == 0) {
                    smtpDao.bacthCreate(list);
                    list.clear();
                }
            }
        }
    });

    logger.info("list size : {}", list.size());
    if (!list.isEmpty()) {
        smtpDao.bacthCreate(list);
    }
    logger.info("Number of rows : {}", rowEndNumber);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• »