Examples of com.extentech.formats.XLS.Boundsheet

com.extentech.formats.XLS.Boundsheet
Boundsheet: WorkSheet Information 0x85
This record stores the sheet name, type and stream position.
```
 offset  name        size    contents --- 4       lbPlyPos    4       Stream position of the BOF for the sheet 8       grbit       2       Option flags 10      cch         1       Length of sheet name 11      grbitChr    1       Compressed/Uncompressed Unicode 12      rgch        var     Sheet name 
```
---- File Layout ---- BOUNDSHEET Bof Index Row1 is first index in DBCELL Row2 is the offset of any DBCELLS Row... CELLREC CELLREC CELLREC DBCELL rgdb rg rg rg rg ROWS CELLS DBCELL rg rg rg ... EOF ---------------------- lbplypos used to be the most important thing on earth. now it is not an issue. @see WorkBook @see Index @see Dbcell @see Row @see Cell @see XLSRecord

        int h = 0;
        if(b)h=Boundsheet.VERY_HIDDEN ;
        mysheet.setHidden(h);
        int t = mysheet.getSheetNum();
        try{ // set the next sheet selected...
            Boundsheet s2 = mybook.getWorkSheetByNumber(t+1);
            s2.setSelected(true);
        }catch(WorkSheetNotFoundException e){;}
    }

View Full Code Here

        int h = 0;
        if(b)h=Boundsheet.HIDDEN;
        mysheet.setHidden(h);
        if(mysheet.getSheetNum() == 0){
            try{
                Boundsheet s2 = mybook.getWorkSheetByNumber(mysheet.getSheetNum()+1);
                mybook.setFirstVisibleSheet(s2);
            }catch(WorkSheetNotFoundException e){;}
        }
        if(mysheet.selected()){
            try{ // set the next sheet selected...
                int x = 1;
                Boundsheet s2 = mybook.getWorkSheetByNumber(mysheet.getSheetNum()+x);
                while(s2.getHidden())s2 = mybook.getWorkSheetByNumber(mysheet.getSheetNum()+x++);
                s2.setSelected(true);
            }catch(WorkSheetNotFoundException e){;}
        }
    }

View Full Code Here

   */
  public String getXML() {
      StringBuffer retXML = new StringBuffer();
      String nmv = getExpressionString();
      if(nmv.indexOf("=!")>-1) { // add the sheetname
        Boundsheet bs = myName.getSheet();
        if(bs!=null) {
          nmv = bs.getSheetName() + "!" + nmv;
        }else{ // TODO: why no sheet defined for name???
          nmv = StringTool.replaceChars("!", nmv, "");
        }
      }
      // it's possible that name expression can have quotes and other non-compliant characters

View Full Code Here

   * @return String XML rep of all the cells referenced by this range
   */
  public String getExpandedXML() {
      String nmv = getExpressionString();
      if(nmv.indexOf("=!")>-1) { // add the sheetname
        Boundsheet bs = myName.getSheet();
        if(bs!=null) {
          nmv = bs.getSheetName() + "!" + nmv;
        }else{ // TODO: why no sheet defined for name???
          nmv = StringTool.replaceChars("!", nmv, "");
        }
      }
      String nmx = getName();

View Full Code Here

0 1

TOP

Related Classes of com.extentech.formats.XLS.Boundsheet

com.extentech.ExtenXLS.NameHandle

com.extentech.ExtenXLS.WorkBookHandle

com.extentech.ExtenXLS.WorkSheetHandle

com.extentech.formats.OOXML.OneCellAnchor

com.extentech.formats.OOXML.SheetPr

com.extentech.formats.OOXML.SheetView

com.extentech.formats.OOXML.Text

com.extentech.formats.OOXML.TwoCellAnchor

com.extentech.formats.XLS.formulas.PtgArea

com.extentech.formats.XLS.formulas.PtgRef

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.