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
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);