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:

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 >

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 >

Electronics and Circuit Analysis Study Guide: Signal Transforms, Fourier, Laplace & Z transform, Transfer function, Electronic components, Analog & Digital Circuits (Mobi Study Guides)Electronics and Circuit Analysis Study Guide: Signal Transforms, Fourier, Laplace & Z transform, Transfer function, Electronic components, Analog & Digital Circuits (Mobi Study Guides)Boost Your grades with this illustrated study guide! You will use it from an undergraduate school all the way to graduate school and beyond.
Read More >
Related Posts Plugin for WordPress, Blogger...

Popularity: 10% [?]

Stop SOPA!

SOPA breaks our internet freedom!
Any site can be shut down whether or not we've done anything wrong.

Stop SOPA!