Exemplo n.º 1
0
 /**
  * Extend standard worksheet by fixing width of last column (errors)
  *
  * @param string $title Name of worksheet
  * @param array  $data  Data to Export
  *
  * @return object PHPExcel_Worksheet
  */
 function createWorksheet($title, $data)
 {
     $xlWS = parent::createWorksheet($title, $data);
     $xlWS->getDefaultRowDimension()->setRowHeight(-1);
     $numcols = count(array_keys($data[0]));
     for ($lastcol = 'A', $i = 1; $i < $numcols; $i++) {
         $lastcol++;
     }
     $lastrow = count($data) + 1;
     // Format the last column (errors)
     $xlWS->getColumnDimension($lastcol)->setAutoSize(false)->setWidth(75);
     $xlWS->getStyle($lastcol . '1:' . $lastcol . $lastrow)->getAlignment()->setWrapText(true);
     // Auto row height
     /* This doesn't seem to work
     	//$xlWS->getDefaultRowDimension()->setRowHeight(-1);
     	foreach($xlWS->getRowDimensions() as $row) {
     		$row->setRowHeight(-1);
     	}
     */
     return $xlWS;
 }
Exemplo n.º 2
0
<?php

/**
 * Excel export inscriptions boum
 *
 */
require_once 'core.php';
$xl = new ExcelBase('Boum ' . date('Y'), "Inscriptions à la Boum de l'Escalade " . date('Y'), 'boum');
$xl->setDefaultFontSize(10);
// Process Enfants
$sql = "SELECT * FROM " . VIEW_BOUM_ENFANTS;
$qry = $db->query($sql);
$xl->createWorksheet('Enfants', $qry->fetchAll());
// Process Parents
$sql = "SELECT * FROM " . VIEW_BOUM_PARENTS;
$qry = $db->query($sql);
$xl->createWorksheet('Parents', $qry->fetchAll());
// Process Totals
$sql = "SELECT * FROM " . VIEW_BOUM_TOTAUX;
$qry = $db->query($sql);
$xl->createWorksheet('Totaux', $qry->fetchAll());
$xl->workbook->setActiveSheetIndex(0);
$xl->saveExcel();