<?php
require_once 'Writer.php';
// Creating a workbook
$workbook = new Excel_Writer();
// sending HTTP headers
$workbook->send('test.xls');
// Creating a worksheet
$worksheet1 =& $workbook->addWorksheet('Movitex');
// The actual data
$worksheet1->setInputEncoding('CP1251');
$worksheet1->write(0, 0, 'Name');
$worksheet1->write(0, 1, 'Age');
$worksheet1->write(1, 0, 'John Smith');
$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');
