Alan Gruskoff at
Performant Systems
submitted the following:
While my corporate clients already get output from their
MultiValue Database systems in PCL Print, PDF emails and system
FAX media, I am often asked to provide output in a spreadsheet
file. I had been usign the XLS output mode built into AccuTerm,
which works fine, but I sometimes have formatting issues. Finding
an Open Source PHP module that does CSV file to XLS file output
with a high degree of formatting, I built a shell around that to
use as a production conversion tool, to accomplish high format
XLS file creation for corporate user's consumption.
CSVtoXLS.php Program Notes
A utility to convert CSV data into business class XLS
spreadsheet files, tested as compatible with OpenOffice 2.0 Calc
and Excel 2000. The PHP Spreadsheet_Excel_Writer module provides
for a high level of formatting and also offers formulas.
CSVtoXLS.php takes advantage of those features and provides
meaningful formatting and a simple Column SUM automatically
generated at the bottom of any Decimal Column.
Download at http://performantsystems.com/CSVtoXLS.zip
The distribution CSVtoXLS.zip file contains:
CSVtoXLS.php
example.csv
/OLE and /Spreadsheet directories
README.txt
Note: the /OLE and /Spreadsheet directories need to be
copied to the php include_path directory. Sourced from http://pear.php.net/package/Spreadsheet_Excel_Wri
ter/
by Mika Tuupola & Xavier Noguer.