Example #1
0
File: test.php Project: romlg/cms36
$worksheet1->write(1, 1, 30);
$worksheet1->write(2, 0, 'Johann Schmidt');
$worksheet1->write(2, 1, 31);
$worksheet1->write(3, 0, 'Juan Herrera');
$worksheet1->write(3, 1, 32);
//void Worksheet::setOutline ([bool $visible=true [, bool $symbols_below=true [, bool $symbols_right=true [, bool $auto_style=false]]]])
$worksheet1->setOutline(true, false, true, false);
$worksheet1->freezePanes(array(8, 0, 8, 0, 2));
$worksheet1->mergeCells(0, 1, 5, 4);
$worksheet1->setRow(12, 15, 0, 0, 1);
$worksheet1->setRow(13, 15, 0, 0, 2);
$worksheet1->setRow(14, 15, 0, 0, 2);
$worksheet1->setRow(15, 15, 0, 0, 1);
//void Worksheet::setOutline ([bool $visible=true [, bool $symbols_below=true [, bool $symbols_right=true [, bool $auto_style=false]]]])
// Let's send the file
$workbook->close();
//require_once('OLEwriter.php');
//require_once('BIFFwriter.php');
/*
  require_once('Worksheet.php');
  require_once('Workbook.php');

  function HeaderingExcel($filename) {
      header("Content-type: application/vnd.ms-excel");
      header("Content-Disposition: attachment; filename=$filename" );
      header("Expires: 0");
      header("Cache-Control: must-revalidate, post-check=0,pre-check=0");
      header("Pragma: public");
}

  // HTTP headers