Make Pivot Table downloadable with exact display layout

Registered by Aatish Neupane on 2018-03-20

Downloading a pivot table in its original display layout is sometimes very useful. It caters to users who have no experience working with Excel based pivot tables.

A MIME type application/vnd.openxmlformats-officedocument.spreadsheetml.sheet supports HTML based tables and can be opened in Microsoft Excel and LibreOffice Calc without issues.

Implementing downloadable pivot tables this way is relatively easy. I have made a POC pull request https://github.com/dhis2/pivot-tables-app/pull/89 to the pivot-tables-app.

This pull request uses the above-mentioned MIME type to generate a XLS file from within the browser (no API calls). It uses a well-known library FileSaver.js to make this generation cross-browser compatible.

Blueprint information

Status:
Not started
Approver:
None
Priority:
Undefined
Drafter:
Aatish Neupane
Direction:
Needs approval
Assignee:
None
Definition:
New
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.