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
|
$localFile = 'test.xls';
$workbook = &new writeexcel_workbook($localFile);
// Création des onglets "synthèse"
$worksheets = array();
$worksheets['Synthèse']['quotidienne'] =& $workbook->addworksheet("Synthese_quotidienne");
$style['synthese']['content'] =& $workbook->addformat(array(
'size' => 10,
'text_wrap' => 1,
'align' => 'center',
'text_v_align' => '1',
'font' => 'Arial',
'color' => 'black',
'border' => 1,
'border_color' => 'black',
'bold' => 0,
'num_format' => '0'
));
$worksheets['Synthèse']['quotidienne']->write(0, 0, 1, $style['synthese']['content']);
$worksheets['Synthèse']['quotidienne']->write(1, 0, 1, $style['synthese']['content']);
$worksheets['Synthèse']['quotidienne']->write(2, 0, 2, $style['synthese']['content']);
$worksheets['Synthèse']['quotidienne']->write(0, 1, 2, $style['synthese']['content']);
$worksheets['Synthèse']['quotidienne']->write(1, 1, 3, $style['synthese']['content']);
$worksheets['Synthèse']['quotidienne']->write(2, 1, 4, $style['synthese']['content']);
$worksheets['Synthèse']['quotidienne']->write(4, 0, '=SUMIF(A1:A4,"1",B1:B4)', $style['synthese']['content']);
$workbook->close(); |
Partager