Tech Tip

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.

menu
menu