logo
Powered by QM on a Rpi server
Home
About OpenQM
Sales and Downloads
Help and Support
  QM Help Pages
  KnowledgeBase
  Tip of the Week
  Support Services
  User Group Forum
About
Login

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.

See http://performantsystems.com/CSVtoXLS.html



Note: The text for this page was provided by the software supplier. Ladybridge Systems cannot guarantee its accuracy and does not specifically endorse the product.