1 |
a45e4bc1
|
Assos Assos
|
<?php
|
2 |
|
|
|
3 |
|
|
/**
|
4 |
|
|
* The Excel exporter currently is just a tab-delimited export.
|
5 |
|
|
*/
|
6 |
|
|
class webform_exporter_excel_delimited extends webform_exporter_delimited {
|
7 |
feca1e4a
|
Assos Assos
|
|
8 |
|
|
/**
|
9 |
01f36513
|
Assos Assos
|
* {@inheritdoc}
|
10 |
feca1e4a
|
Assos Assos
|
*/
|
11 |
|
|
public function __construct($options) {
|
12 |
a45e4bc1
|
Assos Assos
|
$options['delimiter'] = '\t';
|
13 |
|
|
parent::__construct($options);
|
14 |
|
|
}
|
15 |
|
|
|
16 |
feca1e4a
|
Assos Assos
|
/**
|
17 |
01f36513
|
Assos Assos
|
* {@inheritdoc}
|
18 |
feca1e4a
|
Assos Assos
|
*/
|
19 |
|
|
public function bof(&$file_handle) {
|
20 |
a45e4bc1
|
Assos Assos
|
$output = '';
|
21 |
|
|
|
22 |
|
|
// Include at BOM at the beginning of the file for Little Endian.
|
23 |
|
|
// This makes tab-separated imports work correctly in MS Excel.
|
24 |
|
|
if (function_exists('mb_convert_encoding')) {
|
25 |
|
|
$output = chr(255) . chr(254);
|
26 |
|
|
}
|
27 |
|
|
@fwrite($file_handle, $output);
|
28 |
|
|
}
|
29 |
|
|
|
30 |
feca1e4a
|
Assos Assos
|
/**
|
31 |
01f36513
|
Assos Assos
|
* {@inheritdoc}
|
32 |
feca1e4a
|
Assos Assos
|
*/
|
33 |
01f36513
|
Assos Assos
|
public function add_row(&$file_handle, array $data, $row_count) {
|
34 |
a45e4bc1
|
Assos Assos
|
foreach ($data as $key => $value) {
|
35 |
|
|
// Escape inner quotes and wrap all contents in new quotes.
|
36 |
|
|
$data[$key] = '"' . str_replace('"', '""', $data[$key]) . '"';
|
37 |
|
|
|
38 |
|
|
// Remove <script> tags, which mysteriously cause Excel not to import.
|
39 |
|
|
$data[$key] = preg_replace('!<(/?script.*?)>!', '[$1]', $data[$key]);
|
40 |
|
|
}
|
41 |
|
|
$row = implode($this->delimiter, $data) . "\n";
|
42 |
|
|
|
43 |
|
|
if (function_exists('mb_convert_encoding')) {
|
44 |
|
|
$row = mb_convert_encoding($row, 'UTF-16LE', 'UTF-8');
|
45 |
|
|
}
|
46 |
|
|
|
47 |
|
|
@fwrite($file_handle, $row);
|
48 |
|
|
}
|
49 |
|
|
|
50 |
feca1e4a
|
Assos Assos
|
/**
|
51 |
01f36513
|
Assos Assos
|
* {@inheritdoc}
|
52 |
feca1e4a
|
Assos Assos
|
*/
|
53 |
|
|
public function set_headers($filename) {
|
54 |
a45e4bc1
|
Assos Assos
|
drupal_add_http_header('Content-Type', 'application/x-msexcel');
|
55 |
|
|
drupal_add_http_header('Content-Disposition', "attachment; filename=$filename.xls");
|
56 |
|
|
drupal_add_http_header('Pragma', 'public');
|
57 |
|
|
drupal_add_http_header('Cache-Control', 'max-age=0');
|
58 |
|
|
}
|
59 |
feca1e4a
|
Assos Assos
|
|
60 |
a45e4bc1
|
Assos Assos
|
} |