Add .xlsx support to spreadsheet export/import

Description

Since Apache POI has released 3.5-FINAL which includes support for .xlsx, this JIRA is to implement reading in .xlsx files and exporting them.

From reading the notes, 3.5 has a new generic API which should allow for both XLS97 and OOXML, so hopefully this just means changing some packages and minor adjustments.

Attachments

4

Activity

Show:

David Woods August 3, 2011 at 2:53 PM

QA Test

exported from all combinations of gradebook style and mode, as both "grades only" and "grades & structure". All appeared to export properly, including the structure for all for "grades & structure" and excluding the structure for all for "grades only".

QA Pass

Thomas Amsler August 1, 2011 at 10:27 PM

I will deploy this in the morning of August 2, 2011 as part of gradebook2 1.6.0-rc1

Jon Gorrono August 1, 2011 at 6:55 PM

that's not been tagged yet (rc3)

David Woods August 1, 2011 at 3:12 PM

That leaves the problem of not including the structure when 'Export' => 'Grades & Structure' => '.xlsx' is chosen. It looks like the 'Grades Only' code is being invoked instead.

Still:

QA Fail

David Woods August 1, 2011 at 3:06 PM

created to document tab name error in .xlsx file creation.

Fixed

Details

Assignee

Reporter

QA Status

PASS

Components

Fix versions

Priority

Created November 3, 2009 at 9:44 AM
Updated August 3, 2011 at 2:54 PM
Resolved July 29, 2011 at 6:19 PM