java numbertickunit_使用poi和jfreechart生成excel图表图片

package test;

import java.awt.BasicStroke;

import java.awt.Color;

import java.awt.Font;

import java.awt.image.BufferedImage;

import java.io.ByteArrayOutputStream;

import java.io.File;

import java.io.FileOutputStream;

import java.io.IOException;

import java.util.ArrayList;

import java.util.List;

import javax.imageio.ImageIO;

import org.apache.poi.hssf.usermodel.HSSFClientAnchor;

import org.apache.poi.hssf.usermodel.HSSFPatriarch;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.jfree.chart.ChartColor;

import org.jfree.chart.ChartFactory;

import org.jfree.chart.ChartUtilities;

import org.jfree.chart.JFreeChart;

import org.jfree.chart.axis.CategoryAxis;

import org.jfree.chart.axis.CategoryLabelPositions;

import org.jfree.chart.axis.NumberAxis;

import org.jfree.chart.axis.NumberTickUnit;

import org.jfree.chart.axis.ValueAxis;

import org.jfree.chart.plot.CategoryPlot;

import org.jfree.chart.plot.PlotOrientation;

import org.jfree.chart.renderer.category.LineAndShapeRenderer;

import org.jfree.chart.title.LegendTitle;

import org.jfree.chart.title.TextTitle;

import org.jfree.data.category.DefaultCategoryDataset;

import org.jfree.ui.RectangleEdge;

/**

* 结合poi和jfreechart创建图表图片

*

* @author tuzongxun

* @date 2016年9月19日 上午10:55:09

*/

public class ExcelDemo2 {

public static void main(String[] args) throws Exception {

// excel2003工作表

HSSFWorkbook wb = new HSSFWorkbook();

HSSFSheet sheet = wb.createSheet("Sheet 1");

ByteArrayOutputStream byteArrayOut = new ByteArrayOutputStream();

;

// 设置具体数据

List timeList = new ArrayList();

timeList.add("10:00");

timeList.add("11:00");

timeList.add("12:00");

List appList = new ArrayList();

appList.add(120);

appList.add(200);

appList.add(150);

List oraList = new ArrayList();

oraList.add(230);

oraList.add(200);

oraList.add(235);

// 设置图片中的字体和色彩和字号

Font titleFont = new Font("黑体", Font.BOLD, 12);

Font xfont = new Font("黑体", Font.BOLD, 10);

Font labelFont = new Font("黑体", Font.BOLD, 10);

// 设置数据区域

DefaultCategoryDataset dataset = new DefaultCategoryDataset();

for (int i = 0; i < timeList.size(); i++) {

String time = timeList.get(i);

dataset.addValue(appList.get(i), "苹果", time);

dataset.addValue(oraList.get(i), "橘子", time);

}

JFreeChart chart = ChartFactory.createLineChart("水果时间段销量", "时间", "销量", dataset, PlotOrientation.VERTICAL, true,

true, true);

// 设置图例字体

chart.getLegend().setItemFont(new Font("黑体", Font.BOLD, 10));

// 设置标题字体

chart.setTitle(new TextTitle(chart.getTitle().getText(), titleFont));

// 图形的绘制结构对象

CategoryPlot plot = chart.getCategoryPlot();

// 获得显示线条的对象

LineAndShapeRenderer lasp = (LineAndShapeRenderer) plot.getRenderer();

// 设置拐点是不是可见/是不是显示拐点

lasp.setBaseShapesVisible(true);

// 设置拐点不同用不同的形状

lasp.setDrawOutlines(true);

// 设置线条是不是被显示填充色彩

lasp.setUseFillPaint(false);

LineAndShapeRenderer renderer = (LineAndShapeRenderer) plot.getRenderer();

// 设置折线大小和折线的色彩

renderer.setSeriesStroke(0, new BasicStroke(1.0F));

renderer.setSeriesPaint(0, new Color(210, 105, 30));

renderer.setSeriesStroke(1, new BasicStroke(1.0F));

renderer.setSeriesPaint(1, new Color(0, 191, 255));

// 设置折点的大小

lasp.setSeriesOutlineStroke(0, new BasicStroke(0.025F));

lasp.setSeriesOutlineStroke(1, new BasicStroke(0.05F));

// 设置网格线

plot.setDomainGridlinePaint(Color.gray);

plot.setDomainGridlinesVisible(true);

plot.setRangeGridlinePaint(Color.gray);

plot.setRangeGridlinesVisible(true);

// x轴

CategoryAxis domainAxis = plot.getDomainAxis();

// 设置x轴不显示，即让x轴和数据区重合

domainAxis.setAxisLineVisible(false);

// x轴标题

domainAxis.setLabelFont(xfont);

// x轴数据倾斜

domainAxis.setCategoryLabelPositions(CategoryLabelPositions.createUpRotationLabelPositions(0.95D));

// X轴坐标上数值字体

domainAxis.setTickLabelFont(labelFont);

// 设置Y轴间隔

NumberAxis numAxis = (NumberAxis) plot.getRangeAxis();

numAxis.setTickUnit(new NumberTickUnit(50));

// y轴

ValueAxis rangeAxis = plot.getRangeAxis();

rangeAxis.setLabelFont(xfont);

// 设置y轴不显示，即和数据区重合

rangeAxis.setAxisLineVisible(false);

// y轴坐标上数值字体

rangeAxis.setTickLabelFont(labelFont);

rangeAxis.setFixedDimension(0);

CategoryPlot cp = chart.getCategoryPlot();

// 背风景设置

cp.setBackgroundPaint(ChartColor.WHITE);

cp.setRangeGridlinePaint(ChartColor.GRAY);

// 创建图例，设置图例的位置，这里的设置实际不起作用，怎样设都在下边

LegendTitle legendTitle = new LegendTitle(chart.getPlot());

legendTitle.setPosition(RectangleEdge.BOTTOM);

try {

ChartUtilities.writeChartAsPNG(byteArrayOut, chart, 400, 200);

String fileSavePath = "exTest.png";

BufferedImage bufferImg = ImageIO.read(new File(fileSavePath));

ImageIO.write(bufferImg, "png", byteArrayOut);

} catch (IOException e) {

}

// 画图的顶级管理器，1个sheet只能获得1个(1定要注意这点)

HSSFPatriarch patriarch = sheet.createDrawingPatriarch();

// 8个参数，前4个表示图片离起始单元格和结束单元格边沿的位置，

// 后4个表示起始和结束单元格的位置，以下表示从第2列到第12列，从第1行到第15行,需要注意excel起始位置是0

HSSFClientAnchor anchor = new HSSFClientAnchor(0, 0, 0, 0, (short) 2, (short) 1, (short) 12, (short) 15);

anchor.setAnchorType(3);

// 插入图片

patriarch.createPicture(anchor, wb.addPicture(byteArrayOut.toByteArray(), HSSFWorkbook.PICTURE_TYPE_PNG));

// excel2003后缀

FileOutputStream fileOut = new FileOutputStream("exTest.xls");

wb.write(fileOut);

fileOut.close();

}

}