Package org.apache.poi.ss.usermodel

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

267
268
269
270
271
272
273
274
     * @throws Exception if failed
     */
    @Test(expected = ExcelRuleExtractor.FormatException.class)
    public void extractNullityCondition_blank() throws Exception {
        ExcelRuleExtractor extractor = new LegacyExcelRuleExtractor();
        Sheet sheet = sheet("invalid.xls");
        extractor.extractNullityCondition(sheet.getRow(4));
    }
View Full Code Here
278
279
280
281
282
283
284
285
     * @throws Exception if failed
     */
    @Test(expected = ExcelRuleExtractor.FormatException.class)
    public void extractNullityCondition_invalid_type() throws Exception {
        ExcelRuleExtractor extractor = new LegacyExcelRuleExtractor();
        Sheet sheet = sheet("invalid.xls");
        extractor.extractNullityCondition(sheet.getRow(5));
    }
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
            throw new IOException(MessageFormat.format(
                    "Failed to create an output directory for {0}",
                    output));
        }
        final Workbook workbook = Util.createEmptyWorkbookFor(output.getPath());
        Sheet sheet = workbook.createSheet("results");
        return new ExcelSheetSink(definition, sheet, version.getMaxColumns()) {
            private boolean closed = false;
            @Override
            public void close() throws IOException {
                if (closed) {
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
        if (matcher.group(1) != null) {
            int sheetNumber = Integer.parseInt(matcher.group(1));
            LOG.debug("Opening sheet by index : {}", sheetNumber);
            try {
                Sheet sheet = book.getSheetAt(sheetNumber);
                assert sheet != null;
                return sheet;
            } catch (RuntimeException e) {
                throw new IOException(MessageFormat.format(
                        "Excelシートの展開に失敗しました: {0} (シート{1}番がありません)",
                        source,
                        sheetNumber), e);
            }
        } else {
            String sheetName = matcher.group(2);
            LOG.debug("Opening sheet by name : {}", sheetName);
            assert sheetName != null;
            Sheet sheet = book.getSheet(sheetName);
            if (sheet == null) {
                throw new IOException(MessageFormat.format(
                        "Excelシートの展開に失敗しました: {0} (シート\"{1}\"がありません)",
                        source,
                        sheetName));
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
    }

    @Override
    public <T> VerifyRule get(
            DataModelDefinition<T> definition, VerifyContext context, URI source) throws IOException {
        Sheet sheet = Util.extract(source);
        if (sheet == null) {
            return null;
        }
        LOG.debug("Finding Excel sheet extractor: {}", source);
        ExcelRuleExtractor extractor = findExtractor(sheet);
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
    @Override
    public <T> DataModelSource open(
            DataModelDefinition<T> definition,
            URI source,
            TestContext context) throws IOException {
        Sheet sheet = Util.extract(source);
        if (sheet == null) {
            return null;
        }
        LOG.info("Excelシートをデータソースに利用します: {}", source);
        return new ExcelSheetDataModelSource(definition, source, sheet);
View Full Code Here
39
40
41
42
43
44
45
46
     * @throws Exception if occur
     */
    @Test
    public void supports() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("simple.xls");
        assertThat(extractor.supports(sheet), is(true));
    }
View Full Code Here
50
51
52
53
54
55
56
57
     * @throws Exception if occur
     */
    @Test
    public void xssf() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("simple.xlsx");
        assertThat(extractor.supports(sheet), is(true));
    }
View Full Code Here
61
62
63
64
65
66
67
68
     * @throws Exception if occur
     */
    @Test
    public void supports_not() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("invalid_format.xls");
        assertThat(extractor.supports(sheet), is(false));
    }
View Full Code Here
72
73
74
75
76
77
78
79
     * @throws Exception if occur
     */
    @Test
    public void supports_invalid_version() throws Exception {
        ExcelRuleExtractor extractor = new DefaultExcelRuleExtractor();
        Sheet sheet = sheet("invalid_format_version.xls");
        assertThat(extractor.supports(sheet), is(false));
    }
View Full Code Here
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
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.