Examples of Sheet

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

102
103
104
105
106
107
108
109
110
        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

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

118
119
120
121
122
123
124
125
        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

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

134
135
136
137
138
139
140
141
142
143
144
        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

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

122
123
124
125
126
127
128
129
130
131
132
            throw new IllegalArgumentException("name must not be null"); //$NON-NLS-1$
        }
        if (model == null) {
            throw new IllegalArgumentException("model must not be null"); //$NON-NLS-1$
        }
        Sheet sheet = info.workbook.createSheet(name);
        fillRuleTitles(sheet);
        fillRuleFormat(sheet);
        fillRuleTotalCondition(sheet);
        fillRulePropertyConditions(sheet, model);
        adjustRuleWidth(sheet);
View Full Code Here

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

259
260
261
262
263
264
265
266
267
        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

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

275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
        }

        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++) {
                assertThat(content.getCell(i).getNumericCellValue(), is((double) (Integer) value[i]));
            }
        } finally {
            in.close();
View Full Code Here

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

342
343
344
345
346
347
348
349
350
351
352
            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

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

45
46
47
48
49
50
51
52
        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

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

61
62
63
64
65
66
67
68
        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

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

77
78
79
80
81
82
83
84
        WorkbookGenerator generator = new WorkbookGenerator(folder.getRoot(), WorkbookFormat.RULE);

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

        Sheet sheet = workbook.getSheet(WorkbookFormat.RULE.getSheets().get(0).getName());
        checkRuleSheet(sheet, model);
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.