Package org.apache.poi.hssf.model

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

211
212
213
214
215
216
217
218
219
220
221
222
223
       
        // 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
81
82
83
84
85
86
87
88
89
90
91
              switch (bof.getType()) {
               case BOFRecord.TYPE_WORKBOOK:
                 currentmodel = new Workbook();                
               break;
               case BOFRecord.TYPE_WORKSHEET:
                 currentmodel = new Sheet();                                 
               break;
              default:
                   throw new RuntimeException("Unsupported model type "+bof.getType());
              }               
              
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
    public void testBackupRecord()
            throws Exception
    {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet s = wb.createSheet();
        Sheet sheet = s.getSheet();

        assertEquals(true, sheet.getGridsetRecord().getGridset());
        s.setGridsPrinted(true);
        assertEquals(false, sheet.getGridsetRecord().getGridset());
    }
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
118
    public void testVerticallyCenter()
            throws Exception
    {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet s = wb.createSheet();
        Sheet sheet = s.getSheet();
        VCenterRecord record =
                (VCenterRecord) sheet.findFirstRecordBySid(VCenterRecord.sid);

        assertEquals(false, record.getVCenter());
        s.setVerticallyCenter(true);
        assertEquals(true, record.getVCenter());
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
137
138
    public void testHorizontallyCenter()
            throws Exception
    {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet s = wb.createSheet();
        Sheet sheet = s.getSheet();
        HCenterRecord record =
                (HCenterRecord) sheet.findFirstRecordBySid(HCenterRecord.sid);

        assertEquals(false, record.getHCenter());
        s.setHorizontallyCenter(true);
        assertEquals(true, record.getHCenter());
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
156
157
    public void testWSBool()
    {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet s = wb.createSheet();
        Sheet sheet = s.getSheet();
        WSBoolRecord record =
                (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid);

        // Check defaults
        assertEquals(true, record.getAlternateExpression());
        assertEquals(true, record.getAlternateFormula());
        assertEquals(false, record.getAutobreaks());
View Full Code Here
252
253
254
255
256
257
258
259
260
261
262
263
264
        // 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
54
55
56
57
58
59
60
61
62
63
64
   * Test the gridset field gets set as expected.
   */
  public void testBackupRecord() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet s = wb.createSheet();
    Sheet sheet = s.getSheet();

    assertEquals(true, sheet.getGridsetRecord().getGridset());
    s.setGridsPrinted(true);
    assertEquals(false, sheet.getGridsetRecord().getGridset());
  }
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
78
79
   * Test vertically centered output.
   */
  public void testVerticallyCenter() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet s = wb.createSheet();
    Sheet sheet = s.getSheet();
    VCenterRecord record =
        (VCenterRecord) sheet.findFirstRecordBySid(VCenterRecord.sid);

    assertEquals(false, record.getVCenter());
    s.setVerticallyCenter(true);
    assertEquals(true, record.getVCenter());

View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
96
   * Test horizontally centered output.
   */
  public void testHorizontallyCenter() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet s = wb.createSheet();
    Sheet sheet = s.getSheet();
    HCenterRecord record =
        (HCenterRecord) sheet.findFirstRecordBySid(HCenterRecord.sid);

    assertEquals(false, record.getHCenter());
    s.setHorizontallyCenter(true);
    assertEquals(true, record.getHCenter());
  }
View Full Code Here
TOP

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

  • org.apache.poi.hssf.eventmodel.ModelFactory
  • org.apache.poi.hssf.record.aggregates.CFRecordsAggregate
  • org.apache.poi.hssf.record.aggregates.ChartSubstreamRecordAggregate
  • org.apache.poi.hssf.record.aggregates.ColumnInfoRecordsAggregate
  • org.apache.poi.hssf.record.aggregates.ConditionalFormattingTable
  • org.apache.poi.hssf.record.aggregates.CustomViewSettingsRecordAggregate
  • org.apache.poi.hssf.record.aggregates.DataValidityTable
  • org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate
  • org.apache.poi.hssf.record.aggregates.MergedCellsTable
  • org.apache.poi.hssf.record.aggregates.PageSettingsBlock
    • 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.