Gecko [ 167.86.127.34 ]

Name	Size	Permission
ExportCodegen.php	13.39 KB	-rw-r--r--
ExportCsv.php	10.79 KB	-rw-r--r--
ExportExcel.php	2.98 KB	-rw-r--r--
ExportHtmlword.php	21.48 KB	-rw-r--r--
ExportJson.php	6.56 KB	-rw-r--r--
ExportLatex.php	22.38 KB	-rw-r--r--
ExportMediawiki.php	12.03 KB	-rw-r--r--
ExportOds.php	12.23 KB	-rw-r--r--
ExportOdt.php	28.87 KB	-rw-r--r--
ExportPdf.php	10.72 KB	-rw-r--r--
ExportPhparray.php	7.17 KB	-rw-r--r--
ExportSql.php	100.32 KB	-rw-r--r--
ExportTexytext.php	19.13 KB	-rw-r--r--
ExportXml.php	17.64 KB	-rw-r--r--
ExportYaml.php	6.08 KB	-rw-r--r--
PMA_ExportPdf.php	27.35 KB	-rw-r--r--
README	6.64 KB	-rw-r--r--
TableProperty.php	6.05 KB	-rw-r--r--

Code Editor : ExportExcel.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * Class for exporting CSV dumps of tables for excel
 *
 * @package    PhpMyAdmin-Export
 * @subpackage CSV-Excel
 */
namespace PMA\libraries\plugins\export;

use PMA\libraries\properties\options\items\BoolPropertyItem;
use PMA\libraries\properties\plugins\ExportPluginProperties;
use PMA\libraries\properties\options\items\HiddenPropertyItem;
use PMA\libraries\properties\options\groups\OptionsPropertyMainGroup;
use PMA\libraries\properties\options\groups\OptionsPropertyRootGroup;
use PMA\libraries\properties\options\items\SelectPropertyItem;
use PMA\libraries\properties\options\items\TextPropertyItem;

/**
 * Handles the export for the CSV-Excel format
 *
 * @package    PhpMyAdmin-Export
 * @subpackage CSV-Excel
 */
class ExportExcel extends ExportCsv
{
    /**
     * Sets the export CSV for Excel properties
     *
     * @return void
     */
    protected function setProperties()
    {
        $exportPluginProperties = new ExportPluginProperties();
        $exportPluginProperties->setText('CSV for MS Excel');
        $exportPluginProperties->setExtension('csv');
        $exportPluginProperties->setMimeType('text/comma-separated-values');
        $exportPluginProperties->setOptionsText(__('Options'));

// create the root group that will be the options field for
        // $exportPluginProperties
        // this will be shown as "Format specific options"
        $exportSpecificOptions = new OptionsPropertyRootGroup(
            "Format Specific Options"
        );

// general options main group
        $generalOptions = new OptionsPropertyMainGroup("general_opts");
        // create primary items and add them to the group
        $leaf = new TextPropertyItem(
            'null',
            __('Replace NULL with:')
        );
        $generalOptions->addProperty($leaf);
        $leaf = new BoolPropertyItem(
            'removeCRLF',
            __('Remove carriage return/line feed characters within columns')
        );
        $generalOptions->addProperty($leaf);
        $leaf = new BoolPropertyItem(
            'columns',
            __('Put columns names in the first row')
        );
        $generalOptions->addProperty($leaf);
        $leaf = new SelectPropertyItem(
            'edition',
            __('Excel edition:')
        );
        $leaf->setValues(
            array(
                'win'           => 'Windows',
                'mac_excel2003' => 'Excel 2003 / Macintosh',
                'mac_excel2008' => 'Excel 2008 / Macintosh',
            )
        );
        $generalOptions->addProperty($leaf);
        $leaf = new HiddenPropertyItem(
            'structure_or_data'
        );
        $generalOptions->addProperty($leaf);
        // add the main group to the root group
        $exportSpecificOptions->addProperty($generalOptions);

// set the options for the export plugin property item
        $exportPluginProperties->setOptions($exportSpecificOptions);
        $this->properties = $exportPluginProperties;
    }
}

${this.title}

Code Editor : ExportExcel.php