<?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');