PHP Excel - 在linux下无效[关闭]

Question

PHP excel download its working perfectly in windows environment.

The data fetched from database is correct.

requirements of PHP excel is there.

setcellvalue is not working i think

Please suggest me how to proceed further

Answer 1

use setCellValueByColumnAndRow instead like this function that add array to excel file it must work

function ADDFExcel($FileName,$Array){//add Date
          if(!is_file($FileName)){
            fclose(fopen($FileName,"a+"));  
          }
          $objPHPExcel = PHPExcel_IOFactory::load($FileName);
          $objWorksheet = $objPHPExcel->getActiveSheet();
          foreach($Array as $Record)
          {
              $num_rows = $objPHPExcel->getActiveSheet()->getHighestRow();
              $i=0;
              foreach($Record as $Fild){
                  $objWorksheet->setCellValueByColumnAndRow($i,$num_rows+1,$Fild,PHPExcel_Style_NumberFormat::FORMAT_TEXT );
                  $i++;
              }  
          }
          $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
          $objWriter->save($FileName);
}

$arr=array(
        array("we","gs","423"),
        array("dg","asd","45345")
 );
 ADDFExcel("1.xlsx",$arr);