Examples of Sheet

br.com.objectos.way.io.AbstractTableParser.Sheet
br.net.woodstock.rockframework.document.spreadsheet.Sheet
br.net.woodstock.rockframework.office.spreadsheet.Sheet
com.common.platform.excel.entity.Sheet
功能描述：Sheet为单元格实体对象。 @author Andy.zheng zhengwei09@founder.com.cn @see javacommon.excel.BigDataExcelReader @version 1.0, 2013-8-8 上午11:38:27 @since Commons Plateform 1.0
com.jclark.xsl.tr.Sheet
Represents a (compiled) XSLT stylesheet. Transforms an XML tree
eu.ha3.matmos.engine.core.interfaces.Sheet
fm.ak.otse.twod.Sheet
a sheet is an image representing {@link Sprite Sprite}s. Creates a Sprite called 'entirety' spanning the entire sheet @author Petrus
jxl.Sheet
Represents a sheet within a workbook. Provides a handle to the individual cells, or lines of cells (grouped by Row or Column)
org.apache.harmony.x.swing.text.html.cssparser.metamodel.Sheet
org.apache.pivot.wtk.Sheet
Window class representing a "sheet". A sheet behaves like a dialog that is modal only over a window's content component.
org.apache.poi.hslf.model.Sheet
This class defines the common format of "Sheets" in a powerpoint document. Such sheets could be Slides, Notes, Master etc @author Nick Burch
org.apache.poi.hssf.model.Sheet
enoffice.org/excelfileformat.pdf before even attempting to use this.
@author Andrew C. Oliver (acoliver at apache dot org) @author Glen Stampoultzis (glens at apache.org) @author Shawn Laubach (slaubach at apache dot org) Gridlines, Headers, Footers, PrintSetup, and Setting Default Column Styles @author Jason Height (jheight at chariot dot net dot au) Clone support. DBCell & Index Record writing support @author Brian Sanders (kestrel at burdell dot org) Active Cell support @author Jean-Pierre Paris (jean-pierre.paris at m4x dot org) (Just a little) @see org.apache.poi.hssf.model.Workbook @see org.apache.poi.hssf.usermodel.HSSFSheet @version 1.0-pre
org.apache.poi.ss.usermodel.Sheet
High level representation of a Excel worksheet.
Sheets are the central structures within a workbook, and are where a user does most of his spreadsheet work. The most common type of sheet is the worksheet, which is represented as a grid of cells. Worksheet cells can contain text, numbers, dates, and formulas. Cells can also be formatted.
org.archive.spring.Sheet
Collection of overrides: alternative values for object properties that should apply in some contexts. The target is specified as an arbitrarily-long property-path, a string describing how to access the property starting from a beanName in a BeanFactory. Once a Sheet has all its mappings, and all beans that could be affected by its mappings have been instantiated, the sheet must be 'primed' with respect to the bean factory. This step lets every target of the overlay values know the full bean-path(s) that it should check for overlays. (Otherwise, beans -- especially unnamed inner beans -- may not know the full-paths that lead to their properties.) Also, this step catches in advance type mismatches, or attempts to overlay non-overlayable properties.
org.jmol.modelsetbio.Sheet
org.jopendocument.dom.spreadsheet.Sheet
org.netbeans.server.uihandler.statistics.CoProjects.Sheet
org.netbeans.server.uihandler.statistics.Technology.Sheet
org.openide.nodes.Sheet
org.uguess.birt.report.engine.spreadsheet.model.Sheet
This interface represents a sheet object.
org.xlsx4j.sml.Sheet
3.org/2001/XMLSchema}anyType"> <attribute name="name" use="required" type="{http://schemas.openxmlformats.org/officeDocument/2006/sharedTypes}ST_Xstring" /> <attribute name="sheetId" use="required" type="{http://www.w3.org/2001/XMLSchema}unsignedInt" /> <attribute name="state" type="{http://schemas.openxmlformats.org/spreadsheetml/2006/main}ST_SheetState" default="visible" /> <attribute ref="{http://schemas.openxmlformats.org/officeDocument/2006/relationships}id use="required""/> </restriction> </complexContent> </complexType>
org.zkoss.poi.ss.usermodel.Sheet
org.zkoss.zss.model.Sheet
Represents the Sheet model of a Spread Sheet book. @author tomyeh
pivot.wtk.Sheet
Window class representing a "sheet". A sheet behaves like a dialog that is modal only over a window's content component. @author gbrown

Examples of org.apache.harmony.x.swing.text.html.cssparser.metamodel.Sheet

        }
    }


    private void parseSheet(final boolean asResolver) {
//        throw new UnsupportedOperationException("CSS parser required!");
        Sheet ss = null;
        try {
            ss = parser.parse();
        } catch (ParseException e) {
            e.printStackTrace();
        }
        addImportedStyleSheets(ss.getImportsIterator(), asResolver);
        addParsedSheet(ss.getRuleSetIterator(), asResolver);
    }

View Full Code Here

Examples of org.apache.pivot.wtk.Sheet


        display.getStyles().put("backgroundColor", new Color(0, 127, 127));
        window1.setContent(new Label("Hello Bar"));
        window1.open(display);


        Sheet sheet = new Sheet();
        sheet.setContent(new Label("Hello Foo"));
        sheet.open(window1);


        Frame window1a = new Frame();
        window1a.setTitle("Window 1 A");
        window1a.setPreferredSize(160, 120);
        window1a.open(window1);

View Full Code Here

Examples of org.apache.poi.hslf.model.Sheet

        CharFlagsTextProp cftp = null;
        if (characterStyle != null){
            cftp = (CharFlagsTextProp)characterStyle.findByName("char_flags");
        }
        if (cftp == null){
            Sheet sheet = parentRun.getSheet();
            int txtype = parentRun.getRunType();
            SlideMaster master = (SlideMaster)sheet.getMasterSheet();
            cftp = (CharFlagsTextProp)master.getStyleAttribute(txtype, getIndentLevel(), "char_flags", true);
        }


    return cftp == null ? false : cftp.getSubValue(index);
  }

View Full Code Here

Examples of org.apache.poi.hssf.model.Sheet

        
        // convert all LabelRecord records to LabelSSTRecord
        convertLabelRecords(records, recOffset);        
        while (recOffset < records.size())
        {
            Sheet sheet = Sheet.createSheet(records, sheetNum++, recOffset );


            recOffset = sheet.getEofLoc()+1;
            if (recOffset == 1)
            {
                break;
            }

View Full Code Here

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

      FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
      evaluateAllFormulaCells(wb, evaluator);
  }
  private static void evaluateAllFormulaCells(Workbook wb, FormulaEvaluator evaluator) {
      for(int i=0; i<wb.getNumberOfSheets(); i++) {
         Sheet sheet = wb.getSheetAt(i);


         for(Row r : sheet) {
            for (Cell c : r) {
               if (c.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
                  evaluator.evaluateFormulaCell(c);

View Full Code Here

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

       assertEquals(3, wb.getNumberOfSheets());
       
       // Try each cell individually
       XSSFFormulaEvaluator eval = new XSSFFormulaEvaluator(wb);
       for(int i=0; i<wb.getNumberOfSheets(); i++) {
          Sheet s = wb.getSheetAt(i);
          for(Row r : s) {
             for(Cell c : r) {
                if(c.getCellType() == Cell.CELL_TYPE_FORMULA) {
                    CellValue cv = eval.evaluate(c);
                    if(cv.getCellType() == Cell.CELL_TYPE_NUMERIC) {

View Full Code Here

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

     * Ensure General and @ format are working properly
     *  for integers 
     */
    public void test47490() throws Exception {
       XSSFWorkbook wb = XSSFTestDataSamples.openSampleWorkbook("GeneralFormatTests.xlsx");
       Sheet s = wb.getSheetAt(1);
       Row r;
       DataFormatter df = new DataFormatter();
       
       r = s.getRow(1);
       assertEquals(1.0, r.getCell(2).getNumericCellValue());
       assertEquals("General", r.getCell(2).getCellStyle().getDataFormatString());
       assertEquals("1", df.formatCellValue(r.getCell(2)));
       assertEquals("1", df.formatRawCellContents(1.0, -1, "@"));
       assertEquals("1", df.formatRawCellContents(1.0, -1, "General"));
              
       r = s.getRow(2);
       assertEquals(12.0, r.getCell(2).getNumericCellValue());
       assertEquals("General", r.getCell(2).getCellStyle().getDataFormatString());
       assertEquals("12", df.formatCellValue(r.getCell(2)));
       assertEquals("12", df.formatRawCellContents(12.0, -1, "@"));
       assertEquals("12", df.formatRawCellContents(12.0, -1, "General"));
       
       r = s.getRow(3);
       assertEquals(123.0, r.getCell(2).getNumericCellValue());
       assertEquals("General", r.getCell(2).getCellStyle().getDataFormatString());
       assertEquals("123", df.formatCellValue(r.getCell(2)));
       assertEquals("123", df.formatRawCellContents(123.0, -1, "@"));
       assertEquals("123", df.formatRawCellContents(123.0, -1, "General"));

View Full Code Here

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

       Workbook[] wbs = new Workbook[] {
             new HSSFWorkbook(),
             new XSSFWorkbook()
       };
       for(Workbook wb : wbs) {
          Sheet s = wb.createSheet();
          Row r = s.createRow(0);
          
          // Setup
          Cell cn = r.createCell(0, Cell.CELL_TYPE_NUMERIC);
          cn.setCellValue(1.2);
          Cell cs = r.createCell(1, Cell.CELL_TYPE_STRING);

View Full Code Here

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


    }


    public void test49783() throws Exception {
        Workbook wb =  XSSFTestDataSamples.openSampleWorkbook("49783.xlsx");
        Sheet sheet = wb.getSheetAt(0);
        FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
        Cell cell;


        cell = sheet.getRow(0).getCell(0);
        assertEquals("#REF!*#REF!", cell.getCellFormula());
        assertEquals(Cell.CELL_TYPE_ERROR, evaluator.evaluateInCell(cell).getCellType());
        assertEquals("#REF!", FormulaError.forInt(cell.getErrorCellValue()).getString());


        Name nm1 = wb.getName("sale_1");
        assertNotNull("name sale_1 should be present", nm1);
        assertEquals("Sheet1!#REF!", nm1.getRefersToFormula());
        Name nm2 = wb.getName("sale_2");
        assertNotNull("name sale_2 should be present", nm2);
        assertEquals("Sheet1!#REF!", nm2.getRefersToFormula());


        cell = sheet.getRow(1).getCell(0);
        assertEquals("sale_1*sale_2", cell.getCellFormula());
        assertEquals(Cell.CELL_TYPE_ERROR, evaluator.evaluateInCell(cell).getCellType());
        assertEquals("#REF!", FormulaError.forInt(cell.getErrorCellValue()).getString());
    }

View Full Code Here

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


    public void test49156() throws Exception {
        Workbook wb = XSSFTestDataSamples.openSampleWorkbook("49156.xlsx");
        FormulaEvaluator formulaEvaluator = wb.getCreationHelper().createFormulaEvaluator();


        Sheet sheet = wb.getSheetAt(0);
        for(Row row : sheet){
            for(Cell cell : row){
                if(cell.getCellType() == Cell.CELL_TYPE_FORMULA){
                    formulaEvaluator.evaluateInCell(cell); // caused NPE on some cells
                }

View Full Code Here

0 1 2 3 4 5 6 7

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.