Opened 5 years ago

Closed 5 years ago

#1126 closed enhancement (fixed)

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 (4)

comment:1 by Nicklas Nordborg, 5 years ago

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 by Nicklas Nordborg, 5 years ago

In 5509:

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

Added POI jar files to the project.

comment:3 by Nicklas Nordborg, 5 years ago

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

comment:4 by Nicklas Nordborg, 5 years ago

Resolution: → fixed
Status: new → closed

Seems to be working without any problems.

Note: See TracTickets for help on using tickets.