How to create pivot charts in Java

package testexceljava;

import EasyXLS.*;
import EasyXLS.Constants.*;
import EasyXLS.PivotTables.*;

/* -----------------------------------------------------------
 | Tutorial 26
 |
 | This tutorial shows how to create an Excel file in Java and
 | to create a pivot chart. The pivot chart is added to a
 | workshet and also to a separate chart sheet.
 * ----------------------------------------------------------- */

public class Tutorial26 {

    public static void main(String[] args) {
        try {
            System.out.println("Tutorial 26");
            System.out.println("----------");

            // Create an instance of the class that exports Excel files, having two sheets
            ExcelDocument workbook = new ExcelDocument(2, 1);

            // Set the sheet names
            workbook.easy_getSheetAt(0).setSheetName("First tab");
            workbook.easy_getSheetAt(1).setSheetName("Second tab");
            workbook.easy_getSheetAt(2).setSheetName("Pivot chart");

            // Get the table of data for the first worksheet
            ExcelTable xlsFirstTable = ((ExcelWorksheet)workbook.easy_getSheetAt(0)).easy_getExcelTable();

            // Add data in cells for report header
            xlsFirstTable.easy_getCell(0,0).setValue("Sale agent");
            xlsFirstTable.easy_getCell(0,0).setDataType(DataType.STRING);
            xlsFirstTable.easy_getCell(0,1).setValue("Sale country");
            xlsFirstTable.easy_getCell(0,1).setDataType(DataType.STRING);
            xlsFirstTable.easy_getCell(0,2).setValue("Month");
            xlsFirstTable.easy_getCell(0,2).setDataType(DataType.STRING);
            xlsFirstTable.easy_getCell(0,3).setValue("Year");
            xlsFirstTable.easy_getCell(0,3).setDataType(DataType.STRING);
            xlsFirstTable.easy_getCell(0,4).setValue("Sale amount");
            xlsFirstTable.easy_getCell(0,4).setDataType(DataType.STRING);

            xlsFirstTable.easy_getRowAt(0).setBold(true);

            // Add data in cells for report values - the source for pivot chart
            xlsFirstTable.easy_getCell(1,0).setValue("John Down");
            xlsFirstTable.easy_getCell(1,1).setValue("USA");
            xlsFirstTable.easy_getCell(1,2).setValue("June");
            xlsFirstTable.easy_getCell(1,3).setValue("2010");
            xlsFirstTable.easy_getCell(1,4).setValue("550");

            xlsFirstTable.easy_getCell(2,0).setValue("Scott Valey"); 
            xlsFirstTable.easy_getCell(2,1).setValue("United Kingdom"); 
            xlsFirstTable.easy_getCell(2,2).setValue("June"); 
            xlsFirstTable.easy_getCell(2,3).setValue("2010"); 
            xlsFirstTable.easy_getCell(2,4).setValue("2300"); 

            xlsFirstTable.easy_getCell(3,0).setValue("John Down");
            xlsFirstTable.easy_getCell(3,1).setValue("USA");
            xlsFirstTable.easy_getCell(3,2).setValue("July");
            xlsFirstTable.easy_getCell(3,3).setValue("2010");
            xlsFirstTable.easy_getCell(3,4).setValue("3100");

            xlsFirstTable.easy_getCell(4,0).setValue("John Down");
            xlsFirstTable.easy_getCell(4,1).setValue("USA");
            xlsFirstTable.easy_getCell(4,2).setValue("June");
            xlsFirstTable.easy_getCell(4,3).setValue("2011");
            xlsFirstTable.easy_getCell(4,4).setValue("1050");

            xlsFirstTable.easy_getCell(5,0).setValue("John Down");
            xlsFirstTable.easy_getCell(5,1).setValue("USA");
            xlsFirstTable.easy_getCell(5,2).setValue("July");
            xlsFirstTable.easy_getCell(5,3).setValue("2011");
            xlsFirstTable.easy_getCell(5,4).setValue("2400");

            xlsFirstTable.easy_getCell(6,0).setValue("Steve Marlowe");
            xlsFirstTable.easy_getCell(6,1).setValue("France");
            xlsFirstTable.easy_getCell(6,2).setValue("June");
            xlsFirstTable.easy_getCell(6,3).setValue("2011");
            xlsFirstTable.easy_getCell(6,4).setValue("1200");

            xlsFirstTable.easy_getCell(7,0).setValue("Scott Valey");
            xlsFirstTable.easy_getCell(7,1).setValue("United Kingdom");
            xlsFirstTable.easy_getCell(7,2).setValue("June");
            xlsFirstTable.easy_getCell(7,3).setValue("2011");
            xlsFirstTable.easy_getCell(7,4).setValue("700");

            xlsFirstTable.easy_getCell(8,0).setValue("Scott Valey");
            xlsFirstTable.easy_getCell(8,1).setValue("United Kingdom");
            xlsFirstTable.easy_getCell(8,2).setValue("July");
            xlsFirstTable.easy_getCell(8,3).setValue("2011");
            xlsFirstTable.easy_getCell(8,4).setValue("360");

            // Create pivot table
            ExcelPivotTable xlsPivotTable = new ExcelPivotTable();

            xlsPivotTable.setName("Sales");
            xlsPivotTable.setSourceRange("First tab!$A$1:$E$9", workbook);
            xlsPivotTable.setLocation("A3:G15");
            xlsPivotTable.addFieldToRowLabels("Sale agent");
            xlsPivotTable.addFieldToColumnLabels("Year");
            xlsPivotTable.addFieldToValues("Sale amount" ,"Sale amount per year", PivotTable.SUBTOTAL_SUM);
            xlsPivotTable.addFieldToReportFilter("Sale country");
            xlsPivotTable.setOutlineForm();
            xlsPivotTable.setStyle(PivotTable.PIVOT_STYLE_MEDIUM_9);

            // Add the pivot table to the second sheet
            ((ExcelWorksheet)workbook.easy_getSheet("Second tab")).easy_addPivotTable(xlsPivotTable);

            // Create pivot chart
            ExcelPivotChart xlsPivotChart1 = new ExcelPivotChart();
            xlsPivotChart1.setSize(600, 300);
            xlsPivotChart1.setLeftUpperCorner("A10");
            xlsPivotChart1.easy_setChartType(Chart.CHART_TYPE_PYRAMID_BAR);
            xlsPivotChart1.getChartTitle().setText("Sales");
            xlsPivotChart1.setPivotTable(xlsPivotTable); 

            // Add the pivot chart to the second sheet
            ((ExcelWorksheet)workbook.easy_getSheet("Second tab")).easy_addPivotChart(xlsPivotChart1);

            // Create a clone of the pivot chart and add the clone to the chart sheet
            ExcelPivotChart xlsPivotChart2 = (ExcelPivotChart)xlsPivotChart1.Clone();
            xlsPivotChart2.setSize(970, 630);
            ((ExcelChartSheet)workbook.easy_getSheet("Pivot chart")).easy_setExcelChart(xlsPivotChart2);

            // Export Excel file
            System.out.println("Writing file: C:\\Samples\\Tutorial26 - pivot chart in Excel.xlsx");
            workbook.easy_WriteXLSXFile("C:\\Samples\\Tutorial26 - pivot chart in Excel.xlsx");

            // Confirm export of Excel file
            if (workbook.easy_getError().equals(""))
                System.out.println("File successfully created.");
            else
                System.out.println("Error encountered: " + workbook.easy_getError());

            // Dispose memory
            workbook.Dispose();
        }
        catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}