sampleDataExcel.blade.php 591 Bytes
<?php

 include_once(app_path().'/lib/phpexcel/PHPExcel.php');
  
  $inputFileType = "Excel5";
  $objReader = PHPExcel_IOFactory::createReader($inputFileType);
  $objPHPExcel = $objReader->load("assets/extras/blank.xls");
  $baseRow = 2;

  $objPHPExcel->getActiveSheet()->setCellValue('A1', "12");

  
  header('Content-Type: application/vnd.ms-excel');
  header('Content-Disposition: attachment;filename="Output.xls"');
  header('Cache-Control: max-age=0');

  $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $inputFileType);
  $objWriter->save('php://output');

  return ;

?>