Examples of org.apache.poi.hssf.record.NameRecord$Option

org.apache.poi.hssf.record.NameRecord
Title: DEFINEDNAME Record (0x0018)
Description: Defines a named range within a workbook.
REFERENCE:
@author Libin Roman (Vista Portal LDT. Developer) @author Sergei Kozello (sergeikozello at mail.ru) @author Glen Stampoultzis (glens at apache.org) @version 1.0-pre

        
        // Check all names fit within range, and use
        //  DeletedArea3DPtg
        Workbook w = wb.getWorkbook();
        for(int i=0; i<w.getNumNames(); i++) {
          NameRecord r = w.getNameRecord(i);
          assertTrue(r.getIndexToSheet() <= wb.getNumberOfSheets());
          
          List nd = r.getNameDefinition();
          assertEquals(1, nd.size());
          assertTrue(nd.get(0) instanceof DeletedArea3DPtg);
        }
        
        
        // Delete the 2nd sheet
        wb.removeSheetAt(1);
        
        
        // Re-check
        assertEquals(1, wb.getNumberOfNames());
        assertEquals(2, wb.getNumberOfSheets());
        
        for(int i=0; i<w.getNumNames(); i++) {
          NameRecord r = w.getNameRecord(i);
          assertTrue(r.getIndexToSheet() <= wb.getNumberOfSheets());
          
          List nd = r.getNameDefinition();
          assertEquals(1, nd.size());
          assertTrue(nd.get(0) instanceof DeletedArea3DPtg);
        }
        
        
        // Save and re-load
        wb = writeOutAndReadBack(wb);
        w = wb.getWorkbook();
        
        assertEquals(1, wb.getNumberOfNames());
        assertEquals(2, wb.getNumberOfSheets());
        
        for(int i=0; i<w.getNumNames(); i++) {
          NameRecord r = w.getNameRecord(i);
          assertTrue(r.getIndexToSheet() <= wb.getNumberOfSheets());
          
          List nd = r.getNameDefinition();
          assertEquals(1, nd.size());
          assertTrue(nd.get(0) instanceof DeletedArea3DPtg);
        }
    }

View Full Code Here

    }
    
    _definedNames = new ArrayList();
    // collect zero or more DEFINEDNAMEs id=0x18
    while(rs.peekNextClass() == NameRecord.class) {
      NameRecord nr = (NameRecord)rs.getNext();
      _definedNames.add(nr);
    }


    _recordCount = rs.getCountRead();
    _workbookRecordList.getRecords().addAll(inputList.subList(startIndex, startIndex + _recordCount));

View Full Code Here


  public NameRecord getSpecificBuiltinRecord(byte name, int sheetIndex) {


    Iterator iterator = _definedNames.iterator();
    while (iterator.hasNext()) {
      NameRecord record = ( NameRecord ) iterator.next();


      //print areas are one based
      if (record.getBuiltInName() == name && record.getIndexToSheet() == sheetIndex) {
        return record;
      }
    }


    return null;

View Full Code Here

  }


  public void removeBuiltinRecord(byte name, int sheetIndex) {
    //the name array is smaller so searching through it should be faster than
    //using the findFirstXXXX methods
    NameRecord record = getSpecificBuiltinRecord(name, sheetIndex);
    if (record != null) {
      _definedNames.remove(record);
    }
    // TODO - do we need "Workbook.records.remove(...);" similar to that in Workbook.removeName(int namenum) {}?
  }

View Full Code Here

        Workbook wb = book.getWorkbook();
        
        //Check to ensure no other names have the same case-insensitive name
        for ( int i = wb.getNumNames()-1; i >=0; i-- )
        {
          NameRecord rec = wb.getNameRecord(i);
          if (rec != name) {
            if (rec.getNameText().equalsIgnoreCase(getNameName()))
              throw new IllegalArgumentException("The workbook already contains this name (case-insensitive)");
          }
        }
    }

View Full Code Here

                startColumn != -1 && endColumn != -1 && startRow != -1 && endRow != -1;
        boolean removingRange =
                startColumn == -1 && endColumn == -1 && startRow == -1 && endRow == -1;


        boolean isNewRecord = false;
        NameRecord nameRecord;
        nameRecord = findExistingRowColHeaderNameRecord(sheetIndex);
        if (removingRange )
        {
            if (nameRecord != null)
                workbook.removeName(findExistingRowColHeaderNameRecordIdx(sheetIndex));
            return;
        }
        if ( nameRecord == null )
        {
            nameRecord = workbook.createBuiltInName(NameRecord.BUILTIN_PRINT_TITLE, externSheetIndex+1);
            //does a lot of the house keeping for builtin records, like setting lengths to zero etc
            isNewRecord = true;
        }
        
        short definitionTextLength = settingRowAndColumn ? (short)0x001a : (short)0x000b;
        nameRecord.setDefinitionTextLength(definitionTextLength);


        Stack ptgs = new Stack();


        if (settingRowAndColumn)
        {
            MemFuncPtg memFuncPtg = new MemFuncPtg();
            memFuncPtg.setLenRefSubexpression(23);
            ptgs.add(memFuncPtg);
        }
        if (startColumn >= 0)
        {
            Area3DPtg area3DPtg1 = new Area3DPtg();
            area3DPtg1.setExternSheetIndex(externSheetIndex);
            area3DPtg1.setFirstColumn((short)startColumn);
            area3DPtg1.setLastColumn((short)endColumn);
            area3DPtg1.setFirstRow((short)0);
            area3DPtg1.setLastRow((short)0xFFFF);
            ptgs.add(area3DPtg1);
        }
        if (startRow >= 0)
        {
            Area3DPtg area3DPtg2 = new Area3DPtg();
            area3DPtg2.setExternSheetIndex(externSheetIndex);
            area3DPtg2.setFirstColumn((short)0);
            area3DPtg2.setLastColumn((short)0x00FF);
            area3DPtg2.setFirstRow((short)startRow);
            area3DPtg2.setLastRow((short)endRow);
            ptgs.add(area3DPtg2);
        }
        if (settingRowAndColumn)
        {
            UnionPtg unionPtg = new UnionPtg();
            ptgs.add(unionPtg);
        }
        nameRecord.setNameDefinition(ptgs);


        if (isNewRecord)
        {
            HSSFName newName = new HSSFName(workbook, nameRecord);
            names.add(newName);

View Full Code Here

    }


    private int findExistingRowColHeaderNameRecordIdx( int sheetIndex )
    {
        int index = 0;
        NameRecord r = null;
        while ((r = (NameRecord) workbook.findNextRecordBySid(NameRecord.sid, index)) != null)
        {
            int nameRecordSheetIndex = workbook.getSheetIndexFromExternSheetIndex(r.getEqualsToIndexToSheet() - 1);
            if (isRowColHeaderRecord( r ) && nameRecordSheetIndex == sheetIndex)
            {
                return index;
            }
            index++;

View Full Code Here

   * @param sheetIndex Zero-based sheet index (0 Represents the first sheet to keep consistent with java)
   * @param reference Valid name Reference for the Print Area 
   */
  public void setPrintArea(int sheetIndex, String reference)
  {
    NameRecord name = workbook.getSpecificBuiltinRecord(NameRecord.BUILTIN_PRINT_AREA, sheetIndex+1);
    


    if (name == null)
      name = workbook.createBuiltInName(NameRecord.BUILTIN_PRINT_AREA, sheetIndex+1);
       //adding one here because 0 indicates a global named region; doesnt make sense for print areas
       
      short externSheetIndex = getWorkbook().checkExternSheet(sheetIndex);
    name.setExternSheetNumber(externSheetIndex);       
    name.setAreaReference(reference);
       
    
  }

View Full Code Here

   * @param sheetIndex Zero-based sheet index (0 Represents the first sheet to keep consistent with java) 
   * @return String Null if no print area has been defined
   */      
  public String getPrintArea(int sheetIndex)
  {
    NameRecord name = workbook.getSpecificBuiltinRecord(NameRecord.BUILTIN_PRINT_AREA, sheetIndex+1);    
    if (name == null) return null;
    //adding one here because 0 indicates a global named region; doesnt make sense for print areas
   
    return name.getAreaReference(workbook);
  }

View Full Code Here

    
    /** creates a new named range and add it to the model
     * @return named range high level
     */    
    public HSSFName createName(){
        NameRecord nameRecord = workbook.createName();
        
        HSSFName newName = new HSSFName(workbook, nameRecord);
        
        names.add(newName);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.poi.hssf.record.NameRecord$Option

com.digitalpebble.behemoth.mahout.SparseVectorsFromBehemoth

com.digitalpebble.behemoth.tika.TikaDriver

org.apache.commons.cli.CLI2Converter

org.apache.commons.cli2.commandline.PreferencesCommandLine

org.apache.commons.cli2.commandline.PropertiesCommandLine

org.apache.commons.cli2.option.GroupImpl

org.apache.hadoop.streaming.StreamJob

org.apache.jackrabbit.vault.util.console.Test

org.apache.jackrabbit.vault.util.console.util.CliHelpFormatter

org.apache.mahout.benchmark.VectorBenchmarks

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.