Download & Extend

Export to Excel support next to CSV

Project:Profile CSV
Version:6.x-1.x-dev
Component:Code
Category:feature request
Priority:normal
Assigned:Unassigned
Status:active

Issue Summary

Is anyone interested in Excel export next to CSV for this module? I wrote the code for this, and looking for a way to integrate it with the module. I found that exporting to excel is often easier for the clients (no need to split fields within excel for example), who most of the time request to see a list of people in excel format.

Comments

#1

I am interested :)

#2

So you generate Excel binaries?
Is all the code in PHP, or are you using some external libraries like Pear?

#3

I have implemented XML Excel for this (.xlsx), something like

<?xml version="1.0"?>
<ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet">
    <ss:Styles>
        <ss:Style ss:ID="1">
            <ss:Font ss:Bold="1"/>
        </ss:Style>
    </ss:Styles>
    <ss:Worksheet ss:Name="Subscriptions">
        <ss:Table>' . $data . '</ss:Table>
    </ss:Worksheet>
</ss:Workbook>';

which you can then open correctly with the latest Excel.

nobody click here