Export a chart to excel / pdf ?

[mohit_singhal]

Hi,

Can anybody help me in exporting a generated chart (or dataset) to excel file & pdf file.

Thanks in advance,
Mohit

[djprice]

I am using iText (http://www.lowagie.com/iText/) to create and write to a pdf.

First I have an accessor class:
private byte resultGraph3[];
public byte[] getResultGraph3()
{
return (this.resultGraph3);
}
public void setResultGraph3(byte[] byteIn)
{
this.resultGraph3 = byteIn;
}


Then I write the chart to the byte[] in the accessor class:
JFreeChart chart = createChart3(dataset, ac);
ByteArrayOutputStream bos = new ByteArrayOutputStream();
int width = 700;
int height = 500;
ChartUtilities.writeChartAsPNG(bos, chart, width, height);
ac.setResultGraph3(bos.toByteArray());
bos.close();

Now I can use iText to write out the image inside the PDF:
Image graph1 = Image.getInstance(ac.getResultGraph3());
vTable1.addCell(graph1);
document.add(vTable1);

[mohit_singhal]

Thanks buddy .. will try n implement this ... can u please let me know how to export to excel.

[djprice]

Unfortunately, I cannot help with Excel since I have never exported a chart to Excel. Maybe someone else on this forum has and can post a suggestion.

[mohit_singhal]

okies ... not a problem

[jwenting]

Excel generates charts based on data from an excel workbook.
You could use something like POI or XSL:FO to generate an Excel workbook and probably to put in the commands to generate the chart there.

[mohit_singhal]

actually, I have to export in such a way that data from chart is displayed in tabular form. I mean the form in which it is stored in the dataset.

[david.gilbert]

Regarding PDF, iText has a nice PdfGraphics2D class which allows you to create charts in vector format within the PDF, which allows nicer scaling (compared to embedding an image in the PDF file).

[jwenting]

actually, I have to export in such a way that data from chart is displayed in tabular form. I mean the form in which it is stored in the dataset.

Well, that's not what JFreeChart is for.
Export it from the layer which calls JFreeChart to create the chart instead.

[Kousu]

So you don't *actually* need Excel, do you? Just use .csv (which Excel can open but does not lock you in to Microsoft). Check out http://opencsv.sf.net, it's very small and nice and clean.