Package org.apache.poi.ss.util

Examples of org.apache.poi.ss.util.SheetBuilder

43
44
45
46
47
48
49
50
51
52
53
            {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}
    };

    public void testOneSeriePlot() throws Exception {
        Workbook wb = new XSSFWorkbook();
        Sheet sheet = new SheetBuilder(wb, plotData).build();
        Drawing drawing = sheet.createDrawingPatriarch();
        ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 1, 1, 10, 30);
        Chart chart = drawing.createChart(anchor);

        ChartAxis bottomAxis = chart.getChartAxisFactory().createCategoryAxis(AxisPosition.BOTTOM);
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
        assertDataSourceIsEqualToArray(stringDataSource, strings);
    }

    public void testNumericCellDataSource() {
        Workbook wb = new HSSFWorkbook();
        Sheet sheet = new SheetBuilder(wb, numericCells).build();
        CellRangeAddress numCellRange = CellRangeAddress.valueOf("A2:E2");
        ChartDataSource<Number> numDataSource = DataSources.fromNumericCellRange(sheet, numCellRange);
        assertTrue(numDataSource.isReference());
        assertTrue(numDataSource.isNumeric());
        assertEquals(numericCells[0].length, numDataSource.getPointCount());
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
        }
    }

    public void testStringCellDataSource() {
        Workbook wb = new HSSFWorkbook();
        Sheet sheet = new SheetBuilder(wb, stringCells).build();
        CellRangeAddress numCellRange = CellRangeAddress.valueOf("A2:E2");
        ChartDataSource<String> numDataSource = DataSources.fromStringCellRange(sheet, numCellRange);
        assertTrue(numDataSource.isReference());
        assertFalse(numDataSource.isNumeric());
        assertEquals(numericCells[0].length, numDataSource.getPointCount());
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
        }
    }

    public void testMixedCellDataSource() {
        Workbook wb = new HSSFWorkbook();
        Sheet sheet = new SheetBuilder(wb, mixedCells).build();
        CellRangeAddress mixedCellRange = CellRangeAddress.valueOf("A1:F1");
        ChartDataSource<String> strDataSource = DataSources.fromStringCellRange(sheet, mixedCellRange);
        ChartDataSource<Number> numDataSource = DataSources.fromNumericCellRange(sheet, mixedCellRange);
        for (int i = 0; i < mixedCells[0].length; ++i) {
            if (i % 2 == 0) {
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
        }
    }

    public void testIOBExceptionOnInvalidIndex() {
        Workbook wb = new HSSFWorkbook();
        Sheet sheet = new SheetBuilder(wb, numericCells).build();
        CellRangeAddress rangeAddress = CellRangeAddress.valueOf("A2:E2");
        ChartDataSource<Number> numDataSource = DataSources.fromNumericCellRange(sheet, rangeAddress);
        IndexOutOfBoundsException exception = null;
        try {
            numDataSource.getPointAt(-1);
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
            {  1,    2,   3,    4,    5,   6,    7,   8,    9,  10}
    };

    public void testOneSeriePlot() throws Exception {
        Workbook wb = new XSSFWorkbook();
        Sheet sheet = new SheetBuilder(wb, plotData).build();
        Drawing drawing = sheet.createDrawingPatriarch();
        ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 1, 1, 10, 30);
        Chart chart = drawing.createChart(anchor);

        ChartAxis bottomAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM);
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
            {  1,    2,   3,    4,    5,   6,    7,   8,    9,  10}
    };

    public void testOneSeriePlot() throws Exception {
        Workbook wb = new XSSFWorkbook();
        Sheet sheet = new SheetBuilder(wb, plotData).build();
        Drawing drawing = sheet.createDrawingPatriarch();
        ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 1, 1, 10, 30);
        Chart chart = drawing.createChart(anchor);

        ChartAxis bottomAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM);
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
            {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}
    };

    public void testOneSeriePlot() throws Exception {
        Workbook wb = new XSSFWorkbook();
        Sheet sheet = new SheetBuilder(wb, plotData).build();
        Drawing drawing = sheet.createDrawingPatriarch();
        ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 1, 1, 10, 30);
        Chart chart = drawing.createChart(anchor);

        ChartAxis bottomAxis = chart.getChartAxisFactory().createCategoryAxis(AxisPosition.BOTTOM);
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
    private CountCellHandler countCellHandler = new CountCellHandler();

    public void testNotTraverseEmptyCells() {
  Workbook wb = new HSSFWorkbook();
  Sheet sheet = new SheetBuilder(wb, testData).build();
  CellRangeAddress range = CellRangeAddress.valueOf("A1:C3");
 
  CellWalk cellWalk = new CellWalk(sheet, range);
  countCellHandler.reset();
  cellWalk.traverse(countCellHandler);
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
  {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}
    };
   
    public void testOneSeriePlot() throws Exception {
  Workbook wb = new XSSFWorkbook();
  Sheet sheet = new SheetBuilder(wb, plotData).build();
  Drawing drawing = sheet.createDrawingPatriarch();
  ClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 1, 1, 10, 30);
  Chart chart = drawing.createChart(anchor);

  ChartAxis bottomAxis = chart.getChartAxisFactory().createValueAxis(AxisPosition.BOTTOM);
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.util.SheetBuilder

  • org.apache.poi.ss.usermodel.Cell
  • org.apache.poi.ss.usermodel.charts.TestDataSources
  • org.apache.poi.ss.usermodel.Row
  • org.apache.poi.ss.usermodel.Sheet
  • org.apache.poi.ss.util.cellwalk.TestCellWalk
  • org.apache.poi.xssf.usermodel.charts.TestXSSFLineChartData
  • org.apache.poi.xssf.usermodel.charts.TestXSSFNumberCache
  • org.apache.poi.xssf.usermodel.charts.TestXSSFScatterChartData
    • 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.