What is the ideal approach to export reports to Excel and CSV using
JasperReports?
I am using iReport designer to export reports into PDF format and CSV
formats. Now for the PDF format, everything seems perfect, but when I use
the same design to export to CSV, the whole layout goes haywire. I would
document all the necessary research i have gathered. Let's have a look at
the report format in PDF and then CSV.
PDF Format
CSV Format
Here is the research gathered.
PDF format is pixel perfect reports where CSV reports.
We can use CSVMetaDataExporter in order to just extract the data and set
the column names describing the types and data using export parameters.
Though i have not used the second option still.
So my basic question is, if we want to use the same template to export CSV
or Excel, we would be obviously running into alignment and width issues. I
exported the report to Excel as well and in the Excel format the results
were not at all satisfactory. So in this context, is JasperReports really
a correct choice to opt for Excel and CSV formats? If it is, what is the
ideal approach to deal with such output formats?
No comments:
Post a Comment