PHP & Excel

I have a form made in PHP.

On completing the form the data is enterred into an Excel file with some of the PHP code contained within the form.

Everything works fine apart from the lines in Excel are not spaced properly & the headings aren’t formatted in bold etc. This is a bit of a pain in the *****, as evertime I download the file and filter the entries, I have to space everything out again and it looks messy unless I format the headings!

Currently the Excel file I am putting the data into is saved as a “text - tab delimited” Excel file. It won’t enter the data if I save it as a normal excel file, but it appears that this is the only way I can keep the headings and cell spacing in a formatted manner.

Is there anyway I can keep the formatted cells & headings within Excel and enter the data with the formatted headings & cells already in place?

If it’s not possible please let me know!

There is a PEAR class and also some other excel classes at . I have not used the PEAR class, but used a mySQL2Excel class and it was fine, with proper headings and everything. I think you might look into more direct methods rather than a comma delimited file.

You may have to get the admins to install this class.