libraries/export/excel.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Set of functions used to build CSV dumps of tables for excel
   5  *
   6  * @package PhpMyAdmin-Export
   7  * @subpackage CSV-Excel
   8  */
   9 if (! defined('PHPMYADMIN')) {
  10     exit;
  11 }
  12
  13 /**
  14  *
  15  */
  16 if (isset($plugin_list)) {
  17     $plugin_list['excel'] = array(
  18         'text' => __('CSV for MS Excel'),
  19         'extension' => 'csv',
  20         'mime_type' => 'text/comma-separated-values',
  21         'options' => array(
  22             array('type' => 'begin_group', 'name' => 'general_opts'),
  23             array('type' => 'text', 'name' => 'null', 'text' => __('Replace NULL with:')),
  24             array('type' => 'bool', 'name' => 'removeCRLF', 'text' => __('Remove carriage return/line feed characters within columns')),
  25             array('type' => 'bool', 'name' => 'columns', 'text' => __('Put columns names in the first row')),
  26             array(
  27                 'type' => 'select',
  28                 'name' => 'edition',
  29                 'values' => array(
  30                     'win' => 'Windows',
  31                     'mac_excel2003' => 'Excel 2003 / Macintosh',
  32                     'mac_excel2008' => 'Excel 2008 / Macintosh'),
  33                 'text' => __('Excel edition:')),
  34             array('type' => 'hidden', 'name' => 'structure_or_data'),
  35             array('type' => 'end_group'),
  36             ),
  37         'options_text' => __('Options'),
  38         );
  39 } else {
  40     /* Everything rest is coded in csv plugin */
  41     include './libraries/export/csv.php';
  42 }
  43 ?>