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

pitxels’s picture

pitxels commented

I am interested :)

dman’s picture

dman commented

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

pvhee’s picture

pvhee commented

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.