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

org.apache.poi.ss.usermodel.Workbook
High level representation of a Excel workbook. This is the first object most users will construct whether they are reading or writing a workbook. It is also the top level object for creating new sheets/etc.

    public void rule() throws Exception {
        ModelDeclaration model = load("simple.dmdl", "simple");
        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

    public void rulex() throws Exception {
        ModelDeclaration model = load("simple.dmdl", "simple");
        WorkbookGenerator generator = new WorkbookGenerator(folder.getRoot(), WorkbookFormat.RULEX);


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


        Sheet sheet = workbook.getSheet(WorkbookFormat.RULEX.getSheets().get(0).getName());
        checkRuleSheet(sheet, model);
    }

View Full Code Here

        ModelDeclaration model = load("basic_type.dmdl", "simple");
        for (WorkbookFormat format : WorkbookFormat.values()) {
            File dir = folder.newFolder(format.name());
            WorkbookGenerator generator = new WorkbookGenerator(dir, format);
            generator.generate(model);
            Workbook workbook = open(dir, model, format);
            for (SheetFormat sheetForm : format.getSheets()) {
                Sheet sheet = workbook.getSheet(sheetForm.getName());
                if (sheetForm.getKind() == Kind.DATA) {
                    checkDataSheet(sheet, model);
                } else {
                    checkRuleSheet(sheet, model);
                }

View Full Code Here

    public void many_columns() throws Exception {
        ModelDeclaration model = load("many_columns.dmdl", "many_columns");
        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());
        assertThat(sheet.getRow(0).getLastCellNum(), is((short) SpreadsheetVersion.EXCEL97.getMaxColumns()));
    }

View Full Code Here

    public void many_columnsx() throws Exception {
        ModelDeclaration model = load("many_columns.dmdl", "many_columns");
        WorkbookGenerator generator = new WorkbookGenerator(folder.getRoot(), WorkbookFormat.DATAX);


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


        Sheet sheet = workbook.getSheet(WorkbookFormat.DATA.getSheets().get(0).getName());
        assertThat(sheet.getRow(0).getLastCellNum(), is((short) 300));
    }

View Full Code Here

        Collections.addAll(args, "-source", source.getAbsolutePath());
        Collections.addAll(args, "-format", WorkbookFormat.DATA.name());
        int exit = Main.start(args.toArray(new String[args.size()]));
        assertThat(exit, is(0));


        Workbook book = open(output, "simple");
        assertThat(cell(book.getSheetAt(0), 0, 0), is("value"));
    }

View Full Code Here

        Collections.addAll(args, "-source", source.getAbsolutePath());
        Collections.addAll(args, "-format", WorkbookFormat.DATAX.name());
        int exit = Main.start(args.toArray(new String[args.size()]));
        assertThat(exit, is(0));


        Workbook book = open(output, "simple");
        assertThat(cell(book.getSheetAt(0), 0, 0), is("value"));
    }

View Full Code Here

        catch (URISyntaxException e) {
            throw new AssertionError(e);
        }
        InputStream in = resource.openStream();
        try {
            Workbook book = Util.openWorkbookFor(file, in);
            Sheet sheet = book.getSheetAt(0);
            return new ExcelSheetDataModelSource(SIMPLE, uri, sheet);
        } finally {
            in.close();
        }
    }

View Full Code Here


    private Sheet sheet(String name) {
        InputStream in = getClass().getResourceAsStream(name);
        assertThat(name, in, not(nullValue()));
        try {
            Workbook book = new HSSFWorkbook(in);
            return book.getSheetAt(0);
        } catch (IOException e) {
            throw new AssertionError(e);
        } finally {
            try {
                in.close();

View Full Code Here

        if (parent != null && parent.isDirectory() == false && parent.mkdirs() == false) {
            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) {
                    return;
                }
                closed = true;
                LOG.info("Generating job result into {}", output);
                OutputStream stream = new FileOutputStream(output);
                try {
                    workbook.write(stream);
                } finally {
                    stream.close();
                }
            }
        };

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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

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.