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!