SYLK Error

July 26, 2007 by  
Filed under Scripts and Coding

Ok, I found the answer to my annoying problem.

I generated an Excel file using PHP and populated the cells with data from Mysql. The first few times worked fine, and then I started to make the Excel file ‘pretty.’ I added headers to the top, and the first field was called ‘ID’ for the id number.

Then I started getting this strange “SYLK: File format is not valid” error.

I found this which explained that if a CSV file starts with an upper case “I” or “D,” this error will occur. So I changed my header to ‘id’ and that fixed the problem!

Related Products:

All New Electronics Self-Teaching Guide (Wiley Self Teaching Guides)All New Electronics Self-Teaching Guide (Wiley Self Teaching Guides)For almost 30 years, this book has been a classic text for electronics enthusiasts. Now completely updated for today?s technology with easy explanatio... Read More >
Electronics For DummiesElectronics For DummiesElectronics is fascinating – want to make something of it? This book shows you how!

You can make all sorts of things, once you understand what ele... Read More >

(3 Packs) iPhone 4 Anti-Glare, Anti-Scratch, Anti-Fingerprint - Matte Finishing Screen Protector(3 Packs) iPhone 4 Anti-Glare, Anti-Scratch, Anti-Fingerprint - Matte Finishing Screen ProtectorProtect your iPhone 4 screen with anti-glare screen protector. Our screen protector feature full front protection for iPhone 4 screen. Protect your iPhone 4 screen with HHI screen protectors today.
Related Posts Plugin for WordPress, Blogger...

Popularity: 10% [?]