I have a code in php that retrieves data in a database and generates a CSV file.
The client opens this CSV in excel to view the data. So far so good.
The customer's demand is that he wants to open the file in excel and he wants to also have some preformatted cells as if it were the document header - see example below:
My question is how do we do this? Should the formatting of the cell be contained within the CSV?