Posts Tagged ‘excel’
PHP/CSV Tip
Just a quick tip that might help out some other developer out there. I am using PHP's fgetcsv function to import comma-separated data that has been exported from an Excel spreadsheet.
It was giving me fits though - skipping over null values and throwing everything out of wack. If you are having this problem, there is a good chance you are using a Mac (like I am) and just saving as a "Comma Separated Values (.csv)" file. While this seems logical. BUZZZZZZZ! I guess it is wrong. You have to save as "Windows Comma Separated (.csv)" file. This solves everything.




































