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:Import.ImportGuarantee.java

@Override
protected void threadProcess(XSSFSheet sheet, int index, int lastRowNum) {
    validationError = new StringBuffer();
    List<Object> itemList = new ArrayList<>();
    XSSFRow row = sheet.getRow(index);
    this.rowCount = index + 1;

    logln("? " + rowCount);

    loadDefault(row);/*  w  w  w.j  a v a2  s  . c om*/

    switch (mode) {
    //?
    case STRING_A: {
        PcAuction auction = addPcAuction(row);
        itemList.add(auction);
        break;
    }
    //???
    case STRING_B: {
        PcOrder order = addPcOrder(row);
        itemList.add(order);
        break;
    }
    default:
        ;
    }

    PcInsure insure = addPcInsure(row);
    itemList.add(insure);
    if (validationError.length() > 0) {
        // error ? row ? commit
        this.commit = false;
        log.append("   Error : ");
        log.append(validationError.toString());
        log.append("\n");
        validationError.insert(0, rowCount).insert(0, "ROW ");
        validationErrorList.add(validationError);
    } else {
        log.append("   \n");
        if (this.commit) {
            addItemListDao(itemList);
        }
    }
}

---

From source file:Import.ImportGuarantee.java

@Override
protected int getSheetRowCount(XSSFSheet sheet) {
    int lastRowNum = sheet.getLastRowNum();
    lastRowNum++;//from   www  .  j a  v a2s.c om
    int count = 0;
    for (int i = START_ROW_GUARANTEE; i < lastRowNum; i++) {
        XSSFRow row = sheet.getRow(i);
        XSSFCell cell = row.getCell(0);
        if (cell == null || getStringCellValueNoSetError(cell) == null) {
            return count - START_ROW_GUARANTEE;
        }
        count++;
    }
    return lastRowNum - START_ROW_GUARANTEE;
}

---

From source file:Import.ProgrammerMode.java

private void getHeader(XSSFSheet sheet) {
    XSSFRow row = sheet.getRow(1);
    int lastCellNum = row.getLastCellNum();
    for (int index = 0; index < lastCellNum; index++) {
        validationError = new StringBuffer();
        XSSFCell cell = row.getCell(index);
        log.append(/*from   www .  ja va 2 s.  co  m*/
                "mapStringValidation.put(" + index + ", \"" + getStringCellValueNoSetError(cell) + "\"); \n");
        //            Date value = getDateCellValueSetError(cell, index);
        //            String value = getStringCellValueNoSetError(cell);
        //            Integer value = getIntegerCellValueSetError(cell, index);

        //            BigDecimal value = getBigDecimalCellValueSetError(cell, index);

        //            logln(index + " : " + value);
        //            log.append("XSSFCell cell" + index + " = row.getCell(" + index + ");\n");
        //            log.append("String regisNo = getStringCellValueSetError(cell" + index + ", " + index + "); // " + getStringCellValueNoSetError(cell) + "\n\n");
        //            ShPerson person = createShPerson();
        //            dao.createShPerson(person);
        //            ShAddress address = createShAddress(person);
        //            dao.addEntity(address);
        //            AcDonateMember donateMember = createAcDonateMember(person);
        //            dao.addEntity(donateMember);

        //            logln(person.getPersonId() + " : " + address.getAddressId() + " : " + donateMember.getDonateMemberId());
        TestGUI.refresh();
    }
}

---

From source file:in.expertsoftware.colorcheck.Financial_Standard_WorkingSection_count.java

public ArrayList<String> working_Section(int SOFWDLocation, int EOFWDLocation, XSSFWorkbook workbook) {
    ArrayList<String> workingSection = new ArrayList<String>();
    XSSFRow row;/*w  ww.j  a  v  a2s. co m*/
    XSSFCell cell;
    XSSFSheet Sheet = workbook.getSheet("Financial_Standard");
    String genrateFormula;
    for (int start = (SOFWDLocation - 1); start < EOFWDLocation; start++) {
        try {
            row = Sheet.getRow(start);
            cell = row.getCell(2);
            if (!(cell.getStringCellValue().equals("Common Financial Ratios Reviewed by Lenders"))) {
                switch (cell.getCellType()) {
                case Cell.CELL_TYPE_STRING:
                    genrateFormula = "Financial_Standard!C" + (row.getRowNum() + 1);
                    workingSection.add(genrateFormula);
                    break;
                case Cell.CELL_TYPE_BLANK:
                    break;
                default:
                    System.out.println("Error");
                    break;
                }
            }
        } catch (Exception e) {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
    return workingSection;
}

---

From source file:in.expertsoftware.colorcheck.FormatvarificationErrorList.java

private static void printinfo(XSSFWorkbook ErrorWorkbook, String cell_ref, String sheet_name, String error_desc,
        String error_level) {/*from www.  j  a  v  a2 s . c  o  m*/
    XSSFSheet ErrorSheet = ErrorWorkbook.getSheet(sheet_name);
    if (error_level.equals("Error")) {
        ErrorSheet.getRow(0).getCell(1).setCellValue(1 + ErrorSheet.getRow(0).getCell(1).getNumericCellValue());
    } else if (error_level.equals("Warning")) {
        ErrorSheet.getRow(1).getCell(1).setCellValue(1 + ErrorSheet.getRow(1).getCell(1).getStringCellValue());
    }
    XSSFRow row = ErrorSheet.createRow(ErrorSheet.getPhysicalNumberOfRows());
    CreaateStyleOfErrorList(ErrorWorkbook, row, cell_ref, sheet_name, error_desc, error_level);

}

---

From source file:in.expertsoftware.colorcheck.FormatvarificationErrorList.java

private static void setColorInfoMetaData(XSSFWorkbook ErrorWorkbook) {
    //Set Colour used information on first sheet.
    XSSFSheet setInfoSheet = ErrorWorkbook.getSheetAt(0);
    XSSFRow colourInfoRow;/*from  ww w .  j a va  2  s . c o m*/
    XSSFRow errorColourRow;
    XSSFRow warningColourRow;
    if (setInfoSheet.getPhysicalNumberOfRows() > 5) {
        colourInfoRow = setInfoSheet.getRow(5);
    } else {
        colourInfoRow = setInfoSheet.createRow(5);
    }
    Cell colorInfoCell = colourInfoRow.createCell(6);
    Cell RGBCell = colourInfoRow.createCell(7);
    CreaateHeaderOfErrorList(ErrorWorkbook, colorInfoCell, "Used Color");
    CreaateHeaderOfErrorList(ErrorWorkbook, RGBCell, "RGB Value");
    setInfoSheet.autoSizeColumn(6);
    setInfoSheet.autoSizeColumn(7);
    if (setInfoSheet.getPhysicalNumberOfRows() > 6) {
        errorColourRow = setInfoSheet.getRow(6);
    } else {
        errorColourRow = setInfoSheet.createRow(6);
    }
    if (setInfoSheet.getPhysicalNumberOfRows() > 7) {
        warningColourRow = setInfoSheet.getRow(7);
    } else {
        warningColourRow = setInfoSheet.createRow(7);
    }
    //error color style
    XSSFCellStyle errorStyle = ErrorWorkbook.createCellStyle();
    errorStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
    errorStyle.setFillForegroundColor(new XSSFColor(new java.awt.Color(225, 171, 171)));
    errorColourRow.createCell(6).setCellStyle(errorStyle);
    errorColourRow.getCell(6).setCellValue("Error");
    errorColourRow.createCell(7).setCellValue("225, 171, 171");
    //warning color style
    XSSFCellStyle warningStyle = ErrorWorkbook.createCellStyle();
    warningStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
    warningStyle.setFillForegroundColor(new XSSFColor(new java.awt.Color(155, 194, 230)));
    warningColourRow.createCell(6).setCellStyle(warningStyle);
    warningColourRow.getCell(6).setCellValue("Warning");
    warningColourRow.createCell(7).setCellValue("155, 194, 230");
}

---

From source file:in.expertsoftware.colorcheck.Metadata_Position_Of_Reporting_Qtr.java

public boolean verify_SORQ_metadata_posiition(XSSFSheet Sheet, ArrayList<TokenModel> tokenmodel) {
    int SORQ_rowindex = -1;
    boolean correct = true;
    for (int i = 0; i < tokenmodel.size(); i++) {
        if ((tokenmodel.get(i).token_name.equals("SORQ")))
            SORQ_rowindex = tokenmodel.get(i).row_no;
    }/*from  ww  w  .  j a v a  2  s  .  c  o  m*/
    if (SORQ_rowindex == -1) {
        correct = false;
    } else {
        Row row = Sheet.getRow(SORQ_rowindex - 1);
        Cell cell = row.getCell(1);
        if (!(cell.getStringCellValue().equals("Operation Yield Comparison"))) {
            correct = false;
        }
    }
    return correct;
}

---

From source file:in.expertsoftware.colorcheck.Metadata_Position_Of_Reporting_Qtr.java

public boolean verify_EORQ_metadata_posiition(XSSFSheet Sheet, ArrayList<TokenModel> tokenmodel) {
    int EORQ_rowindex = -1;
    boolean correct = true;
    for (int i = 0; i < tokenmodel.size(); i++) {
        if ((tokenmodel.get(i).token_name.equals("EORQ")))
            EORQ_rowindex = tokenmodel.get(i).row_no;
    }//from   w w w .  j a  va  2 s .c om
    if (EORQ_rowindex == -1) {
        correct = false;
    } else {
        Row row = Sheet.getRow(EORQ_rowindex - 1);
        Cell cell = row.getCell(1);
        if (Sheet.getLastRowNum() == EORQ_rowindex - 1) {
            correct = true;
        } else if (!((cell.getCellType() != CELL_TYPE_BLANK)
                && ((Sheet.getRow(EORQ_rowindex).getCell(0) == null)
                        || (Sheet.getRow(EORQ_rowindex).getCell(0).getCellType() == CELL_TYPE_BLANK))
                && ((Sheet.getRow(EORQ_rowindex).getCell(1) == null)
                        || (Sheet.getRow(EORQ_rowindex).getCell(1).getCellType() == CELL_TYPE_BLANK)))) {
            correct = false;
        }
    }
    return correct;
}

---

From source file:in.expertsoftware.colorcheck.Metadata_Position_Of_Reporting_Year.java

public boolean verify_SORY_metadata_posiition(XSSFSheet Sheet, ArrayList<TokenModel> tokenmodel) {
    int SORY_rowindex = -1;
    boolean correct = true;
    for (int i = 0; i < tokenmodel.size(); i++) {
        if ((tokenmodel.get(i).token_name.equals("SORY")))
            SORY_rowindex = tokenmodel.get(i).row_no;
    }//ww  w.  j a v  a  2  s  .c o m
    if (SORY_rowindex == -1) {
        correct = false;
    } else {
        Row row = Sheet.getRow(SORY_rowindex - 1);
        Cell cell = row.getCell(1);
        if (!(cell.getStringCellValue().equals("Operation Yield Comparison"))) {
            correct = false;
        }
    }
    return correct;
}

---

From source file:in.expertsoftware.colorcheck.Metadata_Position_Of_Reporting_Year.java

public boolean verify_EORY_metadata_posiition(XSSFSheet Sheet, ArrayList<TokenModel> tokenmodel) {
    int EORY_rowindex = -1;
    boolean correct = true;
    for (int i = 0; i < tokenmodel.size(); i++) {
        if ((tokenmodel.get(i).token_name.equals("EORY")))
            EORY_rowindex = tokenmodel.get(i).row_no;
    }/*w w  w .  j a  v  a 2  s .  c om*/
    if (EORY_rowindex == -1) {
        correct = false;
    } else {
        Row row = Sheet.getRow(EORY_rowindex - 1);
        Cell cell = row.getCell(1);
        if (Sheet.getLastRowNum() == EORY_rowindex - 1) {
            correct = true;
        } else if (!((cell.getCellType() != CELL_TYPE_BLANK)
                && ((Sheet.getRow(EORY_rowindex).getCell(0) == null)
                        || (Sheet.getRow(EORY_rowindex).getCell(0).getCellType() == CELL_TYPE_BLANK))
                && ((Sheet.getRow(EORY_rowindex).getCell(1) == null)
                        || (Sheet.getRow(EORY_rowindex).getCell(1).getCellType() == CELL_TYPE_BLANK)))) {
            correct = false;
        }
    }
    return correct;
}

---

• «
• 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
• »