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

Introduction

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

Prototype

@Override
    public int getLastRowNum() 

Source Link

Usage

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

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

    initBaseData();//from   w  ww  . j ava  2  s .  c o  m
    orderTreeDefItem = initData(RANK_SUBPHYLUM_ID);
    suborderTreeDefItem = initData(RANK_ORDER_ID);
    infraorderTreeDefItem = initData(RANK_INFRAORDER_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();
        switch (theRank) {
        case "Class":
            taxonName = row.getCell(2).getStringCellValue().trim();
            break;
        case "Order":
            if (classTaxon == null || classTaxon.getFullName().equals(taxonName)) {
                classTaxon = getTaxon(taxonName, RANK_CLASS_ID);
            }
            orderTaxon = (Taxon) smtpDao.create(createTaxon(row, classTaxon, RANK_ORDER_ID, orderTreeDefItem));
            break;
        case "Suborder":
            subOrderTaxon = (Taxon) smtpDao
                    .create(createTaxon(row, orderTaxon, RANK_SUBORDER_ID, suborderTreeDefItem));
            break;
        case "Infraorder":
            smtpDao.create(createTaxon(row, subOrderTaxon, RANK_INFRAORDER_ID, infraorderTreeDefItem));
            break;
        default:
            break;
        }
    });
    logger.info("Number of rows : {}", rowEndNumber);
}

---

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();//from   ww  w.  j  a v a  2 s  .c om
    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 a 2 s  .  c  o  m
    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   ww w. ja va2  s.  c  o m
    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();//  www . j a  v  a2 s  .  c  o  m
    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  .  ja  v  a  2  s .  c  o  m*/
    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();/*  w  w  w  .  j a  va 2s . co  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 www . j  av  a  2  s .  co 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();// ww  w  . j a va 2 s.  co 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   w w  w .j  a  v  a 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_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);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• »