//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Adding a new worksheet to the Excel object
int sheetIndex = workbook.getWorksheets().add();
//Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
//Adding a sample value to "A1" cell
worksheet.getCells().get("A1").putValue(50);
//Adding a sample value to "A2" cell
worksheet.getCells().get("A2").putValue(100);
//Adding a sample value to "A3" cell
worksheet.getCells().get("A3").putValue(150);
//Adding a sample value to "A4" cell
worksheet.getCells().get("A4").putValue(200);
//Adding a sample value to "B1" cell
worksheet.getCells().get("B1").putValue(60);
//Adding a sample value to "B2" cell
worksheet.getCells().get("B2").putValue(32);
//Adding a sample value to "B3" cell
worksheet.getCells().get("B3").putValue(50);
//Adding a sample value to "B4" cell
worksheet.getCells().get("B4").putValue(40);
//Adding a sample value to "C1" cell as category data
worksheet.getCells().get("C1").putValue("Q1");
//Adding a sample value to "C2" cell as category data
worksheet.getCells().get("C2").putValue("Q2");
//Adding a sample value to "C3" cell as category data
worksheet.getCells().get("C3").putValue("Y1");
//Adding a sample value to "C4" cell as category data
worksheet.getCells().get("C4").putValue("Y2");
//Adding a chart to the worksheet
int chartIndex = worksheet.getCharts().add(ChartType.COLUMN, 5, 0, 15, 5);
//Accessing the instance of the newly added chart
Chart chart = worksheet.getCharts().get(chartIndex);
//Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B4"
chart.getNSeries().add("A1:B4", true);
//Setting the data source for the category data of NSeries
chart.getNSeries().setCategoryData("C1:C4");
//adding a linear trendline
int index = chart.getNSeries().get(0).getTrendLines().add(TrendlineType.LINEAR);
Trendline trendline = chart.getNSeries().get(0).getTrendLines().get(index);
//Setting the custom name of the trendline.
trendline.setName("Linear");
//Displaying the equation on chart
trendline.setDisplayEquation(true);
//Displaying the R-Squared value on chart
trendline.setDisplayRSquared(true);
//Saving the Excel file
workbook.save("C:\\book1.xls");
Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward.
The number of periods must be greater than and equal to zero.
If the chart type is column ,the number of periods must be between 0 and 0.5
Represents if the equation for the trendline is displayed on the chart (in the same data label as the R-squared value). Setting this property to True automatically turns on data labels.
Represents if the R-squared value of the trendline is displayed on the chart (in the same data label as the equation). Setting this property to True automatically turns on data labels.
Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward.
The number of periods must be greater than and equal to zero.
Sets whether Microsoft Workbook automatically determines the intercept of the trendline.
Property Getters/Setters Detail
isNameAuto/setNameAuto
public boolean isNameAuto() / public void setNameAuto(boolean value)
Returns if Microsoft Excel automatically determines the name of the trendline.
getType
public int getType()
Returns the trendline type.
The value of the property is TrendlineType integer constant.
getName/setName
public java.lang.String getName() / public void setName(java.lang.String value)
Returns the name of the trendline.
getOrder/setOrder
public int getOrder() / public void setOrder(int value)
Returns or sets the trendline order (an integer greater than 1) when the trendline type is Polynomial.
The order must be between 2 and 6.
getPeriod/setPeriod
public int getPeriod() / public void setPeriod(int value)
Returns or sets the period for the moving-average trendline.
This value should be between 2 and 255.
And it must be less than the number of the chart points in the series
getForward/setForward
public double getForward() / public void setForward(double value)
Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward.
The number of periods must be greater than and equal to zero.
getBackward/setBackward
public double getBackward() / public void setBackward(double value)
Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward.
The number of periods must be greater than and equal to zero.
If the chart type is column ,the number of periods must be between 0 and 0.5
getDisplayEquation/setDisplayEquation
public boolean getDisplayEquation() / public void setDisplayEquation(boolean value)
Represents if the equation for the trendline is displayed on the chart (in the same data label as the R-squared value). Setting this property to True automatically turns on data labels.
getDisplayRSquared/setDisplayRSquared
public boolean getDisplayRSquared() / public void setDisplayRSquared(boolean value)
Represents if the R-squared value of the trendline is displayed on the chart (in the same data label as the equation). Setting this property to True automatically turns on data labels.
getIntercept/setIntercept
public double getIntercept() / public void setIntercept(double value)
Returns or sets the point where the trendline crosses the value axis.
Line