Opened 3 months ago

Last modified 4 weeks ago

#1126 new enhancement

Cohort exporter should support exporting to Excel file

Reported by: Nicklas Nordborg Owned by:
Priority: major Milestone: Relax v1.5
Component: net.sf.basedb.relax Keywords:
Cc:

Description

Instead of creating one csv file for each item type it would be nice if the cohort exporter could export everything to a single Excel file with multiple sheets.

Requires BASE 3.15.

Change History (3)

comment:1 Changed 4 weeks ago by Nicklas Nordborg

In 5508:

References #1126: Cohort exporter should support exporting to Excel file

Added a parameter for selected file format (CSV or XLSX). The export currently save to CSV in both cases, but if XLSX is selected an empty Excel file is created.

comment:2 Changed 4 weeks ago by Nicklas Nordborg

In 5509:

References #1126: Cohort exporter should support exporting to Excel file

Added POI jar files to the project.

comment:3 Changed 4 weeks ago by Nicklas Nordborg

In 5510:

References #1126: Cohort exporter should support exporting to Excel file

Implemented support for saving the exported data to an Excel file.

A TableWriterFactory is used to create either a regular TableWriter or an XlsxTableWriter. After that, the rest of the code is more or less the same, except for cleanup

Note: See TracTickets for help on using tickets.