Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

CSVtoXLS: A Utility to Convert CSV data into XLS Spreadsheets
Apr 23, 2007 @ 08:38:00

On the PHPBuilder.com site today, they spotlight a handy tool that can be used to translate CVS data into an XLS spreadsheet quickly and easily.

CSVtoXLS is a utility that is used to convert CSV data into business class XLS spreadsheet files, and is compatible with OpenOffice 2.0 Calc and Excel 2000. The 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 is automatically generated at the bottom of any Decimal Column.

The utility is simple to use - they give you the command to execute and how to format your CVS data for optimal results. There's also some simple installation steps and a sample test script to get you started.

tagged: xls cvs data spreadsheets cvstoxls utility download xls cvs data spreadsheets cvstoxls utility download