Exporting Structure and Data - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 124

- phpMyAdmin XML Dump
- version 2.11.0
- http://www.phpmyadmin.net
-
- Host: localhost
- Generation Time: Sep 16, 2007 at 01:13 PM
- Server version: 5.0.45
- PHP Version: 5.2.4
-->
<!--
- Database: 'marc_book'
-->
<marc_book>
<!-- Table author -->
<author>
<id>1</id>
<name>John Smith</name>
<phone>+01 445-789-1234</phone>
</author>
<author>
<id>2</id>
<name>Maria Sunshine</name>
<phone>333-3333</phone>
</author>
</marc_book>
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, Native MS Excel , and the following options:
We can optionally put our field names in the first row of the spreadsheet, with Put
fields names in the first row .