I could actualize by customizing this plugin.
I hope that it will be embed to this plugin .. (^^;
[Summary]
The aim is the enhancement of multi-language support using Microsoft Excel.
The CSV exporting data cannot support some special characters, such as Japanese, so I developed the CSV exporting system from UTF-8 to Shift-JIS for Japanese Microsoft Excel. However, Excel data (UTF-8)
are supported UTF-8 format. This is very interesting, so I tried to add the code for exporting Excel format.
[Sample PHP code for Microsoft Excel]
item A
item B
value A
value B
?>
[Operation]
1. Copy "ExportToHtmlTable.php" file to "ExportToExcel.php"
* ExportToExcel.php
(1)
Original
class ExportToHtmlTable extends ExportBase implements CFDBExport {
Changed
class ExportToExcel extends ExportBase implements CFDBExport {
(2) Remove the CSS and JavaScript codes
(3)
Original
$this->echoHeaders('Content-Type: text/html; charset=UTF-8');
Changed
$this->echoHeaders(
array('Content-Type: application/vnd.ms-excel',
"Content-Disposition: attachment; filename=\"$formName.xls\""));
*CF7DBPluginExporter.php
(4) Added
switch ($encoding) {
......
......
......
case 'EXCEL':
require_once('ExportToExcel.php');
$exporter = new ExportToExcel();
$exporter->export($formName);
break;
......
default:
}
* CFDBViewShortCodeBuilder.php
(5) Addded
*CFDBViewWhatsInDB.php
(6) Added