Examples of HSSFSeries

Examples of org.apache.poi.hssf.usermodel.HSSFChart.HSSFSeries

159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
        HSSFSheet sheet = wb.getSheetAt( 1 ) ;
        HSSFChart[] charts = HSSFChart.getSheetCharts( sheet ) ;
       
        assertEquals(1, charts.length);
        for ( HSSFChart chart : charts ) {
            HSSFSeries series ;
           
            // Starts with one
            assertEquals(1, chart.getSeries().length);

            // Add two more
            series = chart.createSeries() ;
            series.setCategoryLabelsCellRange( new CellRangeAddress( 3, 4, 0, 0 ) ) ;
            series.setValuesCellRange( new CellRangeAddress( 3, 4, 1, 1 ) ) ;

            series = chart.createSeries() ;
            series.setCategoryLabelsCellRange( new CellRangeAddress( 6, 7, 0, 0 ) ) ;
            series.setValuesCellRange( new CellRangeAddress( 6, 7, 1, 1 ) ) ;
        }
       
        // Save and re-check
        wb = HSSFITestDataProvider.instance.writeOutAndReadBack(wb);
        sheet = wb.getSheetAt( 1 ) ;
View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFChart.HSSFSeries

210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
                series.setCategoryLabelsCellRange( range ) ;
            }

            for ( int id = 0 ; id < 2 ; id++ )
            {
                HSSFSeries newSeries = chart.createSeries() ;
                newSeries.setValuesCellRange( new CellRangeAddress( 1 + id, 4, 3, 3 ) ) ;
                String oldSeriesTitle = newSeries.getSeriesTitle() ;
                if ( oldSeriesTitle != null )
                {
                    //System.out.println( "old series title: " + oldSeriesTitle ) ;
                    newSeries.setSeriesTitle( "new series" ) ;
                }
            }
        }

        HSSFChart chart = charts[ 2 ] ;
View Full Code Here

Examples of org.zkoss.poi.hssf.usermodel.HSSFChart.HSSFSeries

77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
    HSSFChart chart = (HSSFChart) chartXes.get(0).getChartInfo();
    assertEquals("2003-2006 Income Summary", chart.getChartTitle());
    HSSFSeries[] series = chart.getSeries();
    assertEquals(3, series.length);
   
    HSSFSeries ser = series[0];
    assertEquals(4, ser.getNumValues());
    assertEquals("Total Revenues", ser.getSeriesTitle());

    ser = series[1];
    assertEquals(4, ser.getNumValues());
    assertEquals("Total Expenses", ser.getSeriesTitle());
   
    ser = series[2];
    assertEquals(4, ser.getNumValues());
    assertEquals("Profit/Loss", ser.getSeriesTitle());
   
    for(int j = 0; j < series.length; ++j) {
      System.out.println("--------"+j);
      System.out.println("ser.getValueType():"+ser.getValueType());
      System.out.println("ser.getDataCategoryLabels():"+ser.getDataCategoryLabels());
      System.out.println("ser.getDataName():"+ser.getDataName());
      System.out.println("ser.getDataSecondaryCategoryLabels():"+ser.getDataSecondaryCategoryLabels());
      System.out.println("ser.getDataValues():"+ser.getDataValues());
      System.out.println("ser.getSeries():"+ser.getSeries());
    }
  }
View Full Code Here

Examples of org.zkoss.poi.hssf.usermodel.HSSFChart.HSSFSeries

77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
    assertNull(chart.getChartTitle());
    System.out.println("getgetChartWidth():"+chart.getChartWidth());
    HSSFSeries[] series = chart.getSeries();
    assertEquals(1, series.length);
    for(int j = 0; j < series.length; ++j) {
      HSSFSeries ser = series[j];
      assertEquals(3, ser.getNumValues());
      assertEquals("2003", ser.getSeriesTitle());
      assertEquals(1, ser.getValueType());
      System.out.println("ser.getDataCategoryLabels():"+ser.getDataCategoryLabels());
      System.out.println("ser.getDataName():"+ser.getDataName());
      System.out.println("ser.getDataSecondaryCategoryLabels():"+ser.getDataSecondaryCategoryLabels());
      System.out.println("ser.getDataValues():"+ser.getDataValues());
      System.out.println("ser.getSeries():"+ser.getSeries());
    }

  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.