SYLK the shocker

Posted by chrisw on 07.15.09 to php. Subscribe to follow comments on this post. Both comments and pings are currently closed.

Very weird error - I created an excel file from PHP and returned it as excel content type, etc. as I have done a thousand times. Only this time I got a strange message from Excel saying that my file was not a valid SYLK file. Huh? Anyway, the problem was that the first cell was labeled "ID". This seems to have fooled Excel into thinking it was a SYLK file. So, my solution was simply to relabel the cell into something like Identifier (or whatever).




Return to Top