fileComponents

Class ExcelExporter

java.lang.Object

fileComponents.ExcelExporter

public class ExcelExporter
extends java.lang.Object

Utility class for easily exporting chart collection series to excel workbooks.

Since:

09/10/2015 10:40 pm

Version:

1.0.0

Author:

Alexandros Panagopoulos

Field Summary

Fields

Modifier and Type	Field and Description
private org.apache.poi.xssf.usermodel.XSSFWorkbook	workbook

Constructor Summary

Constructors

Constructor and Description
ExcelExporter()

Method Summary

Modifier and Type	Method and Description
void	ExportChartToXLS(org.jfree.data.xy.XYSeriesCollection dataset, java.lang.String filename) Export all XYSeries of XYSeriesCollection to a designated excel file

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

workbook

private org.apache.poi.xssf.usermodel.XSSFWorkbook workbook

Constructor Detail

ExcelExporter

public ExcelExporter()

Method Detail

ExportChartToXLS

public void ExportChartToXLS(org.jfree.data.xy.XYSeriesCollection dataset,
                             java.lang.String filename)
                      throws java.io.IOException

Export all XYSeries of XYSeriesCollection to a designated excel file

Used for exporting execution results to excel sheets

Parameters:

dataset - the XYSeries Collection

filename - path to file

Throws:

java.io.IOException