-
Notifications
You must be signed in to change notification settings - Fork 0
/
Exporttoexcel.php
48 lines (36 loc) · 1.56 KB
/
Exporttoexcel.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
<?php
App::import('Vendor', 'PHPExcel', array('file' =>'PHPExcel' . DS . 'PHPExcel.php'));
class Exporttoexcel
{
function ExporttoExcel($excelData,$fileName)
{
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set document properties
$objPHPExcel->getProperties()->setCreator("Me")->setLastModifiedBy("Me")->setTitle("My Excel Sheet")->setSubject("My Excel Sheet")->setDescription("Excel Sheet")->setKeywords("Excel Sheet")->setCategory("Me");
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Add column headers
$objPHPExcel->getActiveSheet()
->setCellValue('A1', 'Keyword')
->setCellValue('B1', 'G_Volume')
->setCellValue('C1', 'US_Volume')
->setCellValue('D1', 'Type');
//->setCellValue('E1', 'CPC');
//cell values
for($i=0; $i<=count($excelData); $i++)
{
$ii = $i+2;
$objPHPExcel->getActiveSheet()->setCellValue('A'.$ii, $excelData[$i]['k']['Keyword']);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$ii, $excelData[$i]['k']['G_Volume']);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$ii, $excelData[$i]['k']['US_Volume']);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$ii, $excelData[$i]['k']['Type']);
//$objPHPExcel->getActiveSheet()->setCellValue('E'.$ii, $excelData[$i]['k']['CPC']);
}
// Set worksheet title
$objPHPExcel->getActiveSheet()->setTitle($fileName);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('Export_csv/'.$fileName);
}
}
?>