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.
Chapter 7
[ 131 ]
This functionality relies on the PEAR module Spreadsheet_Excel_Writer, which
is currently at version 0.9.1 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:
1. Ensure that the PHP server has PEAR support. (The pear command will fail
if we do not have PEAR support.) PEAR itself is documented at
http://pear.php.net.
2. If we are running PHP in safe mode, we have to ensure that we are allowed
to include the PEAR modules. Assuming the modules are located under; /
usr/local/share/pear, we should have the line safe_mode_include_dir
= /usr/local/share/pear in php.ini.
3. We then install the module with: pear -d preferred_state=beta install
-a Spreadsheet_Excel_Writer (because the module is currently in beta
state). This command fetches the necessary modules over the Internet and
installs them into our PEAR infrastructure.
Pages:
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139