Gecko [ 35.178.45.201 ]

Name	Size	Permission
Helpers	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
ExportCodegen.php	10.99 KB	-rw-r--r--
ExportCsv.php	10.94 KB	-rw-r--r--
ExportExcel.php	2.84 KB	-rw-r--r--
ExportHtmlword.php	19.83 KB	-rw-r--r--
ExportJson.php	9.67 KB	-rw-r--r--
ExportLatex.php	21.22 KB	-rw-r--r--
ExportMediawiki.php	11.83 KB	-rw-r--r--
ExportOds.php	11.91 KB	-rw-r--r--
ExportOdt.php	27.03 KB	-rw-r--r--
ExportPdf.php	8.85 KB	-rw-r--r--
ExportPhparray.php	7.3 KB	-rw-r--r--
ExportSql.php	97.54 KB	-rw-r--r--
ExportTexytext.php	17.7 KB	-rw-r--r--
ExportXml.php	16.26 KB	-rw-r--r--
ExportYaml.php	6.33 KB	-rw-r--r--
README.md	6.4 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x

Code Editor : ExportExcel.php

<?php
/**
 * Class for exporting CSV dumps of tables for excel
 */

declare(strict_types=1);

namespace PhpMyAdmin\Plugins\Export;

use PhpMyAdmin\Properties\Options\Groups\OptionsPropertyMainGroup;
use PhpMyAdmin\Properties\Options\Groups\OptionsPropertyRootGroup;
use PhpMyAdmin\Properties\Options\Items\BoolPropertyItem;
use PhpMyAdmin\Properties\Options\Items\HiddenPropertyItem;
use PhpMyAdmin\Properties\Options\Items\SelectPropertyItem;
use PhpMyAdmin\Properties\Options\Items\TextPropertyItem;
use PhpMyAdmin\Properties\Plugins\ExportPluginProperties;

use function __;

/**
 * Handles the export for the CSV-Excel format
 */
class ExportExcel extends ExportCsv
{
    /** @psalm-return non-empty-lowercase-string */
    public function getName(): string
    {
        return 'excel';
    }

protected function setProperties(): ExportPluginProperties
    {
        $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(
            [
                '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);

return $exportPluginProperties;
    }
}

${this.title}

Code Editor : ExportExcel.php