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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
| <html>
<head>
</head>
<body >
<?php
/** Error reporting */
error_reporting(E_ALL);
/** Include path **/
ini_set('include_path', ini_get('include_path').';C:\\php\\PEAR\\PHPExcel\\;C:\\program files\\php\\pear\\PHPExcel\\');
/** PHPExcel */
include './scripts/phpexcel/Classes/PHPExcel.php';
/** PHPExcel_Writer_Excel2007 */
//include 'PHPExcel/Writer/Excel2007.php';
// Create new PHPExcel object. Start drawing wait bar
/*
* echo "<html><head><title>MCA CRM Report Generator</title></head><body>\r\n";
* echo "<span id=\"preload\">Generating Report, please wait...</span>\r\n";
* echo "<span id=\"loadbar\"></span>\r\n";
*/
$objPHPExcel = new PHPExcel();
// Set properties
// echo date('H:i:s') . " Set properties\n";
$objPHPExcel->getProperties()->setCreator("MCA CRM Reporting");
$objPHPExcel->getProperties()->setLastModifiedBy("MCA CRM Reporting");
$objPHPExcel->getProperties()->setTitle("Dashboard By Sales Rep");
$objPHPExcel->getProperties()->setSubject("Dashboard By Sales Rep");
$objPHPExcel->getProperties()->setDescription("List of assigned clients by sales rep.");
// Add some data
// echo date('H:i:s') . " Add some data\n";
$objPHPExcel->setActiveSheetIndex(0);
// Here we populate the cells
// echo date('H:i:s') . "Generating Report...\r\n";
$objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Sales Rep');
$objPHPExcel->getActiveSheet()->SetCellValue('B1', 'Company Name');
$objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Client Status');
$objPHPExcel->getActiveSheet()->SetCellValue('D1', 'Color Code');
$objPHPExcel->getActiveSheet()->SetCellValue('E1', 'Last Call Date');
$objPHPExcel->getActiveSheet()->SetCellValue('F1', 'Last Call Status');
$objPHPExcel->getActiveSheet()->SetCellValue('G1', 'Last Call Spoke With');
$objPHPExcel->getActiveSheet()->SetCellValue('H1', 'Next Callback Date');
$objPHPExcel->getActiveSheet()->SetCellValue('I1', 'Last Call Sale Status');
$objPHPExcel->getActiveSheet()->SetCellValue('J1', 'State');
$objPHPExcel->getActiveSheet()->SetCellValue('K1', 'Sale Cycle Status');
$objPHPExcel->getActiveSheet()->SetCellValue('M1', 'Generated on:');
$objPHPExcel->getActiveSheet()->SetCellValue('N1', date('m/d/Y H:i:s'));
$objPHPExcel->getActiveSheet()->SetCellValue('M2', 'Number of Records:');
/*
* echo "<script type=\"text/javascript\">\r\n";
* echo " document.getElementById('preload').innerHTML = 'Nearly finished, please wait...';\r\n";
* echo "</script>\r\n";
*/
// echo date('H:i:s') . "Finished generation, cleanup and output...\r\n";
// Auto-fit the columns
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('Report');
// Save Excel 2007 file
// echo date('H:i:s') . " Write to Excel2007 format\n";
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save('toto.xlsx');
//header ('Location:open_excel_file.php?file=toto.xlsx');
header ("content-type: application/vnd.ms-excel");
header("Content-Disposition:inline;filename=toto.xlsx");
// Echo done
// echo date('H:i:s') . " Done writing file.\r\n";
/*
* echo "<script type=\"text/javascript\">\r\n";
* echo " document.getElementById('preload').innerHTML = 'Finished!';\r\n";
* echo " window.location = '" . str_replace('.php', '.xlsx', $_SERVER["PHP_SELF"]) . "';\r\n";
* echo "</script>\r\n";
* echo "</body></html>";
*/
?>
<?php
echo "Done."
?>
</body>
</html> |
[PHPExcel] Problème de conversion
Répondre avec citation
Partager