How can I stop Excel from eating my delicious CSV files and excreting useless data?
- by atroon
I have a database which tracks sales of widgets by serial number. Users enter purchaser data and quantity, and scan each widget into a custom client program. They then finalize the order. This all works flawlessly.
Some customers want an Excel-compatible spreadsheet of the widgets they have purchased. We generate this with a PHP script which…