I am trying to copy a Chart from one Excel to another using HSSF POI. Here is what I been trying out ...
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?