CSV to XLS Conversion Utility
By Alan Gruskoff, Performant Systems
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.
Note: The text for this page was provided by the software supplier. Ladybridge
Systems cannot guarantee its accuracy and does not specifically endorse