Package org.apache.poi.ss.usermodel

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

64
65
66
67
68
69
70
71
72
73
74
75
76
77
     * simple data.
     * @throws Exception if failed
     */
    @Test
    public void data_simple() throws Exception {
        Workbook workbook = WorkbookGenerator.createEmptyWorkbook(version);
        ModelDeclaration model = load("simple.dmdl", "simple");
        SheetBuilder builder = new SheetBuilder(workbook, version, model);
        builder.addData("MODEL");

        Sheet sheet = workbook.getSheet("MODEL");
        assertThat(sheet, not(nullValue()));
        assertThat(cell(sheet, 0, 0), is("value"));
    }
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
     * copy a data sheet.
     * @throws Exception if failed
     */
    @Test
    public void data_copy() throws Exception {
        Workbook workbook = WorkbookGenerator.createEmptyWorkbook(version);
        ModelDeclaration model = load("simple.dmdl", "simple");
        SheetBuilder builder = new SheetBuilder(workbook, version, model);
        builder.addData("MODEL");
        builder.addData("COPY");

        Sheet sheet = workbook.getSheet("COPY");
        assertThat(sheet, not(nullValue()));
        assertThat(cell(sheet, 0, 0), is("value"));
    }
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
108
109
110
     * primitives.
     * @throws Exception if failed
     */
    @Test
    public void data_primitives() throws Exception {
        Workbook workbook = WorkbookGenerator.createEmptyWorkbook(version);
        ModelDeclaration model = load("basic_type.dmdl", "simple");
        SheetBuilder builder = new SheetBuilder(workbook, version, model);
        builder.addData("PRIMITIVES");

        Sheet sheet = workbook.getSheet("PRIMITIVES");
        assertThat(sheet, not(nullValue()));
        checkDataSheet(sheet, model);
    }
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
124
125
     * check rule.
     * @throws Exception if failed
     */
    @Test
    public void rule() throws Exception {
        Workbook workbook = WorkbookGenerator.createEmptyWorkbook(version);
        ModelDeclaration model = load("basic_type.dmdl", "simple");
        SheetBuilder builder = new SheetBuilder(workbook, version, model);
        builder.addRule("RULE");

        Sheet sheet = workbook.getSheet("RULE");
        checkRuleSheet(sheet, model);
    }
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
     * copy a rule sheet.
     * @throws Exception if failed
     */
    @Test
    public void rule_copy() throws Exception {
        Workbook workbook = WorkbookGenerator.createEmptyWorkbook(version);
        ModelDeclaration model = load("simple.dmdl", "simple");
        SheetBuilder builder = new SheetBuilder(workbook, version, model);
        builder.addRule("MODEL");
        builder.addRule("COPY");

        Sheet sheet = workbook.getSheet("COPY");
        assertThat(sheet, not(nullValue()));
        for (RuleSheetFormat format : RuleSheetFormat.values()) {
            assertThat(format.name(), cell(sheet, format, 0, 0), is(format.getTitle()));
        }
    }
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
265
266
267
            throw new IllegalArgumentException("oldName must not be null"); //$NON-NLS-1$
        }
        if (newName == null) {
            throw new IllegalArgumentException("newName must not be null"); //$NON-NLS-1$
        }
        Workbook workbook = info.workbook;
        int oldIndex = workbook.getSheetIndex(oldName);
        if (oldIndex < 0) {
            throw new IllegalArgumentException();
        }
        Sheet newSheet = workbook.cloneSheet(oldIndex);
        int newIndex = workbook.getSheetIndex(newSheet);
        workbook.setSheetName(newIndex, newName);
    }
View Full Code Here
274
275
276
277
278
279
280
281
282
283
284
285
            sink.close();
        }

        InputStream in = new FileInputStream(file);
        try {
            Workbook workbook = Util.openWorkbookFor(file.getPath(), in);
            Sheet sheet = workbook.getSheetAt(0);
            Row title = sheet.getRow(0);
            assertThat(title.getLastCellNum(), is((short) 256));

            Row content = sheet.getRow(1);
            for (int i = 0; i < title.getLastCellNum(); i++) {
View Full Code Here
341
342
343
344
345
346
347
348
349
350
351
352
        } catch (URISyntaxException e) {
            throw new AssertionError(e);
        }
        InputStream in = resource.openStream();
        try {
            Workbook book = Util.openWorkbookFor(resource.getFile(), in);
            Sheet sheet = book.getSheetAt(0);
            return new ExcelSheetDataModelSource(SIMPLE, uri, sheet);
        } finally {
            in.close();
        }
    }
View Full Code Here
43
44
45
46
47
48
49
50
51
52
    public void data() throws Exception {
        ModelDeclaration model = load("simple.dmdl", "simple");
        WorkbookGenerator generator = new WorkbookGenerator(folder.getRoot(), WorkbookFormat.DATA);

        generator.generate(model);
        Workbook workbook = open(folder.getRoot(), model, WorkbookFormat.DATA);

        Sheet sheet = workbook.getSheet(WorkbookFormat.DATA.getSheets().get(0).getName());
        checkDataSheet(sheet, model);
    }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
    public void datax() throws Exception {
        ModelDeclaration model = load("simple.dmdl", "simple");
        WorkbookGenerator generator = new WorkbookGenerator(folder.getRoot(), WorkbookFormat.DATAX);

        generator.generate(model);
        Workbook workbook = open(folder.getRoot(), model, WorkbookFormat.DATAX);

        Sheet sheet = workbook.getSheet(WorkbookFormat.DATAX.getSheets().get(0).getName());
        checkDataSheet(sheet, model);
    }
View Full Code Here
TOP

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

  • accounts.web.ReportPoiController
  • accounts.web.ReportPoiControllerTest
  • bad.robot.excel.matchers.StubCell
  • br.com.objectos.comuns.io.xls.XlsFile
  • br.com.objectos.way.io.TableStyle
  • br.com.objectos.way.io.WayIO
  • br.com.objectos.way.io.WorkbookXlsApachePOI
  • br.net.woodstock.rockframework.office.spreadsheet.poi.AbstractSpreadsheetDocumentReader
  • com.asakusafw.testdata.generator.excel.MainTest
  • com.asakusafw.testdata.generator.excel.SheetBuilderTest
    • 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.