CSV to XML conversion utility

I am often asked to provide output from the database in a spreadsheet
XLS file. I had been using the XLS output mode built into AccuTerm,
which works fine, but I wanted more formatting control. 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 from an ASCII CSV file, for corporate user's consumption. As
a PHP program, it should work on any O/S that you can install PHP 4.3
or better onto.

CSVtoXLS.php Program Notes

A PHP utility to convert CSV data into business class XLS spreadsheet
files, tested as compatible with OpenOffice 2.0 Calc and Excel 2000.
It is provides for a high level of spreadsheet 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.

See Narrative, Example and free Download at http://performantsystems.com/CSVtoXLS.html

Alan:

There is a new verb in OpenQM that does something like what you are
trying. On Friday, Tom deLombarde explained it to me over lunch.
Because I am not a coder I don't fully grasp it but in essence it
brings English/Access like functionality directly into DataBasic so
you can bring a full aray in a spreadsheep like format directly out of
OpenQM.

Perhaps Martin or Tom can elaborate further.

Henry Keultjes
Database Scientifics

On Apr 11, 4:14 pm, "Alan Gruskoff" <l... (AT) performantsystems (DOT) com>
wrote: