Export to Excel support next to CSV
pvhee - January 14, 2009 - 15:18
| Project: | Profile CSV |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
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.
#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.