Merge Excel cells in php

Asked Apr 12 '21 at 11:14

Active Apr 12 '21 at 12:31

Viewed 28 times

I am writing a php file to export a report in Excel format and everything is working fine except the formatting ,

I have to merge some cells but I don't know how to do it

//header
$data = 'header1'.'\t'.'header2'.'\t'.'header3'.'\n';
//bodt    
foreach($orders as $order){
   $data .= 'data1'.'\t'.'data2'.'\t'.'data3'.'\n';
}
//footer
$data .= 'total'.'\t\t'.'\n';

I want to merge the cell "TOTAL" with the next 8 cells , how to do that ??

Thanks in advance

edited Apr 12 '21 at 12:31

Theo27

asked Apr 12 '21 at 11:14

Abdelrahman Farag

Its better you add a comment instead of devote and just run ?? – Abdelrahman Farag Apr 12 '21 at 11:19
1

Your post needs more details to be answered as well :) – Kevin M. Mansour Apr 12 '21 at 11:28
I have added example to what I want to do, I hope its more clear now – Abdelrahman Farag Apr 12 '21 at 12:31
What library are you using to work with the Excel file in PHP? – Nicholas Hunter Apr 12 '21 at 13:25
I am using PHPExcel @NicholasHunter – Abdelrahman Farag Apr 12 '21 at 13:32

Merge Excel cells in php

0 Answers0