Examples of Workbook

com.aspose.cells.Workbook
com.extentech.formats.XLS.WorkBook
```
 The WorkBook record represents an XLS workbook substream containing worksheets and associated records. 
```
@see WorkBook @see Boundsheet @see Index @see Dbcell @see Row @see Cell @see XLSRecord
jmc.Workbook
jxl.Workbook
Represents a Workbook. Contains the various factory methods and provides a variety of accessors which provide access to the work sheets.
org.apache.poi.hssf.model.Workbook
enoffice.org/excelfileformat.pdf before even attempting to use this. @author Luc Girardin (luc dot girardin at macrofocus dot com) @author Sergei Kozello (sergeikozello at mail.ru) @author Shawn Laubach (slaubach at apache dot org) (Data Formats) @author Andrew C. Oliver (acoliver at apache dot org) @author Brian Sanders (bsanders at risklabs dot com) - custom palette @author Dan Sherman (dsherman at isisph.com) @author Glen Stampoultzis (glens at apache.org) @see org.apache.poi.hssf.usermodel.HSSFWorkbook
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.
org.openoffice.xmerge.converter.xml.sxc.pexcel.records.Workbook
This class is used by PxlDocument to maintain pexcel workbooks. @author Martin Maher
org.zkoss.poi.ss.usermodel.Workbook

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

        } 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

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

    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

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

    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

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

    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

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

    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

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

        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

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

    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

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

    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

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

        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

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

        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

0 1 2 3 4 5

TOP

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.