Export Mysql data to a customized XLS file using php -

first of all, know process of exporting mysql data excel file using php. have specific requirement , want know if can done or not. have googled, didn't specific information or method regarding same.

this xls template :

overview:

column c fixed , others scrollable. there couple of organizations.

data starting col-c8 col-l8 stored on mysql table of organization (e.g. organization1).

data of col-c1 col-c5 & d1 d5 on mysql table of organization1.

so every organization there 2 different mysql tables.

requirement :

the goal export data mysql , add excel file according image above.

problem :

adding data mysql table excel pretty easy if requirement replicate same on excel sheet. have no idea how customization.

like pulling data 2 different tables , adding them different columns in excel sheet.

please let me know if possible. , if yes, kindly direct me references on how achieve this.

thank you!

try phpexcel. library allows read , write from/to .xls files.