Exporting Structure and Data - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 117

<!--
- Database: 'dbbook'
-->
<dbbook>
<!-- Table authors -->
<authors>
<author_id>1</author_id>
<author_name>John Smith</author_name>
<phone>+01 445-789-1234</phone>
</authors>
<authors>
<author_id>2</author_id>
<author_name>Maria Sunshine</author_name>
<phone>333-3333</phone>
</authors>
</dbbook>
Native MS Excel (pre-Excel 2000)
Starting with version 2.6.0, phpMyAdmin offers an experimental module to export
directly in .xls format, the native spreadsheet format understood by MS Excel and
OpenOffice Calc . When this support is activated (more on this in a moment), we see
a new export choice:
We can optionally put our field names in the first row of the spreadsheet, with Put
fields names at first row .
This functionality relies on the PEAR module Spreadsheet_Excel_Writer , which
is currently at version 0.8 and generates Excel 5.0 format files. This module is
documented at http://pear.php.net/package/Spreadsheet_Excel_Writer , but
the complete installation in phpMyAdmin's context is documented here: