Examples of org.apache.poi.ss.usermodel.Sheet

org.apache.poi.ss.usermodel.Sheet
High level representation of a Excel worksheet.
Sheets are the central structures within a workbook, and are where a user does most of his spreadsheet work. The most common type of sheet is the worksheet, which is represented as a grid of cells. Worksheet cells can contain text, numbers, dates, and formulas. Cells can also be formatted.

     * @throws Exception if occur
     */
    @Test
    public void extractDataModelCondition_strict() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("total_strict.xls");
        assertThat(extractor.extractDataModelCondition(sheet),
                is((Object) EnumSet.noneOf(DataModelCondition.class)));
    }

View Full Code Here

     * @throws Exception if occur
     */
    @Test
    public void extractDataModelCondition_expect() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("total_expect.xls");
        assertThat(extractor.extractDataModelCondition(sheet),
                is((Object) EnumSet.of(DataModelCondition.IGNORE_UNEXPECTED)));
    }

View Full Code Here

     * @throws Exception if occur
     */
    @Test
    public void extractDataModelCondition_actual() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("total_actual.xls");
        assertThat(extractor.extractDataModelCondition(sheet),
                is((Object) EnumSet.of(DataModelCondition.IGNORE_ABSENT)));
    }

View Full Code Here

     * @throws Exception if occur
     */
    @Test
    public void extractDataModelCondition_intersect() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("total_intersect.xls");
        assertThat(extractor.extractDataModelCondition(sheet),
                is((Object) EnumSet.of(DataModelCondition.IGNORE_UNEXPECTED,
                        DataModelCondition.IGNORE_ABSENT)));
    }

View Full Code Here

     * @throws Exception if occur
     */
    @Test
    public void extractDataModelCondition_skip() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("total_skip.xls");
        assertThat(extractor.extractDataModelCondition(sheet),
                is((Object) EnumSet.allOf(DataModelCondition.class)));
    }

View Full Code Here

     * @throws Exception if occur
     */
    @Test
    public void extractPropertyRowStartIndex() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("simple.xls");
        assertThat(extractor.extractPropertyRowStartIndex(sheet), is(3));
    }

View Full Code Here

     * @throws Exception if occur
     */
    @Test
    public void extractName() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("name.xls");
        assertThat(extractor.extractName(sheet.getRow(3)), is("value"));
        assertThat(extractor.extractName(sheet.getRow(4)), is("a"));
        assertThat(extractor.extractName(sheet.getRow(5)), is("very_long_name"));
    }

View Full Code Here

     * @throws Exception if occur
     */
    @Test
    public void extractName_empty() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("name.xls");
        assertThat(extractor.extractName(sheet.getRow(6)), is(nullValue()));
    }

View Full Code Here

     * @throws Exception if occur
     */
    @Test
    public void extractName_blank() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("name.xls");
        assertThat(extractor.extractName(sheet.getRow(7)), is(nullValue()));
    }

View Full Code Here

     * @throws Exception if occur
     */
    @Test
    public void extractValueCondition() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("value.xls");
        assertThat(extractor.extractValueCondition(sheet.getRow(3)), is(ValueConditionKind.ANY));
        assertThat(extractor.extractValueCondition(sheet.getRow(4)), is(ValueConditionKind.KEY));
        assertThat(extractor.extractValueCondition(sheet.getRow(5)), is(ValueConditionKind.EQUAL));
        assertThat(extractor.extractValueCondition(sheet.getRow(6)), is(ValueConditionKind.CONTAIN));
        assertThat(extractor.extractValueCondition(sheet.getRow(7)), is(ValueConditionKind.TODAY));
        assertThat(extractor.extractValueCondition(sheet.getRow(8)), is(ValueConditionKind.NOW));
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.poi.ss.usermodel.Sheet

accounts.web.ReportPoiController

accounts.web.ReportPoiControllerTest

bad.robot.excel.matchers.StubCell

bad.robot.excel.row.Row

br.com.objectos.comuns.io.xls.XlsFile

br.com.objectos.way.io.POIWorkbook

br.com.objectos.way.io.WayIO

br.com.starcode.trex.spreadsheet.PoiSheetParser

com.asakusafw.testdata.generator.excel.SheetBuilderTest

com.asakusafw.testdata.generator.excel.SheetEditor

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.