This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes Coping a chart from one Excel to another using POI. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Coping a chart from one Excel to another using POI." Watch "Coping a chart from one Excel to another using POI." New topic
Author

Coping a chart from one Excel to another using POI.

Saifuddin Merchant
Ranch Hand

Joined: Feb 08, 2009
Posts: 597

Hi All...

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?


Cheers - Sam.
Twisters - The new age Java Quiz || My Blog
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Coping a chart from one Excel to another using POI.
 
Similar Threads
Copying a sheet from an excel file to another excel file using Apache POI
How to Edit an Excel File with Java
Reading only text content of the foruma cell + POI 3.5
POI invocation target exception
Getting number of rows and column from Excel, using JXL library