require_once 'PHPExcel.php'; $objPHPExcel = new PHPExcel(); // Create new worksheet $mySheet = $objPHPExcel->createSheet(); $mySheet->setTitle("MySheet");
require_once 'PHPExcel.php'; $objPHPExcel = new PHPExcel(); // Create new worksheet $mySheet = $objPHPExcel->createSheet(); $mySheet->setTitle("MySheet"); // Add data to worksheet $mySheet->setCellValue('A1', 'Name') ->setCellValue('B1', 'Mark') ->setCellValue('A2', 'John') ->setCellValue('B2', '80') ->setCellValue('A3', 'Jane') ->setCellValue('B3', '90'); // Set background color of cells A1 to B2 to yellow $mySheet->getStyle('A1:B2')->applyFromArray(array( 'fill' => array( 'type' => PHPExcel_Style_Fill::FILL_SOLID, 'color' => array('rgb' => 'FFFF00') ) ));Package/Library: PHPExcel