Excel format design

hi all

I need to display the following format in my Excel how can I do using php (cakephp) .I have attached the image.Can I use html to Excel or any other Excel libraries to get like this.please check the image and help me.

Thanks

Unless you are using a Windows server you are not going to get an Excel file, and then with the Windows server you would have to have Excel installed and then use the COM library.

My suggestion is generate a CSV file and then you can simply read it in Excel like a normal excel file. As for formatting it with colors I do not think you can do that.