FM / Export

/usr/share/phpmyadmin/libraries/classes/Plugins/Export/

/usr/share/phpmyadmin/libraries/classes/Plugins/Export

Name	Size	Mode	Actions
Helpers/	-	0755	rm
ExportCodegen.php	12973	0644	edit dl rm
ExportCsv.php	11771	0644	edit dl rm
ExportExcel.php	2890	0644	edit dl rm
ExportHtmlword.php	22052	0644	edit dl rm
ExportJson.php	10285	0644	edit dl rm
ExportLatex.php	23847	0644	edit dl rm
ExportMediawiki.php	13004	0644	edit dl rm
ExportOds.php	13004	0644	edit dl rm
ExportOdt.php	30293	0644	edit dl rm
ExportPdf.php	11568	0644	edit dl rm
ExportPhparray.php	8081	0644	edit dl rm
ExportSql.php	105440	0644	edit dl rm
ExportTexytext.php	20184	0644	edit dl rm
ExportXml.php	18294	0644	edit dl rm
ExportYaml.php	6974	0644	edit dl rm
README.md	6740	0644	edit dl rm

Edit: /usr/share/phpmyadmin/libraries/classes/Plugins/Export/ExportExcel.php (2890B)

<?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;

/**
 * Handles the export for the CSV-Excel format
 */
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(
            [
                '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;
    }
}

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); $this->properties = $exportPluginProperties; } }