Coping a chart from one Excel to another using POI.

[Saifuddin Merchant]

Hi All...

I am trying to copy a Chart from one Excel to another using HSSF POI. Here is what I been trying out ...

HSSFChart[] chartList = HSSFChart.getSheetCharts(sheet);  //The Sheet belongs to a workbook abc.xls
if (chartList != null){
for (HSSFChart chart:chartList){
	System.out.println("Height:"+chart.getChartHeight());
	System.out.println("Width"+chart.getChartWidth());
	System.out.println("xOffset:"+chart.getChartX());
	System.out.println("yOffset:"+chart.getChartY());
	System.out.println("title:"+chart.getChartTitle());
	chart.createBarChart(tempWB, tempSheet);    //This is a different workbook say xyz.xls with some sheet ...

My question in particular is how does the chart.createBarChart work? Does it allow you to create a new chart in any document or only in that document from which the chart object (chartList) has been retrieved.

BTW - The above code throws me an null pointer exception when I try to write the excel using tempWB.write(out);

I got a second question - Is there any way to just copy an entire sheet in POI from one work book to another. Currently I am reading each cell - determining its type - copying the style and so on. Is there any way to just copy the entire sheet as is without bothering what its content is?