|  | 
  m vipindas - 2012-01-18 12:35:50i need to generate an excel report based on the data from database between a date span. the excel file is generated successfuly.
 but now i need to give an heading to the file, so need to merge the cells, can anybody tell me is it possible using this package.
 
 thanks
 
  Joao Rolim - 2012-04-10 18:50:38 - In reply to message 1 from m vipindasI created a new function in the class, which takes as parameters the array and the number of merged cells.
 #--------------
 
 function writeLineMerge($line_arr, $merge){
 if($this->state!="OPENED"){
 $this->error="Error : Please open the file.";
 return false;
 }
 if(!is_array($line_arr)){
 $this->error="Error : Argument is not valid. Supply an valid Array.";
 return false;
 }
 fwrite($this->fp,"<tr>");
 foreach($line_arr as $col)
 fwrite($this->fp,"<td class=xl24 width=64 colspan=$merge>$col</td>");
 fwrite($this->fp,"</tr>");
 }
 #--------------
 It's work!
  Chad Beninati - 2012-05-17 19:12:21 - In reply to message 2 from Joao RolimTry this out to keep CSS support while merging cells:
 function writeLineMerge($line_arr, $merge, $css = NULL){
 if($this->state != "OPENED"){
 $this->error="Error : Please open the file.";
 return false;
 }
 if(!is_array($line_arr)){
 $this->error = "Error : Argument is not valid. Supply an valid Array.";
 return false;
 }
 if($css!=NULL)
 {
 $cssStr = $this->getCssString($css);
 }
 
 fwrite($this->fp,"<tr>");
 foreach($line_arr as $col)
 fwrite($this->fp,"<td class=xl24 width=64 colspan=$merge $cssStr>$col</td>");
 fwrite($this->fp,"</tr>");
 }
 |