Package org.apache.poi.hssf.model

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

75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
     */   

    public void setNameName(String nameName){
        name.setNameText(nameName);
        name.setNameTextLength((byte)nameName.length());
        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
607
608
609
610
611
612
613
614
615
616
617
618
    public void testBackupRecord()
        throws Exception
    {
        HSSFWorkbook wb       = new HSSFWorkbook();
        wb.createSheet();
        Workbook     workbook = wb.getWorkbook();
        BackupRecord record   = workbook.getBackupRecord();

        assertEquals(0, record.getBackup());
        wb.setBackupFlag(true);
        assertEquals(1, record.getBackup());
    }
View Full Code Here
324
325
326
327
328
329
330
331
332
333
334
335
            }
            else if (ptgs[i] instanceof Ref3DPtg) {
                Ref3DPtg ptg = (Ref3DPtg) ptgs[i];
                short colnum = ptg.getColumn();
                short rownum = ptg.getRow();
                Workbook wb = workbook.getWorkbook();
                HSSFSheet xsheet = workbook.getSheetAt(wb.getSheetIndexFromExternSheetIndex(ptg.getExternSheetIndex()));
                HSSFRow row = xsheet.getRow(rownum);
                HSSFCell cell = (row != null) ? row.getCell(colnum) : null;
                pushRef3DEval(ptg, stack, cell, row, xsheet, workbook);
            }
            else if (ptgs[i] instanceof AreaPtg) {
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
     */   

    public void setNameName(String nameName){
        name.setNameText(nameName);
        name.setNameTextLength((byte)nameName.length());
        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
481
482
483
484
485
486
487
488
489
490
491
492
    public void testBackupRecord()
        throws Exception
    {
        HSSFWorkbook wb       = new HSSFWorkbook();
        wb.createSheet();
        Workbook     workbook = wb.getWorkbook();
        BackupRecord record   = workbook.getBackupRecord();

        assertEquals(0, record.getBackup());
        wb.setBackupFlag(true);
        assertEquals(1, record.getBackup());
    }
View Full Code Here
313
314
315
316
317
318
319
320
321
322
323
     */
    public void testOnARealFile() throws Exception {

        HSSFWorkbook workbook = HSSFTestDataSamples.openSampleWorkbook("DateFormats.xls");
        HSSFSheet sheet       = workbook.getSheetAt(0);
        Workbook wb           = workbook.getWorkbook();
       
        HSSFRow  row;
        HSSFCell cell;
        HSSFCellStyle style;
       
View Full Code Here
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
        assertEquals(1, wb.getNumberOfNames());
        assertEquals(3, wb.getNumberOfSheets());
       
        // 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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
    FormulaRecord fr;
   
    // Check our formula records
    assertEquals(6, mockListen._frecs.size());
   
    Workbook stubWB = listener.getStubWorkbook();
    assertNotNull(stubWB);
    HSSFWorkbook stubHSSF = listener.getStubHSSFWorkbook();
    assertNotNull(stubHSSF);
   
    // Check these stubs have the right stuff on them
    assertEquals("Sheet1", stubWB.getSheetName(0));
    assertEquals("S2", stubWB.getSheetName(1));
    assertEquals("Sh3", stubWB.getSheetName(2));
   
    // Check we can get the formula without breaking
    for(int i=0; i<mockListen._frecs.size(); i++) {
      fr = (FormulaRecord)mockListen._frecs.get(i);
      FormulaParser.toFormulaString(stubHSSF, fr.getParsedExpression());
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
     * sets the name of the named range
     * @param nameName named range name to set
     */
    public void setNameName(String nameName){
        _definedNameRec.setNameText(nameName);
        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 != _definedNameRec) {
                if (rec.getNameText().equalsIgnoreCase(getNameName()))
                    throw new IllegalArgumentException("The workbook already contains this name (case-insensitive)");
            }
        }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
    assertEquals(3, listener.getBoundSheetRecords().length);
    assertEquals(1, listener.getExternSheetRecords().length);
   
    assertEquals(3, listener.getStubWorkbook().getNumSheets());
   
    Workbook ref = listener.getStubWorkbook();
    assertEquals("Sh3", ref.findSheetNameFromExternSheet(0));
    assertEquals("Sheet1", ref.findSheetNameFromExternSheet(1));
    assertEquals("S2", ref.findSheetNameFromExternSheet(2));
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.model.Workbook

  • org.apache.poi.ddf.EscherBoolProperty
  • org.apache.poi.ddf.EscherContainerRecord
  • org.apache.poi.ddf.EscherDggRecord
  • org.apache.poi.ddf.EscherDgRecord
  • org.apache.poi.ddf.EscherOptRecord
  • org.apache.poi.ddf.EscherRecord
  • org.apache.poi.ddf.EscherRGBProperty
  • org.apache.poi.ddf.EscherSplitMenuColorsRecord
  • org.apache.poi.ddf.EscherSpRecord
  • org.apache.poi.hssf.eventmodel.ModelFactory
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.