用poi3和chartdirect生成带图表的excel报表

源码如下：

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.File;

import java.io.ByteArrayOutputStream;

import java.io.IOException;

import java.util.ArrayList;

import java.util.List;

 

import java.awt.Image;

import java.awt.image.BufferedImage;

import javax.imageio.*;

 

import org.apache.poi.hssf.model.PictureShape;

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

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

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

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

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

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

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

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

import org.apache.poi.poifs.filesystem.POIFSFileSystem;

 

import ChartDirector.Chart;

import ChartDirector.ChartViewer;

import ChartDirector.LineLayer;

import ChartDirector.XYChart;

 

public class TestPOI

{

 

public static void main(String[] args)

{

FileOutputStream fileOut = null;

 

try

{

 

// 创建一个图片

double[] data0 = { 42, 49, 33, 38, 51, 46, 29, 41, 44, 57, 59, 52,

37, 34, 51, 56, 56, 60, 70, 76, 6